/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid(bool addRow, bool deleteRow) { OptionGroupBLL objOptionGroupBLL = new OptionGroupBLL(); grdOptionGroup.DataSource = objOptionGroupBLL.GetOptionGroup(); grdOptionGroup.DataBind(); }
/// <summary> /// To delete Optiongroup from grid /// </summary> private void DeleteOptionGroup(string optionGroupID) { OptionGroupBLL objOptionGroupBLL = new OptionGroupBLL(); string message = string.Empty; try { message = objOptionGroupBLL.DeleteOptionGroup(Convert.ToInt32(optionGroupID)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data deleted successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } BindGrid(false, true); } catch (Exception ex) { throw ex; } }
/// <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 OptionGroupID = ((Literal)gr.FindControl("litUserID")).Text; OptionGroupBLL objOptionGroupBLL = new OptionGroupBLL(); message = objOptionGroupBLL.ObsoleteOptionGroup(Convert.ToInt32(OptionGroupID), Convert.ToString(chk.Checked)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } BindGrid(true, false); } catch (Exception ex) { throw ex; } }
/// <summary> /// To fetch Optiongroup from database /// </summary> private void GetOptionGroupDetails() { OptionGroupBLL objOptionGroupBLL = new OptionGroupBLL(); int OptionGroupID = 0; if (ViewState["OptionGroupID"] != null) { OptionGroupID = Convert.ToInt32(ViewState["OptionGroupID"]); } OptionGroupBO objOptionGroupBO = new OptionGroupBO(); objOptionGroupBO = objOptionGroupBLL.GetOptionGroupById(OptionGroupID); txtOptionGroup.Text = objOptionGroupBO.OptionGroupName; }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string message = ""; OptionGroupBLL objOptionGroupBLL = new OptionGroupBLL(); if (Convert.ToInt32(ViewState["OptionGroupID"]) == 0) { try { string uID = Session["USER_ID"].ToString(); OptionGroupBO objOptionGroupBO = new OptionGroupBO(); objOptionGroupBO.OptionGroupName = txtOptionGroup.Text.ToString().Trim(); objOptionGroupBO.UserID = Convert.ToInt32(uID); message = objOptionGroupBLL.InsertOptionGroups(objOptionGroupBO); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } // txtOptionGroup.Text = "0"; if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } finally { objOptionGroupBLL = null; } BindGrid(true, true); } //edit the data in the textbox exiting in the Grid else if (Convert.ToInt32(ViewState["OptionGroupID"]) > 0) { try { string uID = Session["USER_ID"].ToString(); OptionGroupBO objOptionGroupBO = new OptionGroupBO(); objOptionGroupBO.OptionGroupName = txtOptionGroup.Text.ToString().Trim(); objOptionGroupBO.OptionGroupID = Convert.ToInt32(ViewState["OptionGroupID"]); objOptionGroupBO.UserID = Convert.ToInt32(uID); message = objOptionGroupBLL.UpdateOptionGroups(objOptionGroupBO); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } txtOptionGroup.Text = "0"; if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } finally { objOptionGroupBLL = null; } BindGrid(true, true); SetUpdateMode(false); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } ClearData(); }