public static string updateUnitsTransferOut(UnitsDash unit)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <UnitsDash> UnitsDash = new List <UnitsDash>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (
SqlCommand cmd =
new SqlCommand("update Endorsement_UnitsDashboard set Total_Census = Total_Census - 1, Transfer_Out = Transfer_Out + 1 where Unit_name = @Unit_name and Shift = @Shift and Shift_date >= DATEADD(day,-2, GETDATE()) ",
con)
)
{
cmd.Parameters.Add("@Unit_name", SqlDbType.VarChar).Value =
unit.Unit_name;
cmd.Parameters.Add("@Shift", SqlDbType.VarChar).Value = unit.Shift;
cmd.Parameters.Add("@Shift_date", SqlDbType.VarChar).Value =
unit.Shift_date;
SqlDataReader idr = cmd.ExecuteReader();
}
con.Close();
return(JsonConvert.SerializeObject(UnitsDash));
}
public static string getUnitsDashData(UnitsDash id)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <UnitsDash> UnitsDash = new List <UnitsDash>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (
SqlCommand cmd =
new SqlCommand("SELECT * from Endorsement_UnitsDashboard where id = @id",
con)
)
{
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id.id;
SqlDataReader idr = cmd.ExecuteReader();
if (idr.HasRows)
{
UnitsDash = populateUnitsDashLisst(idr, con);
}
}
con.Close();
return(JsonConvert.SerializeObject(UnitsDash));
}
public static string getNursesData(UnitsDash unit)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <Nurses> Nurses = new List <Nurses>();
List <UnitsDash> UnitsDash = new List <UnitsDash>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (
SqlCommand cmd =
new SqlCommand("select * from adminusers where Role_id = 17 and Area_id = @Unit_id",
con)
)
{
cmd.Parameters.Add("@Unit_id", SqlDbType.Int).Value =
unit.Unit_id;
SqlDataReader idr = cmd.ExecuteReader();
if (idr.HasRows)
{
Nurses = populateNursesLisst(idr, con);
}
}
con.Close();
return(JsonConvert.SerializeObject(Nurses));
}
public static string confirmEndorsing(UnitsDash id)
{
string config = Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <UnitsDash> UnitsDash = new List <UnitsDash>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (SqlCommand cmd1 = new SqlCommand("update Endorsement_UnitsDashboard set Confirm = 'True' where id = @id", con))
{
cmd1.Parameters.Add("@id", SqlDbType.Int).Value = id.id;
SqlDataReader idr = cmd1.ExecuteReader();
}
con.Close();
return(JsonConvert.SerializeObject(UnitsDash));
}
