def get_input_from_user(idwant=False):
eid = 0
if idwant:
print('Enter Values for Add Operations')
eid = int(input('Enter Emp Id : '))
else:
print('Enter Values for update Operations')
name = input('Enter Emp Name : ')
eage = int(input('Enter Emp Age : '))
esal = float(input('Enter Emp Salary : '))
role = input('Enter Emp Role : ')
return Employee(eid, name, eage, esal, role)
def get_all_employees(self):
file = get_file_instance('VIEW')
alllines = [line.strip() for line in file.readlines()]
emplist = []
for line in alllines:
row = line.split(SEPERATOR)
emplist.append(
Employee(eid=row[0],
enm=row[1],
eag=row[2],
esal=row[3],
erol=row[4]))
return emplist
def get_all_employees(self): # exe
allemps = []
workbook = get_workbook_instance()
sheet = workbook['empdata']
noofrows = sheet.max_row # 4
for item in range(noofrows): # 0 1 2 3 --> indexing--> 0
if item == 0: #header asel # 1 2 3 4 --> A1[header] B1
continue
item = item + 1 #1+1 -->2
#print(item)
eid = sheet['A' + str(item)].value #A2
enm = sheet['B' + str(item)].value
eag = sheet['C' + str(item)].value
esal = sheet['D' + str(item)].value
erol = sheet['E' + str(item)].value
allemps.append(Employee(eid, enm, eag, esal, erol))
return allemps
def get_all_employees(self):
file = get_file_instance('VIEW')
allemps = []
try:
allemps = json.loads(file.read())
except:
return allemps
emplist = []
for line in allemps:
emplist.append(
Employee(eid=line.get('empId'),
enm=line.get('empName'),
eag=line.get('empAge'),
esal=line.get('empSalary'),
erol=line.get('empRole')))
return emplist