public ActionResult GetCity(string prefix)
{
BL_OutSourceLab _OutSourceLab = new BL_OutSourceLab();
DataSet ds = _OutSourceLab.GetCity(prefix);
List <OutSourceLab> GetCityName = new List <OutSourceLab>();
int i = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
OutSourceLab obj = new OutSourceLab();
obj.CityID = Convert.ToInt32(dr["CityID"].ToString());
obj.City = dr["CityName"].ToString();
if (dr["StateID"] == "" && dr["StateID"] == "0")
{
obj.StateID = 0;
}
else
{
obj.StateID = Convert.ToInt32(dr["StateID"].ToString());
}
obj.State = dr["StateName"].ToString();
if (dr["CountryID"] == null || dr["CountryID"] == "")
{
obj.CountryID = 0;
}
else
{
obj.CountryID = Convert.ToInt32(dr["CountryID"].ToString());
}
obj.Country = dr["CountryName"].ToString();
GetCityName.Add(obj);
}
return(new JsonResult {
Data = GetCityName, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult Edit(int OutSourceLabID)
{
BL_OutSourceLab _OutSourceLab = new BL_OutSourceLab();
OutSourceLab obj = new OutSourceLab();
List <OutSourceLab> GetOutSourceLab = new List <OutSourceLab>();
DataSet ds = _OutSourceLab.GetOutSourceLab(OutSourceLabID);
foreach (DataRow dr in ds.Tables[0].Rows)
{
GetOutSourceLab.Add(new OutSourceLab
{
HospitalID = Convert.ToInt32(dr["HospitalID"]),
LocationID = Convert.ToInt32(dr["LocationID"]),
OutSourceLabID = (dr["OutSourceLabID"]).ToString(),
LabName = dr["LabName"].ToString(),
ReferenceCode = dr["ReferenceCode"].ToString(),
ManagingBody = dr["ManagingBody"].ToString(),
Adminstrator = dr["Adminstrator"].ToString(),
Address = dr["Address"].ToString(),
CityID = Convert.ToInt32(dr["CityID"].ToString()),
PinCode = dr["PinCode"].ToString(),
StateID = Convert.ToInt32(dr["StateID"].ToString()),
CountryID = Convert.ToInt32(dr["CountryID"].ToString()),
PhoneNo = dr["PhoneNo"].ToString(),
MobileNo = dr["MobileNo"].ToString(),
EmailID = dr["EmailID"].ToString(),
URL = dr["URL"].ToString(),
FaxNo = dr["FaxNo"].ToString(),
ContactPerson = dr["ContactPerson"].ToString(),
Mode = dr["Mode"].ToString(),
CreationID = Convert.ToInt32(dr["CreationID"]),
});
}
return(new JsonResult {
Data = GetOutSourceLab, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult OutSourceLab(OutSourceLab obj, FormCollection fc)
{
BL_OutSourceLab _OutSourceLab = new BL_OutSourceLab();
try
{
if (_OutSourceLab.CheckOutSourceLab(obj.OutSourceLabID, obj.LabName))
{
if (obj.OutSourceLabID == null || obj.OutSourceLabID == "0")
{
obj.OutSourceLabID = "0";
}
else
{
obj.OutSourceLabID = (fc["OutSourceLabID"].ToString());
}
if (fc["LabtestdetailsID"] == null)
{
obj.OutSourceLabtestdetailsID = "0";
}
else
{
obj.OutSourceLabtestdetailsID = fc["LabtestdetailsID"].ToString();
}
obj.LabName = fc["LabName"].ToString();
if (obj.ManagingBody == "" || obj.ManagingBody == null)
{
obj.ManagingBody = "";
}
else
{
obj.ManagingBody = fc["ManagingBody"].ToString();
}
//if (obj.Percentage == "" || obj.Percentage == null)
//{
// obj.Percentage = "";
//}
//else
//{
// obj.Percentage = fc["Percentage"].ToString();
//}
if (obj.Adminstrator == "")
{
obj.Adminstrator = "";
}
else
{
obj.Adminstrator = fc["Adminstrative"].ToString();
}
if (obj.ContactPerson == "" || obj.ContactPerson == null)
{
obj.ContactPerson = "";
}
else
{
obj.ContactPerson = fc["ContactPerson"].ToString();
}
// obj.OutSourceLabtestdetailsID = "";
obj.TestGroupName = fc["TestGroupName"].ToString();
obj.TestName = fc["TestName"].ToString();
obj.Rate = fc["Rate1"].ToString();
obj.Percentage = fc["Percent"].ToString();
obj.Test = fc["Test"].ToString();
obj.GroupID = fc["GroupID"].ToString();
if (obj.Address == "" || obj.Address == null)
{
obj.Address = "";
}
else
{
obj.Address = fc["Address"].ToString();
}
if (obj.CityID == 0 || obj.CityID == null)
{
obj.CityID = 0;
}
else
{
obj.CityID = Convert.ToInt32(fc["CityID"].ToString());
}
if (obj.CountryID == 0 || obj.CountryID == null)
{
obj.CountryID = 0;
}
else
{
obj.CountryID = Convert.ToInt32(fc["CountryID"].ToString());
}
if (obj.StateID == 0 || obj.StateID == null)
{
obj.StateID = 0;
}
else
{
obj.StateID = Convert.ToInt32(fc["StateID"].ToString());
}
if (obj.PinCode == "" || obj.PinCode == null)
{
obj.PinCode = "";
}
else
{
obj.PinCode = fc["PinCode"].ToString();
}
if (obj.PhoneNo == "" || obj.PhoneNo == null)
{
obj.PhoneNo = "";
}
else
{
obj.PhoneNo = fc["PhoneNo"].ToString();
}
if (obj.MobileNo == "" || obj.MobileNo == null)
{
obj.MobileNo = "";
}
else
{
obj.MobileNo = fc["MobileNo"].ToString();
}
if (obj.EmailID == "" || obj.EmailID == null)
{
obj.EmailID = "";
}
else
{
obj.EmailID = fc["EmailID"].ToString();
}
if (obj.FaxNo == "" || obj.FaxNo == null)
{
obj.FaxNo = "";
}
else
{
obj.FaxNo = fc["FaxNo"].ToString();
}
if (obj.URL == "" || obj.URL == null)
{
obj.URL = "";
}
else
{
obj.URL = fc["URL"].ToString();
}
if (_OutSourceLab.Save(obj))
{
ModelState.Clear();
ViewData["flag"] = "Done";
TempData["Msg"] = "OutSourceLab Saved Succussfully ";
}
}
else
{
ViewData["flag"] = "Error";
TempData["Msg"] = "OutSourceLab Already Exist's ";
}
return(RedirectToAction("OutSourceLab", "OutSourceLab"));
}
catch (Exception ex)
{
//ExceptionManager.Publish(ex);
//ShowMessage(ex.Message, MessageTypes.ErrorMessage);
}
return(View(obj));
}
public bool Save(OutSourceLab obj)
{
Connect();
con.Open();
if (obj.OutSourceLabID == "0")
{
SqlCommand cmd = new SqlCommand("IUOutSourceLabRegistration", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
if (obj.OutSourceLabID == "0")
{
cmd.Parameters.AddWithValue("@OutSourceLabID", 0);
cmd.Parameters["@OutSourceLabID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@Mode", "Add");
}
else
{
cmd.Parameters.AddWithValue("@OutSourceLabID", obj.OutSourceLabID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
}
cmd.Parameters.AddWithValue("@labName", obj.LabName.ToUpper());
cmd.Parameters.AddWithValue("@ManagingBody", obj.ManagingBody);
cmd.Parameters.AddWithValue("@ReferenceCode", 1);
cmd.Parameters.AddWithValue("@Adminstrator", obj.Adminstrator);
cmd.Parameters.AddWithValue("@Address", obj.Address);
cmd.Parameters.AddWithValue("@CityID", obj.CityID);
cmd.Parameters.AddWithValue("@PinCode", obj.PinCode);
cmd.Parameters.AddWithValue("@StateID", obj.StateID);
cmd.Parameters.AddWithValue("@CountryID", obj.CountryID);
cmd.Parameters.AddWithValue("@PhoneNo", obj.PhoneNo);
cmd.Parameters.AddWithValue("@MobileNo", obj.MobileNo);
cmd.Parameters.AddWithValue("@EmailID", obj.EmailID);
cmd.Parameters.AddWithValue("@URL", obj.URL);
cmd.Parameters.AddWithValue("@FaxNo", obj.FaxNo);
cmd.Parameters.AddWithValue("@ContactPerson", obj.ContactPerson);
cmd.Parameters.AddWithValue("@CreationID", UserID);
// cmd.Parameters.AddWithValue("@Mode", "Add");
int row = cmd.ExecuteNonQuery();
obj.OutSourceLabID = Convert.ToString(cmd.Parameters["@OutSourceLabID"].Value);
// obj.LabName = cmd.Parameters["@labName"].ToString();
con.Close();
if (row > 0)
{
//String[] LabtestdetailsID = obj.OutSourceLabtestdetailsID.ToString().Split(',');
String[] GroupID = obj.GroupID.ToString().Split(',');
String[] GroupName = obj.TestGroupName.Split(',');
String[] TestID = obj.Test.ToString().Split(',');
String[] TestName = obj.TestName.Split(',');
String[] Rate = obj.Rate.Split(',');
String[] Percent = obj.Percentage.Split(',');
for (int count = 0; count < TestName.Length; count++)
{
SqlCommand cmd1 = new SqlCommand("IUOutSourceLabtestdetails", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd1.Parameters.AddWithValue("@LocationID", LocationID);
if (obj.OutSourceLabtestdetailsID == "0")
{
cmd1.Parameters.AddWithValue("@OutSourceLabtestdetailsID", 0);
cmd1.Parameters.AddWithValue("@Mode", "Add");
}
else
{
//int LabtestdetailsID1 = Convert.ToInt32(LabtestdetailsID[count]);
cmd1.Parameters.AddWithValue("@OutSourceLabtestdetailsID", obj.OutSourceLabtestdetailsID);
cmd1.Parameters.AddWithValue("@Mode", "Edit");
}
cmd1.Parameters.AddWithValue("@OutSourceLabID", obj.OutSourceLabID);
cmd1.Parameters.AddWithValue("@labName", obj.LabName);
if (GroupName[count] == "")
{
cmd1.Parameters.AddWithValue("@TestGroupName", "");
}
else
{
cmd1.Parameters.AddWithValue("@TestGroupName", GroupName[count]);
}
int TestID1 = Convert.ToInt32(TestID[count]);
cmd1.Parameters.AddWithValue("@TestID", TestID1);
cmd1.Parameters.AddWithValue("@TestName", TestName[count]);
if (Percent[count] == "")
{
cmd1.Parameters.AddWithValue("@Percentage", 0);
}
else
{
int Percent1 = Convert.ToInt32(Percent[count]);
cmd1.Parameters.AddWithValue("@Percentage", Percent1);
}
if (Rate[count] == "")
{
cmd1.Parameters.AddWithValue("@Rate", 0.00);
}
else
{
decimal Rate1 = Convert.ToDecimal(Rate[count]);
cmd1.Parameters.AddWithValue("@Rate", Rate1);
}
int GroupID1 = Convert.ToInt32(GroupID[count]);
cmd1.Parameters.AddWithValue("@TestGroupID", Convert.ToInt32(GroupID1));
cmd1.Parameters.AddWithValue("@CreationID", UserID);
con.Open();
int i = cmd1.ExecuteNonQuery();
con.Close();
}
}
}
else
{
SqlCommand cmd = new SqlCommand("IUOutSourceLabRegistration", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@OutSourceLabID", obj.OutSourceLabID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
cmd.Parameters.AddWithValue("@labName", obj.LabName.ToUpper());
cmd.Parameters.AddWithValue("@ManagingBody", obj.ManagingBody);
cmd.Parameters.AddWithValue("@ReferenceCode", 1);
cmd.Parameters.AddWithValue("@Adminstrator", obj.Adminstrator);
cmd.Parameters.AddWithValue("@Address", obj.Address);
cmd.Parameters.AddWithValue("@CityID", obj.CityID);
cmd.Parameters.AddWithValue("@PinCode", obj.PinCode);
cmd.Parameters.AddWithValue("@StateID", obj.StateID);
cmd.Parameters.AddWithValue("@CountryID", obj.CountryID);
cmd.Parameters.AddWithValue("@PhoneNo", obj.PhoneNo);
cmd.Parameters.AddWithValue("@MobileNo", obj.MobileNo);
cmd.Parameters.AddWithValue("@EmailID", obj.EmailID);
cmd.Parameters.AddWithValue("@URL", obj.URL);
cmd.Parameters.AddWithValue("@FaxNo", obj.FaxNo);
cmd.Parameters.AddWithValue("@ContactPerson", obj.ContactPerson);
cmd.Parameters.AddWithValue("@CreationID", UserID);
int row = cmd.ExecuteNonQuery();
obj.OutSourceLabID = Convert.ToString(cmd.Parameters["@OutSourceLabID"].Value);
con.Close();
if (row > 0)
{
String[] LabtestdetailsID = obj.OutSourceLabtestdetailsID.ToString().Split(',');
String[] GroupID = obj.GroupID.ToString().Split(',');
String[] GroupName = obj.TestGroupName.Split(',');
String[] TestID = obj.Test.ToString().Split(',');
String[] TestName = obj.TestName.Split(',');
String[] Rate = obj.Rate.Split(',');
String[] Percent = obj.Percentage.Split(',');
for (int count = 0; count < TestName.Length; count++)
{
SqlCommand cmd1 = new SqlCommand("IUOutSourceLabtestdetails", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd1.Parameters.AddWithValue("@LocationID", LocationID);
cmd1.Parameters.AddWithValue("@OutSourceLabID", obj.OutSourceLabID);
int LabtestdetailsID1 = Convert.ToInt32(LabtestdetailsID[count]);
cmd1.Parameters.AddWithValue("@OutSourceLabtestdetailsID", LabtestdetailsID1);
cmd1.Parameters.AddWithValue("@Mode", "Edit");
cmd1.Parameters.AddWithValue("@labName", obj.LabName);
if (GroupName[count] == "")
{
cmd1.Parameters.AddWithValue("@TestGroupName", "");
}
else
{
cmd1.Parameters.AddWithValue("@TestGroupName", GroupName[count]);
}
int TestID1 = Convert.ToInt32(TestID[count]);
cmd1.Parameters.AddWithValue("@TestID", TestID1);
cmd1.Parameters.AddWithValue("@TestName", TestName[count]);
if (Percent[count] == "")
{
cmd1.Parameters.AddWithValue("@Percentage", 0);
}
else
{
int Percent1 = Convert.ToInt32(Percent[count]);
cmd1.Parameters.AddWithValue("@Percentage", Percent1);
}
if (Rate[count] == "")
{
cmd1.Parameters.AddWithValue("@Rate", 0.00);
}
else
{
decimal Rate1 = Convert.ToDecimal(Rate[count]);
cmd1.Parameters.AddWithValue("@Rate", Rate1);
}
int GroupID1 = Convert.ToInt32(GroupID[count]);
cmd1.Parameters.AddWithValue("@TestGroupID", Convert.ToInt32(GroupID1));
cmd1.Parameters.AddWithValue("@CreationID", UserID);
con.Open();
int i = cmd1.ExecuteNonQuery();
con.Close();
}
}
}
return(true);
}
