public static MedicationTime GetMedicationTimeByID(int id)
{
MedicationTime medicationTime = new MedicationTime();
SqlMedicationTimeProvider sqlMedicationTimeProvider = new SqlMedicationTimeProvider();
medicationTime = sqlMedicationTimeProvider.GetMedicationTimeByID(id);
return medicationTime;
}
public int InsertMedicationTime(MedicationTime medicationTime)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_InsertMedicationTime", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MedicationTimeID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@TakingTime", SqlDbType.NVarChar).Value = medicationTime.TakingTime;
cmd.Parameters.Add("@MedicineID", SqlDbType.Int).Value = medicationTime.MedicineID;
cmd.Parameters.Add("@ResidentID", SqlDbType.Int).Value = medicationTime.ResidentID;
cmd.Parameters.Add("@Quantity", SqlDbType.NVarChar).Value = medicationTime.Quantity;
cmd.Parameters.Add("@Quality", SqlDbType.NChar).Value = medicationTime.Quality;
cmd.Parameters.Add("@Frequency", SqlDbType.NVarChar).Value = medicationTime.Frequency;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = medicationTime.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = medicationTime.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = medicationTime.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = medicationTime.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = medicationTime.ExtraField5;
cmd.Parameters.Add("@ExtraField6", SqlDbType.NVarChar).Value = medicationTime.ExtraField6;
cmd.Parameters.Add("@ExtraField7", SqlDbType.NVarChar).Value = medicationTime.ExtraField7;
cmd.Parameters.Add("@ExtraField8", SqlDbType.NVarChar).Value = medicationTime.ExtraField8;
cmd.Parameters.Add("@ExtraField9", SqlDbType.NVarChar).Value = medicationTime.ExtraField9;
cmd.Parameters.Add("@ExtraField10", SqlDbType.NVarChar).Value = medicationTime.ExtraField10;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = medicationTime.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = medicationTime.AddedDate;
cmd.Parameters.Add("@UpdateBy", SqlDbType.Int).Value = medicationTime.UpdateBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = medicationTime.UpdateDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@MedicationTimeID"].Value);
}
}
public static MedicationTime GetMedicationTimeByID(int id)
{
MedicationTime medicationTime = new MedicationTime();
SqlMedicationTimeProvider sqlMedicationTimeProvider = new SqlMedicationTimeProvider();
medicationTime = sqlMedicationTimeProvider.GetMedicationTimeByID(id);
return(medicationTime);
}
private void showMedicationTimeData()
{
MedicationTime medicationTime = new MedicationTime();
medicationTime = MedicationTimeManager.GetMedicationTimeByID(Int32.Parse(Request.QueryString["medicationTimeID"]));
txtTakingTime.Text = medicationTime.TakingTime;
ddlMedicine.SelectedValue = medicationTime.MedicineID.ToString();
ddlResident.SelectedValue = medicationTime.ResidentID.ToString();
txtQuantity.Text = medicationTime.Quantity;
txtQuality.Text = medicationTime.Quality;
txtFrequency.Text = medicationTime.Frequency;
txtExtraField1.Text = medicationTime.ExtraField1;
txtExtraField2.Text = medicationTime.ExtraField2;
txtAddedBy.Text = medicationTime.AddedBy.ToString();
txtUpdateBy.Text = medicationTime.UpdateBy.ToString();
txtUpdateDate.Text = medicationTime.UpdateDate;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
MedicationTime medicationTime = new MedicationTime();
medicationTime.TakingTime = txtTakingTime.Text;
medicationTime.MedicineID = Int32.Parse(ddlMedicine.SelectedValue);
medicationTime.ResidentID = Int32.Parse(ddlResident.SelectedValue);
medicationTime.Quantity = txtQuantity.Text;
medicationTime.Quality = txtQuality.Text;
medicationTime.Frequency = txtFrequency.Text;
medicationTime.ExtraField1 = txtExtraField1.Text;
medicationTime.ExtraField2 = txtExtraField2.Text;
medicationTime.AddedBy = Int32.Parse(txtAddedBy.Text);
medicationTime.AddedDate = DateTime.Now;
medicationTime.UpdateBy = Int32.Parse(txtUpdateBy.Text);
medicationTime.UpdateDate = txtUpdateDate.Text;
int resutl = MedicationTimeManager.InsertMedicationTime(medicationTime);
Response.Redirect("AdminMedicationTimeDisplay.aspx");
}
protected void lbEdit_Click(object sender, EventArgs e)
{
ImageButton linkButton = new ImageButton();
linkButton = (ImageButton)sender;
int id;
id = Convert.ToInt32(linkButton.CommandArgument);
MedicationTime medicationTime = MedicationTimeManager.GetMedicationTimeByID(id);
hfMedicationTimeID.Value = medicationTime.MedicationTimeID.ToString();
txtTakingTime.Text = medicationTime.TakingTime == "PRN" ? "" : medicationTime.TakingTime;
chkPRN.Checked = medicationTime.TakingTime == "PRN" ? true : false;
string medicationName = MedicineManager.GetMedicineByID(medicationTime.MedicineID).MedicineName;
int medicaitonID = 0;
foreach (ListItem item in ddlMedicine.Items)
{
if (item.Text == medicationName)
{
medicaitonID = int.Parse(item.Value);
}
}
ddlMedicine.SelectedValue = medicaitonID.ToString();
txtQuantity.Text = medicationTime.Quantity;
txtQuality.Text = medicationTime.Quality;
txtFrequency.Text = medicationTime.Frequency;
txtEXNo.Text = medicationTime.ExtraField1;
ddlRouteOfAdmin.SelectedValue = medicationTime.ExtraField2;
txtAmount.Text = medicationTime.ExtraField3;
txtpharmacyName.Text = medicationTime.ExtraField4;
ddlStatus.SelectedValue = medicationTime.ExtraField6 != null ? medicationTime.ExtraField6 : "Active";
//chkAddDischargeRecord.Checked=bool.Parse(medicationTime.ExtraField5);
}
public static bool UpdateMedicationTime(MedicationTime medicationTime)
{
SqlMedicationTimeProvider sqlMedicationTimeProvider = new SqlMedicationTimeProvider();
return sqlMedicationTimeProvider.UpdateMedicationTime(medicationTime);
}
public static int InsertMedicationTime(MedicationTime medicationTime)
{
SqlMedicationTimeProvider sqlMedicationTimeProvider = new SqlMedicationTimeProvider();
return sqlMedicationTimeProvider.InsertMedicationTime(medicationTime);
}
public static bool UpdateMedicationTime(MedicationTime medicationTime)
{
SqlMedicationTimeProvider sqlMedicationTimeProvider = new SqlMedicationTimeProvider();
return(sqlMedicationTimeProvider.UpdateMedicationTime(medicationTime));
}
public static int InsertMedicationTime(MedicationTime medicationTime)
{
SqlMedicationTimeProvider sqlMedicationTimeProvider = new SqlMedicationTimeProvider();
return(sqlMedicationTimeProvider.InsertMedicationTime(medicationTime));
}
public MedicationTime GetMedicationTimeFromReader(IDataReader reader)
{
try
{
MedicationTime medicationTime = new MedicationTime
(
(int)reader["MedicationTimeID"],
reader["TakingTime"].ToString(),
(int)reader["MedicineID"],
(int)reader["ResidentID"],
reader["Quantity"].ToString(),
reader["Quality"].ToString(),
reader["Frequency"].ToString(),
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
(int)reader["AddedBy"],
(DateTime)reader["AddedDate"],
(int)reader["UpdateBy"],
(DateTime)reader["UpdateDate"]
);
try
{
medicationTime.ExtraField3 = reader["ExtraField3"].ToString();
medicationTime.ExtraField4 = reader["ExtraField4"].ToString();
medicationTime.ExtraField5 = reader["ExtraField5"].ToString();
}
catch (Exception ex)
{ }
try
{
medicationTime.ExtraField6 = reader["ExtraField6"].ToString();
}
catch (Exception ex)
{ }
try
{
medicationTime.ExtraField7 = reader["ExtraField7"].ToString();
}
catch (Exception ex)
{ }
try
{
medicationTime.ExtraField8 = reader["ExtraField8"].ToString();
}
catch (Exception ex)
{ }
try
{
medicationTime.ExtraField9 = reader["ExtraField9"].ToString();
}
catch (Exception ex)
{ }
try
{
medicationTime.ExtraField10 = reader["ExtraField10"].ToString();
}
catch (Exception ex)
{ }
return(medicationTime);
}
catch (Exception ex)
{
return(null);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (txtNewMedicine.Text != "")
{
Medicine medicine = new Medicine();
medicine.MedicineName = txtNewMedicine.Text;
medicine.MedicineID = MedicineManager.InsertMedicine(medicine);
loadMedicine();
ddlMedicine.SelectedValue = medicine.MedicineID.ToString();
}
if (hfMedicationTimeID.Value == "0")
{
//if (!txtTakingTime.Text.Contains(","))
//{
// txtTakingTime.Text = txtTakingTime.Text + ",";
//}
//foreach (string item in txtTakingTime.Text.Split(','))
//{
// if (item != "")
// {
MedicationTime medicationTime = new MedicationTime();
medicationTime.TakingTime = chkPRN.Checked ? "PRN" : txtTakingTime.Text;
medicationTime.MedicineID = Int32.Parse(ddlMedicine.SelectedValue);
medicationTime.ResidentID = Int32.Parse(Request.QueryString["ResidentID"]);
medicationTime.Quantity = txtQuantity.Text;
medicationTime.Quality = txtQuality.Text;
medicationTime.Frequency = txtFrequency.Text;
medicationTime.ExtraField1 = txtEXNo.Text;
medicationTime.ExtraField2 = ddlRouteOfAdmin.SelectedValue;
medicationTime.ExtraField3 = txtAmount.Text;
medicationTime.ExtraField4 = txtpharmacyName.Text;
medicationTime.ExtraField5 = chkAddDischargeRecord.Checked.ToString();
medicationTime.ExtraField6 = ddlStatus.SelectedValue;
medicationTime.ExtraField7 = "";
medicationTime.ExtraField8 = "";
medicationTime.ExtraField9 = "";
medicationTime.ExtraField10 = "";
medicationTime.AddedBy = getLogin().LoginID;
medicationTime.AddedDate = DateTime.Now;
medicationTime.UpdateBy = getLogin().LoginID;
medicationTime.UpdateDate = DateTime.Now;
int resutl = MedicationTimeManager.InsertMedicationTime(medicationTime);
lblNewMedicationAddedSuccessfully.Text = "Added Successfully";
// }
//}
}
else
{
MedicationTime medicationTime = new MedicationTime();
medicationTime.MedicationTimeID = int.Parse(hfMedicationTimeID.Value);
medicationTime.TakingTime = chkPRN.Checked ? "PRN" : txtTakingTime.Text;
medicationTime.MedicineID = Int32.Parse(ddlMedicine.SelectedValue);
medicationTime.ResidentID = Int32.Parse(Request.QueryString["ResidentID"]);
medicationTime.Quantity = txtQuantity.Text;
medicationTime.Quality = txtQuality.Text;
medicationTime.Frequency = txtFrequency.Text;
medicationTime.ExtraField1 = txtEXNo.Text;
medicationTime.ExtraField2 = ddlRouteOfAdmin.SelectedValue;
medicationTime.ExtraField3 = txtAmount.Text;
medicationTime.ExtraField4 = txtpharmacyName.Text;
medicationTime.ExtraField5 = chkAddDischargeRecord.Checked.ToString();
medicationTime.ExtraField6 = ddlStatus.SelectedValue;
medicationTime.ExtraField7 = "";
medicationTime.ExtraField8 = "";
medicationTime.ExtraField9 = "";
medicationTime.ExtraField10 = "";
medicationTime.AddedBy = getLogin().LoginID;
medicationTime.AddedDate = DateTime.Now;
medicationTime.UpdateBy = getLogin().LoginID;
medicationTime.UpdateDate = DateTime.Now;
MedicationTimeManager.UpdateMedicationTime(medicationTime);
hfMedicationTimeID.Value = "0";
lblNewMedicationAddedSuccessfully.Text = "Update Successfully";
}
lblMsg.Visible = false;
lblNewMedicationAddedSuccessfully.Visible = true;
//ddlMedicine.SelectedValue = "0";
//txtTakingTime.Text = "";
//txtQuality.Text = "";
//txtQuantity.Text = "";
//txtFrequency.Text = "";
loadGrid();
}
public bool UpdateMedicationTime(MedicationTime medicationTime)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AL_UpdateMedicationTime", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MedicationTimeID", SqlDbType.Int).Value = medicationTime.MedicationTimeID;
cmd.Parameters.Add("@TakingTime", SqlDbType.NVarChar).Value = medicationTime.TakingTime;
cmd.Parameters.Add("@MedicineID", SqlDbType.Int).Value = medicationTime.MedicineID;
cmd.Parameters.Add("@ResidentID", SqlDbType.Int).Value = medicationTime.ResidentID;
cmd.Parameters.Add("@Quantity", SqlDbType.NVarChar).Value = medicationTime.Quantity;
cmd.Parameters.Add("@Quality", SqlDbType.NChar).Value = medicationTime.Quality;
cmd.Parameters.Add("@Frequency", SqlDbType.NVarChar).Value = medicationTime.Frequency;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = medicationTime.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = medicationTime.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = medicationTime.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = medicationTime.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = medicationTime.ExtraField5;
cmd.Parameters.Add("@ExtraField6", SqlDbType.NVarChar).Value = medicationTime.ExtraField6;
cmd.Parameters.Add("@ExtraField7", SqlDbType.NVarChar).Value = medicationTime.ExtraField7;
cmd.Parameters.Add("@ExtraField8", SqlDbType.NVarChar).Value = medicationTime.ExtraField8;
cmd.Parameters.Add("@ExtraField9", SqlDbType.NVarChar).Value = medicationTime.ExtraField9;
cmd.Parameters.Add("@ExtraField10", SqlDbType.NVarChar).Value = medicationTime.ExtraField10;
cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = medicationTime.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = medicationTime.AddedDate;
cmd.Parameters.Add("@UpdateBy", SqlDbType.Int).Value = medicationTime.UpdateBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = medicationTime.UpdateDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public MedicationTime GetMedicationTimeFromReader(IDataReader reader)
{
try
{
MedicationTime medicationTime = new MedicationTime
(
(int)reader["MedicationTimeID"],
reader["TakingTime"].ToString(),
(int)reader["MedicineID"],
(int)reader["ResidentID"],
reader["Quantity"].ToString(),
reader["Quality"].ToString(),
reader["Frequency"].ToString(),
reader["ExtraField1"].ToString(),
reader["ExtraField2"].ToString(),
(int)reader["AddedBy"],
(DateTime)reader["AddedDate"],
(int)reader["UpdateBy"],
(DateTime)reader["UpdateDate"]
);
try
{
medicationTime.ExtraField3 = reader["ExtraField3"].ToString();
medicationTime.ExtraField4 = reader["ExtraField4"].ToString();
medicationTime.ExtraField5 = reader["ExtraField5"].ToString();
}
catch (Exception ex)
{ }
try
{
medicationTime.ExtraField6 = reader["ExtraField6"].ToString();
}
catch (Exception ex)
{ }
try
{
medicationTime.ExtraField7 = reader["ExtraField7"].ToString();
}
catch (Exception ex)
{ }
try
{
medicationTime.ExtraField8 = reader["ExtraField8"].ToString();
}
catch (Exception ex)
{ }
try
{
medicationTime.ExtraField9 = reader["ExtraField9"].ToString();
}
catch (Exception ex)
{ }
try
{
medicationTime.ExtraField10 = reader["ExtraField10"].ToString();
}
catch (Exception ex)
{ }
return medicationTime;
}
catch(Exception ex)
{
return null;
}
}
