def Device_master():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
query1 = "select * from Device_master where DeviceMac = "+'"'+str(data["DeviceMac"])+'"'+" ;"
print(query1)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query1)
data= cursor.fetchone()
conn.commit()
cursor.close()
if data != None:
output={"output": " DeviceMac name already registered ,Please enter the other DeviceMac ","status":"false"}
else:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
print("77787878")
query2 = " insert into Device_master (DeviceMac,Bed_Number,Vard_Name,Hospital_Id,usercreate)"
query2 = query2 +" values("+'"'+str(data["DeviceMac"])+'"'+','+'"'+str(data["Bed_Number"])+'"'+','+'"'+str(data["Vard_Name"])+'"'+','+'"'+str(data["Hospital_Id"])+'"'+','+'"'+str(data["usercreate"])+'"'+' '+");"
print(query2)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query2)
conn.commit()
output={"output": "DeviceMac Added succesfully","status":"true"}
except Exception as e :
print("Exception---->" + str(e))
output = {"result":"something went wrong","status":"false"}
return output
def Hospital_master():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
query1 = "select ID,hospital_name,City,State from Hospital_master where hospital_name = "+'"'+str(data["hospital_name"])+'"'+" ;"
print(query1)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query1)
data= cursor.fetchone()
conn.commit()
cursor.close()
if data != None:
output={"output": "Hospital name already registered ,Please enter the other Hospital name ","status":"false"}
else:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
print("77787878")
query2 = " insert into Hospital_master (hospital_name,City,State,usercreate)"
query2 = query2 +" values("+'"'+str(data["hospital_name"])+'"'+','+'"'+str(data["City"])+'"'+','+'"'+str(data["State"])+'"'+','+'"'+str(data["usercreate"])+'"'+' '+");"
print(query2)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query2)
conn.commit()
output={"output": "Hospital Name Added succesfully","status":"true"}
except Exception as e :
print("Exception---->" + str(e))
output = {"result":"something went wrong","status":"false"}
return output
def SelectQuery1(table,columns,whereCondition):
try:
if whereCondition != "":
whereCondition = " where 1=1 " + whereCondition
query = " select " + columns + " from " + table + " " + whereCondition + " ;"
print(query)
conn = Connection()
cursor = conn.cursor()
cursor.execute(query)
data = cursor.fetchall()
cursor.close()
if data:
data = {"status":"true","message":"","result":data}
else:
data = {"status":"true","message":"No Data Found","result":""}
return data
except Exception as e:
print("Error--->" + str(e))
return "0"
def login():
try:
# userid = request.args['userid']
password = request.args['password']
name = request.args['name']
#query="select userid,usertype from usermaster where userid = '" + userid + "' and password='******';"
query ="select mobile,Usertype_Id,Hospital_Id from Signup where name = '" + name + "' and password='******';"
conn=Connection()
cursor = conn.cursor()
cursor.execute(query)
loginuser = cursor.fetchone()
cursor.close()
if loginuser:
Data = json.dumps(loginuser, default=str)
return Data
else:
data={"status":"Failed","result":"Login Failed"}
return data
except KeyError as e:
print("Exception---->" +str(e))
output = {"result":"Input Keys are not Found","status":"false"}
return output
except Exception as e :
print("Exception---->" +str(e))
output = {"result":"something went wrong","status":"false"}
return output
def updateSignup():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
print("yy")
query1 = " update Signup set name= '" + str(data["name"]) + "', password ='******' , mobile ='" + str(data["mobile"]) + "' , Usertype_Id ='" + str(data["Usertype_Id"]) + "' , Hospital_Id ='" + str(data["Hospital_Id"]) + "' , UserUpdate ='" + str(data["UserUpdate"]) + "' , Status ='1' where ID = '" + str(data["ID"])+ "';"
print(query1)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query1)
conn.commit()
cursor.close()
output = {"result":"Updated Successfully","status":"true"}
return output
except KeyError :
print("Key Exception---->")
output = {"result":"key error","status":"false"}
return output
except Exception as e :
print("Exception---->" +str(e))
output = {"result":"somthing went wrong","status":"false"}
return output
def signup():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
query1 = "select Usertype_Id,Hospital_Id,mobile from signup where name = "+'"'+str(data["name"])+'"'+" ;"
print(query1)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query1)
data= cursor.fetchone()
conn.commit()
cursor.close()
if data != None:
output={"output": "Name already registered ,Please enter the other Name","status":"false"}
else:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
print("77787878")
query2 = " insert into signup (name,mobile,password,Usertype_Id,Hospital_Id,usercreate)"
query2 = query2 +" values("+'"'+str(data["name"])+'"'+','+'"'+str(data["mobile"])+'"'+','+'"'+str(data["password"])+'"'+','+'"'+str(data["Usertype_Id"])+'"'+','+'"'+str(data["Hospital_Id"])+'"'+','+'"'+str(data["usercreate"])+'"'+' '+");"
print(query2)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query2)
conn.commit()
cursor.close()
output={"output": "User Signup succesfully","status":"true"}
except Exception as e :
print("Exception---->" + str(e))
output = {"result":"something went wrong","status":"false"}
return output
def Patient_Vital_master():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
query = "select * from Patient_Vital_master where PatientId = "+'"'+str(data["PatientId"])+'"'+" ;"
conn=Connection()
cursor = conn.cursor()
cursor.execute(query)
data= cursor.fetchone()
conn.commit()
cursor.close()
if data != None:
output={"output": "PatientId already registered ,Please enter other PatientId ","status":"false"}
else:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
query2 = " insert into Patient_Vital_master(PatientId,Bp,SPO2,TEMP,usercreate)"
query2 =query2 +" values("+'"'+str(data["PatientId"])+'"'+','+'"'+str(data["Bp"])+'"'+','+'"'+str(data["SPO2"])+'"'+','+'"'+str(data["TEMP"])+'"'+','+'"'+str(data["usercreate"])+'"'+' '+");"
print(query2)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query2)
conn.commit()
cursor.close()
output={"output": "Patient Vital Details Added succesfully","status":"true"}
except Exception as e :
print("Exception---->" + str(e))
output = {"result":"something went wrong","status":"false"}
return output
def Patient_master():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
query = "select * from Patient_master where PatientName = "+'"'+str(data["PatientName"])+'"'+" ;"
conn=Connection()
cursor = conn.cursor()
cursor.execute(query)
data= cursor.fetchone()
conn.commit()
cursor.close()
if data != None:
output={"output": "PatientName already registered ,Please enter other PatientName "}
else:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
query2 = " insert into Patient_master(PatientName,DeviceMac,Bed_Number,hospital_Name,startdate,enddate,usercreate)"
query2 =query2 +" values("+'"'+str(data["PatientName"])+'"'+','+'"'+str(data["DeviceMac"])+'"'+','+'"'+str(data["Bed_Number"])+'"'+','+'"'+str(data["hospital_name"])+'"'+','+'"'+str(data["startdate"])+'"'+','+'"'+str(data["enddate"])+'"'+','+'"'+str(data["usercreate"])+'"'+''+");"
print(query2)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query2)
conn.commit()
cursor.close()
output={"output": "Patient Added succesfully","status":"true"}
except Exception as e :
print("Exception---->" + str(e))
output = {"result":"something went wrong","status":"false"}
return output
def InsertQuery(table,columns,values):
try:
query = " insert into " + table + " (" + columns + ") values(" + values + ");"
print(query)
conn = Connection()
cursor = conn.cursor()
cursor.execute(query)
conn.commit()
cursor.close()
message = commonfile.Successmessage('insert')
data = {"status":"true","message":message,"result":""}
return data
except Exception as e:
print("Error--->" + str(e))
return "0"
def Usertypelist():
try:
query = "select * from Usertype_master "
conn=Connection()
cursor = conn.cursor()
cursor.execute(query)
data = cursor.fetchall()
cursor.close()
if data:
Data = json.dumps(data, default=str)
return str(Data)
else:
output = {"result":"No Data Found","status":"false"}
return output
except Exception as e :
print("Exception---->" + str(e))
output = {"result":"something went wrong","status":"false"}
return output
def Patient_Vital_master_select():
try:
# query = " select distinct userid,username,usertype from usermaster where usertype <> 'Admin';"
query = "select * from Patient_Vital_master "
conn=Connection()
cursor = conn.cursor()
cursor.execute(query)
data = cursor.fetchall()
cursor.close()
if data:
Data = json.dumps(data, default=str)
return str(Data)
else:
output = {"result":"No Data Found","status":"false"}
return output
except Exception as e :
print("Exception---->" + str(e))
output = {"result":"something went wrong","status":"false"}
return output
def UpdateQuery(table,columns,whereCondition):
try:
if whereCondition != "":
whereCondition = " where 1=1 " + whereCondition
if columns != "":
query = " update " + table + " set " + columns + " " + whereCondition + ";"
print(query)
conn = Connection()
cursor = conn.cursor()
cursor.execute(query)
conn.commit()
cursor.close()
message = commonfile.Successmessage('update')
data = {"status":"true","message":message,"result":""}
return data
else:
return "0"
except Exception as e:
print("Error--->" + str(e))
return "0"
def update_Patient_Vital_master():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
print("yy")
query1 = " update Patient_Vital_master set PatientId ='" + str(data["PatientId"]) + "' , Bp ='" + str(data["Bp"]) + "' , SPO2 = '" + str(data["SPO2"]) + "' , TEMP ='" + str(data["TEMP"]) + "' , UserUpdate ='" + str(data["UserUpdate"]) + "' , Status ='1' where Id = '" + str(data["Id"])+ "';"
print(query1)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query1)
conn.commit()
cursor.close()
output = {"result":"Updated Successfully","status":"true"}
return output
except KeyError :
print("Key Exception---->")
output = {"result":"key error","status":"false"}
return output
except Exception as e :
print("Exception---->" +str(e))
output = {"result":"somthing went wrong","status":"false"}
return output
def update_Patient_type():
try:
json1=request.get_data()
data=json.loads(json1.decode("utf-8"))
print("yy")
query1 = " update Patient_master set PatientName ='" + str(data["PatientName"]) + "' , DeviceMac ='" + str(data["DeviceMac"]) + "' , Bed_Number = '" + str(data["Bed_Number"]) + "' , hospital_Name ='" + str(data["hospital_Name"]) + "' , startdate='" + str(data["startdate"]) + "', enddate = '" + str(data["enddate"]) + "' , UserUpdate ='" + str(data["UserUpdate"]) + "' , Status ='1' where PatientId = '" + str(data["PatientId"])+ "';"
print(query1)
conn=Connection()
cursor = conn.cursor()
cursor.execute(query1)
conn.commit()
cursor.close()
output = {"result":"Updated Successfully","status":"true"}
return output
except KeyError :
print("Key Exception---->")
output = {"result":"key error","status":"false"}
return output
except Exception as e :
print("Exception---->" +str(e))
output = {"result":"somthing went wrong","status":"false"}
return output