protected void grdOptionAvailable_RowCommand(object sender, GridViewCommandEventArgs e) { string message = string.Empty; if (e.CommandName == "EditRow") { ViewState["ConcernID"] = e.CommandArgument; int concrnID = Convert.ToInt32(ViewState["ConcernID"]); GetConcernDetails(concrnID); SetUpdateMode(true); ScriptManager.RegisterStartupScript(this, this.GetType(), "Added", "setDirty();", true); } else if (e.CommandName == "DeleteRow") { OptionAvailableBLL optionavailobj = new OptionAvailableBLL(); message = optionavailobj.Deleteoptionavail(Convert.ToInt32(e.CommandArgument)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data Deleted successfully"; } clear(); SetUpdateMode(false); BindGrid(false, true); } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } }
/// <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 CONCERNID = ((Literal)gr.FindControl("litOptionAvailableID")).Text; OptionAvailableBLL optionavailobj = new OptionAvailableBLL(); message = optionavailobj.Obsoleteoptionavail(Convert.ToInt32(CONCERNID), 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; } }
private void BindGrid(bool addRow, bool deleteRow) { OptionAvailableBLL optionavailobj = new OptionAvailableBLL(); grdOptionAvailable.DataSource = optionavailobj.GetAllOptionAvail(); grdOptionAvailable.DataBind(); }
private void GetConcernDetails(int ConcernID) { OptionAvailableBLL optionavailobj = new OptionAvailableBLL(); OptionAvailableBO optionavailbo = new OptionAvailableBO(); optionavailbo = optionavailobj.GetAllOptionById(ConcernID); OptionAvailableTextBox.Text = optionavailbo.OptionAvailable; OptionAvailableIDTextBox.Text = optionavailbo.ID.ToString(); }
protected void SaveButton_Click(object sender, EventArgs e) { string AlertMessage = string.Empty; string message = string.Empty; if (OptionAvailableIDTextBox.Text.ToString().Trim() == string.Empty) { OptionAvailableBLL optionavailsal = new OptionAvailableBLL(); try { string uID = Session["USER_ID"].ToString(); OptionAvailableBO objOptionAvailable = new OptionAvailableBO(); objOptionAvailable.OptionAvailable = OptionAvailableTextBox.Text.ToString().Trim();; objOptionAvailable.UserID = Convert.ToInt32(uID); optionavailsal = new OptionAvailableBLL(); message = optionavailsal.Insert(objOptionAvailable); AlertMessage = "alert('" + message + "');"; if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; clear(); // ClearDetails(); BindGrid(true, true); } } catch (Exception ex) { throw ex; } finally { optionavailsal = null; } } //edit the data in the textbox exiting in the Grid else if (OptionAvailableIDTextBox.Text.ToString().Trim() != string.Empty) { OptionAvailableBLL optionavailsal = new OptionAvailableBLL(); try { string uID = Session["USER_ID"].ToString(); OptionAvailableBO objoptionavail = new OptionAvailableBO(); objoptionavail.OptionAvailable = OptionAvailableTextBox.Text.ToString().Trim(); objoptionavail.ID = Convert.ToInt32(OptionAvailableIDTextBox.Text.ToString().Trim()); objoptionavail.UserID = Convert.ToInt32(uID); optionavailsal = new OptionAvailableBLL(); message = optionavailsal.editoptionavail(objoptionavail); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; // ClearDetails(); clear(); SetUpdateMode(false); BindGrid(true, true); } } catch (Exception ex) { throw ex; } finally { optionavailsal = null; } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }