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; } }