/// <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 structureConditionID = ((Literal)gr.FindControl("litStructureConditionID")).Text; objStructureConditionBLL = new StructureConditionBLL(); message = objStructureConditionBLL.ObsoleteStructureCondition(Convert.ToInt32(structureConditionID), 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; } }
private void GetConditionData() { StructureConditionBLL BLLobj = new StructureConditionBLL(); ddlRoofCondition.DataSource = BLLobj.GetStructureCondition(); ddlRoofCondition.DataTextField = "StructureConditionName"; ddlRoofCondition.DataValueField = "StructureConditionID"; ddlRoofCondition.DataBind(); ddlWallsCondition.DataSource = BLLobj.GetStructureCondition(); ddlWallsCondition.DataTextField = "StructureConditionName"; ddlWallsCondition.DataValueField = "StructureConditionID"; ddlWallsCondition.DataBind(); ddlFloorCondition.DataSource = BLLobj.GetStructureCondition(); ddlFloorCondition.DataTextField = "StructureConditionName"; ddlFloorCondition.DataValueField = "StructureConditionID"; ddlFloorCondition.DataBind(); ddlWindowsCondition.DataSource = BLLobj.GetStructureCondition(); ddlWindowsCondition.DataTextField = "StructureConditionName"; ddlWindowsCondition.DataValueField = "StructureConditionID"; ddlWindowsCondition.DataBind(); }
/// <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 = string.Empty; string AlertMessage = string.Empty; objStructureCondition = new StructureConditionBO(); objStructureConditionBLL = new StructureConditionBLL(); //Assignement objStructureCondition.StructureConditionName = txtStructureCondition.Text.Trim(); if (ViewState["StructureConditionID"] != null) { objStructureCondition.StructureConditionID = Convert.ToInt32(ViewState["StructureConditionID"].ToString()); } objStructureCondition.IsDeleted = "False"; //if (Session["USER_ID"] != null) objStructureCondition.CreatedBy = Convert.ToInt32(Session["USER_ID"].ToString()); if (objStructureCondition.StructureConditionID < 1) { //If StructureConditionID does Not exists then SaveStructureCondition objStructureCondition.StructureConditionID = -1;//For New StructureCondition message = objStructureConditionBLL.AddStructureCondition(objStructureCondition); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully."; ClearDetails(); BindGrid(true, false); } } else { //If StructureConditionID exists then UpdateStructureCondition message = objStructureConditionBLL.UpdateStructureCondition(objStructureCondition); //For Updating StructureCondition if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully."; ClearDetails(); BindGrid(true, false); } } if (message != null) { AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); } ClearDetails(); SetUpdateMode(false); }
/// <summary> /// to assign values to dropdownlist /// </summary> private void GetCondition() { StructureConditionBLL BLLobj = new StructureConditionBLL(); conditionDropDownList.DataSource = BLLobj.GetStructureCondition(); conditionDropDownList.DataTextField = "StructureConditionName"; conditionDropDownList.DataValueField = "StructureConditionID"; conditionDropDownList.DataBind(); conditionDropDownList.Items.Insert(0, new ListItem("--Select--", "0")); }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid(bool addRow, bool deleteRow) { objStructureConditionBLL = new StructureConditionBLL(); objStructureCondition = new StructureConditionBO(); objStructureCondition.StructureConditionName = string.Empty; objStructureCondition.StructureConditionID = 0; grdStructureCondition.DataSource = objStructureConditionBLL.GetAllStructureCondition();//(objStructureCondition); grdStructureCondition.DataBind(); }
/// <summary> /// to fetch details from database and assign to textbox /// </summary> private void GetStructureConditionDetails() { objStructureConditionBLL = new StructureConditionBLL(); int StructureConditionID = 0; if (ViewState["StructureConditionID"] != null) { StructureConditionID = Convert.ToInt32(ViewState["StructureConditionID"].ToString()); } objStructureCondition = new StructureConditionBO(); objStructureCondition = objStructureConditionBLL.GetStructureConditionById(StructureConditionID); txtStructureCondition.Text = objStructureCondition.StructureConditionName; }
/// <summary> /// To soft delete data from database /// </summary> private void DeleteStructureCondition(string conditionID) { objStructureConditionBLL = new StructureConditionBLL(); string message = string.Empty; message = objStructureConditionBLL.DeleteStructureCondition(Convert.ToInt32(conditionID)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data deleted successfully"; } ClearDetails(); BindGrid(false, true); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } }