public IHttpActionResult RegisterPatient(NormalUserPatient patient) { string first = patient.FName; string last = patient.LName; string uname = patient.UserName; string password = patient.Password; string address = patient.Address; string bloodgroup = patient.BloodGroup; string gender = patient.Gender; string age = patient.Age; string NewID; int temp; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = "Data Source=DESKTOP-3SOIUD0\\SQLEXPRESS;Initial Catalog=Eclinic;Integrated Security=True"; conn.Open(); string query1 = "EXEC Load_PatientID"; SqlCommand LastID = new SqlCommand(query1, conn); string LID = LastID.ExecuteScalar().ToString().Replace(" ", ""); conn.Close(); conn.Open(); string checkuname = "select count(*) from NormalUser where UserName = '******'"; SqlCommand com = new SqlCommand(checkuname, conn); temp = Convert.ToInt32(com.ExecuteScalar().ToString()); conn.Close(); int position = LID.IndexOf("t"); string Spart = "Pat"; string ID = LID.Substring(position + 1); int IDval = Int32.Parse(ID); int Nid = ++IDval; string Ipart = Nid.ToString(); NewID = string.Concat(Spart, Ipart); } if (temp == 0) { string query = "EXEC Add_PatientDetails'" + NewID + "','" + bloodgroup + "','" + gender + "','" + age + "'EXEC Add_UserDetailsOfPatient'" + NewID + "','" + first + "','" + last + "','" + address + "','" + uname + "','" + password + "'"; int result = connectionProvider.CreateSomething(query); return(Ok(result)); } else { testenigma mal = new testenigma(); mal.test1 = temp.ToString(); return(Ok(mal)); } }
public IHttpActionResult DoctorRegistration(DoctorAll doctor) { string first = doctor.FName; string last = doctor.LName; string uname = doctor.UserName; string password = doctor.Password; string address = doctor.Address; string speciality = doctor.Speciality; string gender = doctor.Gender; string PNO = doctor.TelNo1; string NewID; int temp; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = "Data Source=DESKTOP-3SOIUD0\\SQLEXPRESS;Initial Catalog=Eclinic;Integrated Security=True"; conn.Open(); string query1 = "EXEC Load_DoctorID"; SqlCommand LastID = new SqlCommand(query1, conn); string LID = LastID.ExecuteScalar().ToString().Replace(" ", ""); conn.Close(); conn.Open(); string checkuname = "select count(*) from NormalUser where UserName = '******'"; SqlCommand com = new SqlCommand(checkuname, conn); temp = Convert.ToInt32(com.ExecuteScalar().ToString()); conn.Close(); int position = LID.IndexOf("c"); string Spart = "Doc"; string ID = LID.Substring(position + 1); int IDval = Int32.Parse(ID); int Nid = ++IDval; string Ipart = Nid.ToString(); NewID = string.Concat(Spart, Ipart); } if (temp == 0) { string query = "EXEC Add_SpecialityDetails'" + NewID + "','" + speciality + "','" + gender + "'EXEC Add_TelNo'" + NewID + "','" + PNO + "'EXEC Add_DeatailsOfDoctor'" + NewID + "','" + first + "','" + last + "','" + address + "','" + uname + "','" + password + "'"; int result = connectionProvider.CreateSomething(query); return(Ok(result)); } else { testenigma mal = new testenigma(); mal.test1 = temp.ToString(); return(Ok(mal)); } }
public IHttpActionResult PharmacyRegistration(RegisterPharmacy pharmacy) { string Fname = pharmacy.FName; string Lname = pharmacy.LName; string Address = pharmacy.Address; string PName = pharmacy.PharmacyName; string Uname = pharmacy.UserName; string Lat = pharmacy.Lat; string Long = pharmacy.Long; string Password = pharmacy.Password; string NewID; int temp; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = "Data Source=DESKTOP-3SOIUD0\\SQLEXPRESS;Initial Catalog=Eclinic;Integrated Security=True;"; conn.Open(); string query1 = "EXEC Load_PharmacyID"; SqlCommand LastID = new SqlCommand(query1, conn); string LID = LastID.ExecuteScalar().ToString().Replace(" ", ""); conn.Close(); conn.Open(); string checkuname = "select count(*) from NormalUser where UserName = '******'"; SqlCommand com = new SqlCommand(checkuname, conn); temp = Convert.ToInt32(com.ExecuteScalar().ToString()); conn.Close(); int position = LID.IndexOf("a"); string Spart = "Pha"; string ID = LID.Substring(position + 1); int IDval = Int32.Parse(ID); int Nid = ++IDval; string Ipart = Nid.ToString(); NewID = string.Concat(Spart, Ipart); } if (temp == 0) { string query = "EXEC Add_Pharmacy'" + NewID + "','" + Uname + "','" + Lat + "','" + Long + "'EXEC Add_DetailsOfPharmacy'" + NewID + "','" + Fname + "','" + Lname + "','" + Address + "','" + Uname + "','" + Password + "'"; int result = connectionProvider.CreateSomething(query); return(Ok(result)); } else { testenigma mal = new testenigma(); mal.test1 = temp.ToString(); return(Ok(mal)); } }
public IHttpActionResult RegisterHospital(AdminUser hospital) { string Name = hospital.Username; string Password = hospital.Password; string NewID; int temp; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = "Data Source=DESKTOP-3SOIUD0\\SQLEXPRESS;Initial Catalog=Eclinic;Integrated Security=True;"; conn.Open(); string query1 = "EXEC Load_HospitalID"; SqlCommand LastID = new SqlCommand(query1, conn); string LID = LastID.ExecuteScalar().ToString().Replace(" ", ""); conn.Close(); conn.Open(); string checkuname = "select count(*) from AdminUser where Username = '******'"; SqlCommand com = new SqlCommand(checkuname, conn); temp = Convert.ToInt32(com.ExecuteScalar().ToString()); conn.Close(); int position = LID.IndexOf("s"); string Spart = "Hos"; string ID = LID.Substring(position + 1); int IDval = Int32.Parse(ID); int Nid = ++IDval; string Ipart = Nid.ToString(); NewID = string.Concat(Spart, Ipart); } if (temp == 0) { string query = "EXEC Add_Hospital'" + NewID + "','" + Name + "','" + Password + "'"; int result = connectionProvider.CreateSomething(query); return(Ok(result)); } else { testenigma mal = new testenigma(); mal.test1 = temp.ToString(); return(Ok(mal)); } }