public ActionResult WardRoomsDetails(WardRoomsDetails objWardRoom, FormCollection fc)
{
try
{
if (objWardRoom.BedNo != null)
{
if (dbWard.CheckWard(objWardRoom.WardName, objWardRoom.WardID))
{
if (dbWard.CheckWardRooms(objWardRoom.WardID, Convert.ToInt32(objWardRoom.RoomID), objWardRoom.RoomName))
{
objWardRoom.BedNo = Request.Form["BedNo"].ToString();
objWardRoom.BedStatus1 = fc["Bedcount"].ToString();
int wardid = Convert.ToInt32(objWardRoom.WardID);
if (dbWard.save(objWardRoom))
{
if (wardid > 0)
{
ModelState.Clear();
TempData["Msg"] = " Ward Updated Successfully";
return(RedirectToAction("WardRoomsDetails", "WardRoomsDetails"));
}
else
{
ModelState.Clear();
TempData["Msg"] = " Ward Saved Successfully";
return(RedirectToAction("WardRoomsDetails", "WardRoomsDetails"));
}
}
}
else
{
TempData["msg"] = "Room Already Exist's";
}
}
else
{
TempData["msg"] = "Ward Already Exist's";
}
}
else
{
TempData["msg"] = "Please Add BED No ";
RedirectToAction("WardRoomsDetails", "WardRoomsDetails");
}
return(RedirectToAction("WardRoomsDetails", "WardRoomsDetails"));
}
catch (Exception ex)
{
TempData["msg"] = "Please Add BED No ";
return(RedirectToAction("WardRoomsDetails", "WardRoomsDetails"));
}
}
public bool save(WardRoomsDetails Objward)
{
bool flag = true;
Connect();
con.Open();
int ServiceChargesID = 0;
string Mode = "";
SqlCommand cmd = new SqlCommand("IUWard", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
if (Objward.WardID == 0)
{
cmd.Parameters.AddWithValue("@WardID", 0);
cmd.Parameters["@WardID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@Mode", "Add");
Mode = "Add";
}
else
{
cmd.Parameters.AddWithValue("@WardID", Objward.WardID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
Mode = "Edit";
}
cmd.Parameters.AddWithValue("@WardName", Objward.WardName);
cmd.Parameters.AddWithValue("@ReferenceCode", 1);
cmd.Parameters.AddWithValue("@GeneralCharges", Objward.GeneralCharges);
cmd.Parameters.AddWithValue("@EmergencyCharges", Objward.EmergencyCharges);
cmd.Parameters.AddWithValue("@CreationID", UserID);
int WardID = cmd.ExecuteNonQuery();
Objward.WardID = Convert.ToInt32(cmd.Parameters["@WardID"].Value.ToString());
if (Mode == "Add")
{
#region Add All Services TPA Wise Ward
if (WardID > 0)
{
cmd = new SqlCommand("IUGetServicesForAllTpaandTest", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@WardID", Objward.WardID);
cmd.Parameters.AddWithValue("@CreationID", UserID);
ServiceChargesID = cmd.ExecuteNonQuery();
}
}
#endregion
if (WardID > 0)
{
Objward.WardID = Convert.ToInt32(cmd.Parameters["@WardID"].Value.ToString());
cmd = new SqlCommand("IUWardRooms", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@WardID", Objward.WardID);
if (Objward.RoomID == null)
{
cmd.Parameters.AddWithValue("@RoomID", 0);
cmd.Parameters["@RoomID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@Mode", "Add");
}
else
{
cmd.Parameters.AddWithValue("@RoomID", Objward.RoomID);
cmd.Parameters.AddWithValue("@Mode", "Edit");
}
cmd.Parameters.AddWithValue("@RoomName", Objward.RoomName);
cmd.Parameters.AddWithValue("@ReferenceCode", Objward.ReferenceCode);
cmd.Parameters.AddWithValue("@CreationID", UserID);
int roomID = cmd.ExecuteNonQuery();
if (roomID > 0)
{
int bedID = 0;
// string Mode = string.Empty;
#region -------------------Add Ward Room Details-------------------
Objward.RoomID = cmd.Parameters["@RoomID"].Value.ToString();
int length = 0;
string[] bedNo = Objward.BedNo.Split(',');
string[] bedstatus = Objward.BedStatus1.Split(',');
for (int i = 0; i < bedNo.Length; i++)
{
cmd = new SqlCommand("IUWardRoomsDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@RoomID", Objward.RoomID);
cmd.Parameters.AddWithValue("@WardID", Objward.WardID);
//if (length > i)
//{
// cmd.Parameters.AddWithValue("@BedID",Objward.BedID);
// Objward.Mode = "Edit";
// cmd.Parameters.AddWithValue("@Mode", Objward.Mode);
//}
//else
//{
cmd.Parameters.AddWithValue("@BedID", 0);
Objward.Mode = "Add";
cmd.Parameters.AddWithValue("@Mode", Objward.Mode);
// }
cmd.Parameters.AddWithValue("@BedNO", bedNo[i]);
cmd.Parameters.AddWithValue("@GeneralCharges", Objward.GeneralCharges);
cmd.Parameters.AddWithValue("@EmergencyCharges", Objward.EmergencyCharges);
cmd.Parameters.AddWithValue("@BedStatus", Convert.ToBoolean(bedstatus[i]));
cmd.Parameters.AddWithValue("@CreationID", UserID);
bedID = cmd.ExecuteNonQuery();
}
con.Close();
#endregion -------------------------------
if (bedID > 0)
{
return(true);
}
else
{
return(false);
}
}
}
return(true);
}
