public static string newUnit(Endorsement_UnitsDashboard data)
{
string config = Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <Endorsement_UnitsDashboard> Endorsement_UnitsDashboard = new List <Endorsement_UnitsDashboard>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (SqlCommand cmd1 = new SqlCommand("insert into Endorsement_UnitsDashboard (Unit_id,Branch_id, Unit_name, Shift,Shift_date,Total_Census,Received,Admission,Transfer_In,Transfer_Out,Endorsing_ChargeNurse,Endorsing_ChargeNurse_id,Receive_ChargeNurse,Receive_ChargeNurse_id, Confirm) values (@Unit_id,@Branch_id, @Unit_name, @Shift,@Shift_date,@Received,@Received,@Admission,@Transfer_In,@Transfer_Out,@Endorsing_ChargeNurse,@Endorsing_ChargeNurse_id,@Receive_ChargeNurse,@Receive_ChargeNurse_id, @Confirm)", con))
{
cmd1.Parameters.Add("@Unit_id", SqlDbType.Int).Value = data.Unit_id;
cmd1.Parameters.Add("@Branch_id", SqlDbType.Int).Value = data.Branch_id;
cmd1.Parameters.Add("@Unit_name", SqlDbType.VarChar).Value = data.Unit_name;
cmd1.Parameters.Add("@Shift", SqlDbType.VarChar).Value = data.Shift;
cmd1.Parameters.Add("@Shift_date", SqlDbType.DateTime).Value = data.Shift_date;
cmd1.Parameters.Add("@Total_Census", SqlDbType.Int).Value = data.Total_Census;
cmd1.Parameters.Add("@Received", SqlDbType.Int).Value = data.Received;
cmd1.Parameters.Add("@Admission", SqlDbType.Int).Value = data.Admission;
cmd1.Parameters.Add("@Transfer_In", SqlDbType.Int).Value = data.Transfer_In;
cmd1.Parameters.Add("@Transfer_Out", SqlDbType.Int).Value = data.Transfer_Out;
cmd1.Parameters.Add("@Endorsing_ChargeNurse", SqlDbType.VarChar).Value = data.Endorsing_ChargeNurse;
cmd1.Parameters.Add("@Endorsing_ChargeNurse_id", SqlDbType.Int).Value = data.Endorsing_ChargeNurse_id;
cmd1.Parameters.Add("@Receive_ChargeNurse", SqlDbType.VarChar).Value = data.Receive_ChargeNurse;
cmd1.Parameters.Add("@Receive_ChargeNurse_id", SqlDbType.Int).Value = data.Receive_ChargeNurse_id;
cmd1.Parameters.Add("@Confirm", SqlDbType.Bit).Value = data.Confirm;
cmd1.ExecuteNonQuery();
}
con.Close();
return(JsonConvert.SerializeObject(Endorsement_UnitsDashboard));
}
public static string completeNurseShift(Endorsement_UnitsDashboard shift)
{
string config = Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <Endorsement_UnitsDashboard> Endorsement_UnitsDashboard = new List <Endorsement_UnitsDashboard>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (SqlCommand cmd = new SqlCommand("update Endorsement_UnitsDashboard set Completed = 1 where Id = @Id", con))
{
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = shift.Id;
SqlDataReader idr = cmd.ExecuteReader();
}
con.Close();
return(JsonConvert.SerializeObject(Endorsement_UnitsDashboard));
}
