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));
}
}
