/// <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 structureTypeID = ((Literal)gr.FindControl("litStructureTypeID")).Text; StructureTypeBLL oStructureTypeBLL = new StructureTypeBLL(); message = oStructureTypeBLL.ObsoleteStructureType(Convert.ToInt32(structureTypeID), Convert.ToString(chk.Checked)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } ClearDetails(); BindGrid(false, true); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } }
/// <summary> /// To get the structure type /// </summary> private void GetStructureTypeData() { StructureTypeBLL BLLobj = new StructureTypeBLL(); ddlBuidingType.DataSource = BLLobj.GetStructureType(); ddlBuidingType.DataTextField = "StructureTypeName"; ddlBuidingType.DataValueField = "StructureTypeID"; ddlBuidingType.DataBind(); }
/// <summary> /// to assign values to dropdownlist /// </summary> private void GetBuildingType() { StructureTypeBLL BLLobj = new StructureTypeBLL(); buildingtypeDropDownList.DataSource = BLLobj.GetStructureType(); buildingtypeDropDownList.DataTextField = "StructureTypeName"; buildingtypeDropDownList.DataValueField = "StructureTypeID"; buildingtypeDropDownList.DataBind(); buildingtypeDropDownList.Items.Insert(0, new ListItem("--Select--", "0")); }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param> #region Load Grid / Bind Grid private void BindGrid(bool addRow, bool deleteRow) { objStructureTypeBLL = new StructureTypeBLL(); objStructureType = new StructureTypeBO(); objStructureType.StructureTypeName = string.Empty; objStructureType.StructureTypeID = 0; grdStructureType.DataSource = objStructureTypeBLL.GetAllStructureType();//(objStructureType); grdStructureType.DataBind(); }
/// <summary> /// Update Data into Database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> #region Edit Record private void GetStructureTypeDetails() { objStructureTypeBLL = new StructureTypeBLL(); int StructureTypeID = 0; if (ViewState["StructureTypeID"] != null) { StructureTypeID = Convert.ToInt32(ViewState["StructureTypeID"].ToString()); } objStructureType = new StructureTypeBO(); objStructureType = objStructureTypeBLL.GetStructureTypeById(StructureTypeID); txtStructureType.Text = objStructureType.StructureTypeName; }
/// <summary> /// Save and Update Data into Database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> #region Save Record protected void btnSave_Click(object sender, EventArgs e) { string message = string.Empty; string AlertMessage = string.Empty; objStructureType = new StructureTypeBO(); objStructureTypeBLL = new StructureTypeBLL(); //Assignement objStructureType.StructureTypeName = txtStructureType.Text.Trim(); if (ViewState["StructureTypeID"] != null) { objStructureType.StructureTypeID = Convert.ToInt32(ViewState["StructureTypeID"].ToString()); } objStructureType.IsDeleted = "False"; //if (Session["USER_ID"] != null) objStructureType.CreatedBy = Convert.ToInt32(Session["USER_ID"].ToString()); if (objStructureType.StructureTypeID < 1) { //If StructureTypeID does Not exists then SaveStructureType objStructureType.StructureTypeID = -1;//For New StructureType message = objStructureTypeBLL.AddStructureType(objStructureType); AlertMessage = "alert('" + message + "');"; if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully."; } } else { //If StructureTypeID exists then UpdateStructureType message = objStructureTypeBLL.UpdateStructureType(objStructureType); //For Updating StructureType if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully."; } } ClearDetails(); BindGrid(true, false); AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); SetUpdateMode(false); }
/// <summary> /// Delete Data from Database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> #region Delete Record private void DeleteStructureType(string structureTypeID) { objStructureTypeBLL = new StructureTypeBLL(); string message = string.Empty; message = objStructureTypeBLL.DeleteStructureType(Convert.ToInt32(structureTypeID)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data Deleted successfully"; } ClearDetails(); SetUpdateMode(false); BindGrid(false, true); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } }