/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid(bool addRow, bool deleteRow) { objShocksExperiencedBLL = new ShocksExperiencedBLL(); grdShocksExperience.DataSource = objShocksExperiencedBLL.GetALLShocksExperienced(); grdShocksExperience.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 ShockID = ((Literal)gr.FindControl("litShocksExperiencedID")).Text; ShocksExperiencedBLL objShocksExperiencedBLL = new ShocksExperiencedBLL(); message = objShocksExperiencedBLL.Obsoleteshockexperiencedid(Convert.ToInt32(ShockID), Convert.ToString(chk.Checked)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } ClearDetails(); BindGrid(true, true); SetUpdateMode(false); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } }
/// <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 grdShocksExperience_RowCommand(object sender, GridViewCommandEventArgs e) { string message = string.Empty; if (e.CommandName == "EditRow") { ViewState["ShockID"] = e.CommandArgument; SetUpdateMode(true); GetShocksExperiencedDetails(); ScriptManager.RegisterStartupScript(this, this.GetType(), "Added", "setDirty();", true); } else if (e.CommandName == "DeleteRow") { ShocksExperiencedBLL objShocksExperiencedBLL = new ShocksExperiencedBLL(); message = objShocksExperiencedBLL.DeleteShocksExperienced(Convert.ToInt32(e.CommandArgument)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data Deleted successfully"; } ClearDetails(); BindGrid(true, true); SetUpdateMode(false); } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } }
//private string DeleteShocksExperienced() //{ // objShocksExperiencedBLL = new ShocksExperiencedBLL(); // int ShocksExperiencedID = 0; // int Result = 0; // if (ViewState["ShockID"] != null) // ShocksExperiencedID = Convert.ToInt32(ViewState["ShockID"].ToString()); // Result = objShocksExperiencedBLL.DeleteShocksExperienced(ShocksExperiencedID); //} #endregion #region Save Record /// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { objShocksExperienced = new ShocksExperiencedBO(); objShocksExperiencedBLL = new ShocksExperiencedBLL(); string AlertMessage = string.Empty; string message = string.Empty; //Assignement objShocksExperienced.ShocksExperience = txtShocksExperienced.Text.Trim(); if (ViewState["ShockID"] != null) { objShocksExperienced.ShocksExperiencedID = Convert.ToInt32(ViewState["ShockID"].ToString()); } objShocksExperienced.IsDeleted = "False"; //if (Session["USER_ID"] != null) objShocksExperienced.CreatedBy = Convert.ToInt32(Session["USER_ID"].ToString()); if (objShocksExperienced.ShocksExperiencedID < 1) { //If ShocksExperiencedID does Not exists then SaveShocksExperienced objShocksExperienced.ShocksExperiencedID = -1;//For New ShocksExperienced message = objShocksExperiencedBLL.AddShocksExperienced(objShocksExperienced); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; ClearDetails(); BindGrid(true, true); } } else { //If ShocksExperiencedID exists then UpdateShocksExperienced message = objShocksExperiencedBLL.UpdateShocksExperienced(objShocksExperienced); //For Updating ShocksExperienced if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; ClearDetails(); BindGrid(true, true); SetUpdateMode(false); } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }
/// <summary> /// To update details into database /// </summary> private void GetShocksExperiencedDetails() { objShocksExperiencedBLL = new ShocksExperiencedBLL(); int ShocksExperiencedID = 0; if (ViewState["ShockID"] != null) { ShocksExperiencedID = Convert.ToInt32(ViewState["ShockID"].ToString()); } objShocksExperienced = new ShocksExperiencedBO(); objShocksExperienced = objShocksExperiencedBLL.GetShocksExperiencedById(ShocksExperiencedID); txtShocksExperienced.Text = objShocksExperienced.ShocksExperience; }
// To get type of shock from MST_SHOCKSEXPERIENCED public void GetTypeofshock() { string SHOCKID = string.Empty; if (typeofshockDropDownList.SelectedValue.ToString() == "") { SHOCKID = "0"; //msgSaveLabel.Text = null; // if value is select then error msg will display } else { // SHOCKID = typeofshockDropDownList.SelectedValue.ToString(); // get UI screen Value DataSet Ds = new DataSet(); // MajorshockBLL Typeofshock_BLL = new MajorshockBLL(); // Function or object creation for next layer ShocksExperiencedBLL Typeofshock_BLL = new ShocksExperiencedBLL(); objShocksExperiencedList = new ShocksExperiencedList(); // Ds = Typeofshock_BLL.GetShocksExperienced(SHOCKID); // data pass through object SHOCKID objShocksExperiencedList = Typeofshock_BLL.GetShocksExperienced(); try { //if (Ds.Tables[0].Rows.Count > 0) // Data from BLL if (objShocksExperiencedList.Count > 0) { typeofshockDropDownList.DataSource = objShocksExperiencedList; //typeofshockDropDownList.DataTextField = Ds.Tables[0].Columns[1].ToString(); //typeofshockDropDownList.DataValueField = Ds.Tables[0].Columns[0].ToString(); typeofshockDropDownList.DataTextField = "ShocksExperience"; typeofshockDropDownList.DataValueField = "ShocksExperiencedID"; typeofshockDropDownList.DataBind(); //typeofshockDropDownList.Items.Insert(0, "--Select--"); } } catch (Exception ee) { throw ee; } finally // set the finally class nothing but Empty the object { Typeofshock_BLL = null; } } }