/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param> private void BindGrid() { TenureLandBLL objTenureLandBLL = new TenureLandBLL(); GrdLandTenure.DataSource = objTenureLandBLL.GetTenureLand(""); GrdLandTenure.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 LND_TENUREID = ((Literal)gr.FindControl("litTenureLandID")).Text; TenureLandBLL objTenureLandBLL = new TenureLandBLL(); message = objTenureLandBLL.ObsoleteTenureLand(Convert.ToInt32(LND_TENUREID), Convert.ToString(chk.Checked)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } BindGrid(); 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 GrdLandTenure_RowCommand(object sender, GridViewCommandEventArgs e) { string message = string.Empty; if (e.CommandName == "EditRow") { ShowHideSections(true, false); ViewState["LND_TENUREID"] = e.CommandArgument; TenureLandBO objTenureLand = null; TenureLandBLL objTenureLandBLL = new TenureLandBLL(); objTenureLand = objTenureLandBLL.GetTenureLandByTenureLand(Convert.ToInt32(ViewState["LND_TENUREID"])); txtLandtenure.Text = objTenureLand.Lnd_Tenure; SetUpdateMode(true); ScriptManager.RegisterStartupScript(this, this.GetType(), "Added", "setDirty();", true); } else if (e.CommandName == "DeleteRow") { TenureLandBLL objTenureLandBLL = new TenureLandBLL(); message = objTenureLandBLL.DeleteTenureLand(Convert.ToInt32(e.CommandArgument)); BindGrid(); SetUpdateMode(false); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data deleted successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } }
/// <summary> /// Search tenureland 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) { TenureLandBO objTenureLand = new TenureLandBO(); string TenureLandName; TenureLandName = txtSearch.Text.Trim(); TenureLandBLL objTenureLandBLL = new TenureLandBLL(); GrdLandTenure.DataSource = objTenureLandBLL.GetTenureLand(TenureLandName); GrdLandTenure.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 = ""; TenureLandBO objTenureLand = new TenureLandBO(); objTenureLand.Lnd_TenureId = Convert.ToInt32(ViewState["LND_TENUREID"]); objTenureLand.Lnd_Tenure = txtLandtenure.Text.Trim(); TenureLandBLL objTenureLandBLL = new TenureLandBLL(); if (objTenureLand.Lnd_TenureId == 0) { objTenureLand.CreatedBy = Convert.ToInt32(Session["USER_ID"]); message = objTenureLandBLL.AddTenureLand(objTenureLand); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } } else { objTenureLand.UpdatedBy = Convert.ToInt32(Session["USER_ID"]); message = objTenureLandBLL.UpdateTenureLand(objTenureLand); 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(); }