public ActionResult MISConsultantDrService(MISConsultantDrService objCon, FormCollection fc)
{
try
{
BL_MISConsultantDrService obj = new BL_MISConsultantDrService();
MISConsultantDrService objModel = new MISConsultantDrService();
objCon.PaidAmtID = fc["PaidID"];
objCon.PaidDate = fc["PaidDate"];
objCon.PaidAmount = fc["ConAmt"];
objCon.ServiceID = fc["SerID"];
objCon.ServiceName = fc["SerName"];
objCon.ServiceAmount = fc["SerAmt"];
objCon.PatientID = fc["Regno"];
objCon.PatientName = fc["PatName"];
objCon.DrID = fc["DocrID"];
objCon.DrName = fc["DocName"];
objCon.BillAmt = fc["BillAmt"];
objCon.BillDt = fc["BillDt"];
objCon.BillNo = fc["Billno"];
if (objCon.PaidAmount != "")
{
// objCon.PaidDate=fc[""];
//objCon.PaidAmount = fc["PaidAmt"];
if (obj.Save(objCon))
{
ModelState.Clear();
ViewData["flag"] = "Done";
TempData["msg"] = "Save Changes";
}
}
return(RedirectToAction("MISConsultantDrService", "MISConsultantDrService"));
}
catch (Exception Ex)
{
return(RedirectToAction("MISConsultantDrService", "MISConsultantDrService"));
}
return(View());
}
public ActionResult Save(string servicename, string id, string type)
{
string message = "";
try
{
BL_MISConsultantDrService obj = new BL_MISConsultantDrService();
MISConsultantDrService ConSer = new MISConsultantDrService();
//objReschedule.HospitalID = HospitalID;
//objReschedule.LocationID = LocationID;
ConSer.HospitalID = Convert.ToInt32(Session["HospitalID"]);
ConSer.LocationID = Convert.ToInt32(Session["LocationID"]);
int UserID = Convert.ToInt32(Session["UserID"]);
ConSer.ServiceID = id;
ConSer.ServiceName = servicename;
ConSer.ServiceType = type;
ConSer.Mode = "Add";
DataSet ds = obj.Getservicename(type);
if (ds.Tables[0].Rows.Count > 0)
{
if (ConSer.Mode == "Add")
{
string ServiceType = ds.Tables[0].Rows[0]["ServiceType"].ToString();
Connect();
SqlCommand cmd = new SqlCommand("Delete from Getservicename where ServiceType like '" + ServiceType + '%' + "'", con);
con.Open();
int a = cmd.ExecuteNonQuery();
con.Close();
}
}
if (obj.IUGetServices(ConSer))
{
TempData["msg"] = "Successfully";
}
//return RedirectToAction("MISConsultantDrService", "MISConsultantDrService");
return(new JsonResult {
Data = "Successfully", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
catch (Exception ex)
{
message = ex.Message;
}
//return RedirectToAction("MISConsultantDrService", "MISConsultantDrService");
return(new JsonResult {
Data = "Successfully", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public bool IUGetServices(MISConsultantDrService obj)
{
Connect();
SqlCommand cmd = new SqlCommand("IUGetServices", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
if (obj.ServiceID == "")
{
cmd.Parameters.AddWithValue("@ServiceID", 0);
cmd.Parameters.AddWithValue("@Mode", "Add");
}
else
{
cmd.Parameters.AddWithValue("@ServiceID", obj.ServiceID);
}
cmd.Parameters.AddWithValue("@ServiceType", obj.ServiceType);
cmd.Parameters.AddWithValue("@ServiceName", obj.ServiceName);
cmd.Parameters.AddWithValue("@Mode", "Add");
cmd.Parameters.AddWithValue("@CreationID", UserID);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Save(MISConsultantDrService obj)
{
try
{
Connect();
if (obj.PaidAmtID == "")
{
string[] ConAmt = obj.PaidAmount.Split(',');
string[] SerID = obj.ServiceID.Split(',');
string[] SerName = obj.ServiceName.Split(',');
string[] SerAmt = obj.ServiceAmount.Split(',');
string[] Regno = obj.PatientID.Split(',');
string[] PatName = obj.PatientName.Split(',');
string[] DocrID = obj.DrID.Split(',');
string[] DocName = obj.DrName.Split(',');
string[] BillAmt = obj.BillAmt.Split(',');
string[] BillDt = obj.BillDt.Split(',');
string[] Billno = obj.BillNo.Split(',');
for (int row = 0; row < ConAmt.Length; row++)
{
if (ConAmt[row].ToString() != "")
{
SqlCommand cmd = new SqlCommand("IUConsultantPaidAmount", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
if (obj.PaidAmtID == "" || obj.PaidAmtID == null)
{
cmd.Parameters.AddWithValue("@PaidAmtID", 0);
cmd.Parameters.AddWithValue("@Mode", "Add");
}
else
{
cmd.Parameters.AddWithValue("@PaidAmtID", obj.PaidAmtID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
}
cmd.Parameters.AddWithValue("@BillDate", BillDt[row]);
cmd.Parameters.AddWithValue("@ConsultantName", DocName[row]);
cmd.Parameters.AddWithValue("@DoctorID", DocrID[row]);
cmd.Parameters.AddWithValue("@patientname", PatName[row]);
cmd.Parameters.AddWithValue("@PatientRegNo", Regno[row]);
cmd.Parameters.AddWithValue("@ServiceName", SerName[row]);
cmd.Parameters.AddWithValue("@serviceamount", SerAmt[row]);
cmd.Parameters.AddWithValue("@ConsultantAmount", ConAmt[row]);
cmd.Parameters.AddWithValue("@PaidDate", obj.PaidDate);
cmd.Parameters.AddWithValue("@ServiceID", SerID[row]);
cmd.Parameters.AddWithValue("@BillNo", Billno[row]);
cmd.Parameters.AddWithValue("@CreationID", UserID);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
}
}
}
else
{
string[] PaidID = obj.PaidAmtID.Split(',');
for (int i = 0; i < PaidID.Length; i++)
{
if (PaidID[i] != "")
{
SqlCommand cmd = new SqlCommand("update ConsultantPaidAmount set RowStatus = 1 where HospitalID = '" + HospitalID + "' and LocationID = '" + LocationID + "' and PaidAmtID =" + PaidID[i], con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
