/// <summary> /// Set edit mode for edit comand /// Delete data from the database for delete comand /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void grdVaccination_RowCommand(object sender, GridViewCommandEventArgs e) { string message = string.Empty; if (e.CommandName == "EditRow") { ViewState["VACCINATIONID"] = e.CommandArgument; GetVaccinationDetails(); SetUpdateMode(true); } else if (e.CommandName == "DeleteRow") { //ViewState["VACCINATIONID"] = e.CommandArgument; VaccinationBLL VaccinationBLLobj = new VaccinationBLL(); message = VaccinationBLLobj.DeleteVaccination(Convert.ToInt32(e.CommandArgument)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data Deleted successfully"; } SetUpdateMode(true); BindGrid(false, true); } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } //{ // ViewState["VACCINATIONID"] = e.CommandArgument; // DeleteVaccination(); // BindGrid(false, true); //} }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param> private void BindGrid(bool addRow, bool deleteRow) { VaccinationBLL VaccinationBLLobj = new VaccinationBLL(); grdVaccination.DataSource = VaccinationBLLobj.GetALLVaccination(); grdVaccination.DataBind(); }
/// <summary> /// Update Database Make data as Obsoluted /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void IsObsolete_CheckedChanged(Object sender, EventArgs e) { string message = string.Empty; try { CheckBox chk = (CheckBox)sender; GridViewRow gr = (GridViewRow)chk.Parent.Parent; string VACCINATIONID = ((Literal)gr.FindControl("litVACCINATIONID")).Text; int VACCINATIONID_ = Convert.ToInt32(VACCINATIONID); VaccinationBLL VaccinationBLLobj = new VaccinationBLL(); message = VaccinationBLLobj.Obsoletevaccination(VACCINATIONID_, Convert.ToString(chk.Checked)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } BindGrid(false, true); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } }
/// <summary> /// Get the details. /// </summary> private void GetVaccinationDetails() { VaccinationBLL VaccinationBLLobj = new VaccinationBLL(); int VaccinationID = 0; if (ViewState["VACCINATIONID"] != null) { VaccinationID = Convert.ToInt32(ViewState["VACCINATIONID"]); } VaccinationBO Vaccinationobj = new VaccinationBO(); Vaccinationobj = VaccinationBLLobj.GetVaccinationById(VaccinationID); VaccinationTextBox.Text = Vaccinationobj.VACCINATIONNAME; VACCINATIONIDTextBox.Text = Vaccinationobj.VACCINATIONID.ToString(); }
/// <summary> /// Save the data into database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { string AlertMessage = string.Empty; string message = string.Empty; if (VACCINATIONIDTextBox.Text.ToString().Trim() == string.Empty) { VaccinationBLL VaccinationBLLobj = new VaccinationBLL(); try { string uID = Session["USER_ID"].ToString(); VaccinationBO Vaccinationobj = new VaccinationBO(); Vaccinationobj.VACCINATIONNAME = VaccinationTextBox.Text.ToString().Trim(); Vaccinationobj.Createdby = Convert.ToInt32(uID); VaccinationBLL BLLobj = new VaccinationBLL(); message = BLLobj.Insert(Vaccinationobj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; ClearAll(); BindGrid(true, true); } } catch (Exception ex) { throw ex; } finally { VaccinationBLLobj = null; } } //edit the data in the textbox exiting in the Grid else if (VACCINATIONIDTextBox.Text.ToString().Trim() != string.Empty) { VaccinationBLL VaccinationBLLobj = new VaccinationBLL(); try { string uID = Session["USER_ID"].ToString(); VaccinationBO Vaccinationobj = new VaccinationBO(); Vaccinationobj.VACCINATIONNAME = VaccinationTextBox.Text.ToString().Trim(); Vaccinationobj.VACCINATIONID = Convert.ToInt32(VACCINATIONIDTextBox.Text.ToString().Trim()); Vaccinationobj.Createdby = Convert.ToInt32(uID); VaccinationBLL BLLobj = new VaccinationBLL(); message = BLLobj.EditVaccination(Vaccinationobj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; ClearAll(); BindGrid(true, true); SetUpdateMode(false); } } catch (Exception ex) { throw ex; } finally { VaccinationBLLobj = null; } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }