/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param> private void BindGrid(bool addRow, bool deleteRow) { TenureStructureBLL objTenureStructureBLL = new TenureStructureBLL(); GrdStructureTenure.DataSource = objTenureStructureBLL.GetAllTenureStructures(""); GrdStructureTenure.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 tenureID = ((Literal)gr.FindControl("litTenureStructureID")).Text; TenureStructureBLL objTenureStructureBLL = new TenureStructureBLL(); message = objTenureStructureBLL.ObsoleteTenureStructure(Convert.ToInt32(tenureID), 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; } }
/// <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 GrdStructureTenure_RowCommand(object sender, GridViewCommandEventArgs e) { string message = string.Empty; if (e.CommandName == "EditRow") { ShowHideSections(true, false); ViewState["STR_TENUREID"] = e.CommandArgument; TenureStructureBLL objTenureStructureBLL = new TenureStructureBLL(); TenureStructureBO objTenureStructure = objTenureStructureBLL.GetTenureStructureItem(Convert.ToInt32(ViewState["STR_TENUREID"])); txtStructuretenure.Text = objTenureStructure.Str_Tenure; SetUpdateMode(true); ScriptManager.RegisterStartupScript(this, this.GetType(), "Added", "setDirty();", true); } else if (e.CommandName == "DeleteRow") { TenureStructureBLL objTenureStructureBLL = new TenureStructureBLL(); message = objTenureStructureBLL.DeleteTenureStructure(Convert.ToInt32(e.CommandArgument)); SetUpdateMode(false); BindGrid(false, true); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data deleted successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } }
/// <summary> /// to bind the data from the database to the dropdown ddlTenureType /// </summary> private void bindDDLTenure() { objTenureStructureBLL = new TenureStructureBLL(); objTenureStructureList = objTenureStructureBLL.GetTenureStructures(""); ddlTenureType.DataSource = objTenureStructureList; ddlTenureType.DataTextField = "STR_TENURE"; ddlTenureType.DataValueField = "STR_TENUREID"; ddlTenureType.DataBind(); }
/// <summary> /// Search banks data from the database and set filterd data to Grid Data source /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSearch_Click(object sender, EventArgs e) { string TenureStructureName; TenureStructureName = txtSearch.Text.Trim(); TenureStructureBLL objTenureStructureBLL = new TenureStructureBLL(); GrdStructureTenure.DataSource = objTenureStructureBLL.GetTenureStructures(TenureStructureName); GrdStructureTenure.DataBind(); }
/// <summary> /// Save and Update Data into Database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_Save_Click(object sender, EventArgs e) { string message = ""; TenureStructureBO objTenureStructure = new TenureStructureBO(); objTenureStructure.Str_TenureId = Convert.ToInt32(ViewState["STR_TENUREID"]); objTenureStructure.Str_Tenure = txtStructuretenure.Text.Trim(); TenureStructureBLL objTenureStructureBLL = new TenureStructureBLL(); if (objTenureStructure.Str_TenureId == 0) { objTenureStructure.CreatedBy = Convert.ToInt32(Session["USER_ID"]); message = objTenureStructureBLL.AddTenureStructure(objTenureStructure); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } } else { objTenureStructure.UpdatedBy = Convert.ToInt32(Session["USER_ID"]); message = objTenureStructureBLL.UpdateTenureStructure(objTenureStructure); SetUpdateMode(false); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } ClearDetails(); BindGrid(true, false); }