long IALRD_GovernmentKhasLandDataDao.Update(ALRD_GovernmentKhasLandDataEntity entity, bool isPertial = false) { long returnCode = -99; string SP; if (!isPertial) { SP = "alrd_governmentkhaslanddata_Update"; } else { SP = "alrd_governmentkhaslanddata_PertialUpdate"; } using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { FillParameters(entity, cmd, Database); //FillSequrityParameters(securityCapsule, cmd, OparationType.Update, Database); AddOutputParameter(cmd); try { returnCode = Database.ExecuteNonQuery(cmd); } catch (Exception ex) { throw GetDataAccessException(ex, SourceOfException("Update")); } } return(returnCode); }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { this.CheckFormPermission(this.FormID); LoadCombo(); SearchEntity = new ALRD_GovernmentKhasLandDataEntity(); //if (Request.QueryString["hid"] != null && !string.IsNullOrEmpty(Request.QueryString["hid"].ToString())) if (GlobalClass.GovtInfoID > 0) { SearchEntity.COMPID = GlobalClass.GovtInfoID; } else { SearchEntity.COMPID = -99; } LoadEntity(SearchEntity); } } catch (Exception ex) { Error = ex.Message; } }
long IALRD_GovernmentKhasLandDataDao.Add(ALRD_GovernmentKhasLandDataEntity entity) { long returnCode = -99; const string SP = "alrd_governmentkhaslanddata_Insert"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { FillParameters(entity, cmd, Database); //FillSequrityParameters(securityCapsule, cmd, OparationType.Save, Database); AddOutputParameter(cmd); try { returnCode = Database.ExecuteNonQuery(cmd); // GetReturnCodeFromParameter(cmd); if (returnCode == 1) { returnCode = Convert.ToInt64(cmd.Parameters["@RETURN_KEY"].Value); } else { returnCode = -99; } } catch (Exception ex) { throw GetDataAccessException(ex, SourceOfException("Add")); } } return(returnCode); }
protected void lsvUserList_ItemCommand(object sender, ListViewCommandEventArgs e) { this.lblException.Text = ""; this.lblResult.Text = ""; try { string CommandName = e.CommandName.ToString(); string CommandArgument = e.CommandArgument.ToString(); if (CommandArgument.ToString() != "") { long Value = long.Parse(CommandArgument.ToString()); if (CommandName == "edit") { GlobalClass.GovtInfoID = Value; Response.Redirect("~/Pages/Admin/GovernmentKhasLandData.aspx", true); } else if (CommandName == "delete") { ALRD_GovernmentKhasLandDataEntity entity = new ALRD_GovernmentKhasLandDataEntity { COMPID = Value }; long i = ALRD_GovernmentKhasLandDataService.GetService().Delete(entity); LoadEntityList(new ALRD_GovernmentKhasLandDataEntity()); SuccessMessage = "Information Deleted Successfully"; } } } catch (Exception ex) { Error = ex.Message; } }
private void LoadEntityList(ALRD_GovernmentKhasLandDataEntity entity) { try { if (entity.PageSize < 0) { entity.PageSize = 10; } if (entity.SortExpression == string.Empty) { entity.SortExpression = "OrgName ASC"; } LocalEntityList = ALRD_GovernmentKhasLandDataService.GetService().GetAll(entity).ToList(); if (LocalEntityList != null && LocalEntityList.Count > 0) { lsvUserList.DataSource = LocalEntityList; lsvUserList.DataBind(); } else { lsvUserList.DataSource = null; lsvUserList.DataBind(); } } catch (Exception ex) { Error = ex.Message; } }
private ALRD_GovernmentKhasLandDataEntity BuiltEntity(ALRD_GovernmentKhasLandDataEntity entity = null) { try { if (entity == null) { entity = new ALRD_GovernmentKhasLandDataEntity(); } entity.COMPID = hdnCOMPID.Value.Trim() != string.Empty ? long.Parse(hdnCOMPID.Value.Trim()) : (long?)null; entity.CollCollectionYear = ddlYear.SelectedIndex > 0 ? long.Parse(ddlYear.SelectedValue) : (long?)null; entity.CollectionMonth = ddlMonth.SelectedIndex > 0 ? long.Parse(ddlMonth.SelectedValue) : (long?)null; entity.DivisionID = ddlDivision.SelectedIndex > 0 ? long.Parse(ddlDivision.SelectedValue) : (long?)null; entity.DistrictID = ddlDistrict.SelectedIndex > 0 ? long.Parse(ddlDistrict.SelectedValue) : (long?)null; entity.UpazilaID = ddlUpazilla.SelectedIndex > 0 ? long.Parse(ddlUpazilla.SelectedValue) : (long?)null; entity.Remarks = txtRemarks.Text != string.Empty ? txtRemarks.Text.Trim() : string.Empty; entity.TotalKhasLandAgri = txtTotalKhasLandAgri.Text.Trim() != string.Empty ? decimal.Parse(txtTotalKhasLandAgri.Text.Trim()) : (decimal?)null; entity.TotalKhasLandNonAgri = txtTotalKhasLandNonAgri.Text.Trim() != string.Empty ? decimal.Parse(txtTotalKhasLandNonAgri.Text.Trim()) : (decimal?)null; entity.DistributedKhasLandAgri = txtDistributedKhasLandAgri.Text.Trim() != string.Empty ? decimal.Parse(txtDistributedKhasLandAgri.Text.Trim()) : (decimal?)null; entity.DistributedKhasLandNonAgri = txtDistributedKhasLandNonAgri.Text.Trim() != string.Empty ? decimal.Parse(txtDistributedKhasLandNonAgri.Text.Trim()) : (decimal?)null; entity.DistributableKhasLandAgri = txtDistributableKhasLandAgri.Text.Trim() != string.Empty ? decimal.Parse(txtDistributableKhasLandAgri.Text.Trim()) : (decimal?)null; entity.DistributableKhasLandNonAgri = txtDistributableKhasLandNonAgri.Text.Trim() != string.Empty ? decimal.Parse(txtDistributableKhasLandNonAgri.Text.Trim()) : (decimal?)null; entity.NoOfFamilyGotKhasLandAgri = txtNoOfFamilyGotKhasLandAgri.Text.Trim() != string.Empty ? decimal.Parse(txtNoOfFamilyGotKhasLandAgri.Text.Trim()) : (decimal?)null; entity.NoOfFamilyGotKhasLandNonAgri = txtNoOfFamilyGotKhasLandNonAgri.Text.Trim() != string.Empty ? decimal.Parse(txtNoOfFamilyGotKhasLandNonAgri.Text.Trim()) : (decimal?)null; entity.IllegalOccupiedKhasLandAgri = txtIllegalOccupiedKhasLandAgri.Text.Trim() != string.Empty ? decimal.Parse(txtIllegalOccupiedKhasLandAgri.Text.Trim()) : (decimal?)null; entity.IllegalOccupiedKhasLandNonAgri = txtIllegalOccupiedKhasLandNonAgri.Text.Trim() != string.Empty ? decimal.Parse(txtIllegalOccupiedKhasLandNonAgri.Text.Trim()) : (decimal?)null; entity.KhasLandWithSuitCaseAgri = txtKhasLandWithSuitCaseAgri.Text.Trim() != string.Empty ? decimal.Parse(txtKhasLandWithSuitCaseAgri.Text.Trim()) : (decimal?)null; entity.KhasLandWithSuitCaseNonAgri = txtKhasLandWithSuitCaseNonAgri.Text.Trim() != string.Empty ? decimal.Parse(txtKhasLandWithSuitCaseNonAgri.Text.Trim()) : (decimal?)null; if (entity.COMPID.HasValue) { entity.UpdatedBy = GlobalClass.UserID; entity.UpdatedOn = DateTime.Now; entity.CreatedBy = hdnCreatedBy.Value.Trim() != string.Empty ? long.Parse(hdnCreatedBy.Value.Trim()) : (long?)null; entity.CreatedOn = GetDateFromString(hdnCreatedOn.Value.Trim()); } else { entity.CreatedBy = GlobalClass.UserID; entity.CreatedOn = DateTime.Now; } } catch (Exception ex) { throw ex; } return(entity); }
protected void btnFilter_Click(object sender, EventArgs e) { this.lblException.Text = ""; this.lblResult.Text = ""; try { SearchEntity = BuiltEntity(); LoadEntityList(SearchEntity); } catch (Exception ex) { Error = ex.Message; } }
private ALRD_GovernmentKhasLandDataEntity BuiltEntity(ALRD_GovernmentKhasLandDataEntity entity = null) { try { if (entity == null) { entity = new ALRD_GovernmentKhasLandDataEntity(); } entity.DivisionID = ddlDivision.SelectedIndex > 0 ? long.Parse(ddlDivision.SelectedValue) : (long?)null; entity.DistrictID = ddlDistrict.SelectedIndex > 0 ? long.Parse(ddlDistrict.SelectedValue) : (long?)null; entity.UpazilaID = ddlUpazilla.SelectedIndex > 0 ? long.Parse(ddlUpazilla.SelectedValue) : (long?)null; entity.CollCollectionYear = ddlYear.SelectedIndex > 0 ? long.Parse(ddlYear.SelectedValue) : (long?)null; entity.CollectionMonth = ddlMonth.SelectedIndex > 0 ? long.Parse(ddlMonth.SelectedValue) : (long?)null; } catch (Exception ex) { throw ex; } return(entity); }
protected void btnSave_Click(object sender, EventArgs e) { this.lblException.Text = ""; this.lblResult.Text = ""; try { if (btnSave.Text == "Save") { ALRD_GovernmentKhasLandDataEntity entity = BuiltEntity(); long i = ALRD_GovernmentKhasLandDataService.GetService().Add(entity); if (i > 0) { SuccessMessage = "Information Saved Successfully"; LoadEntity(new ALRD_GovernmentKhasLandDataEntity { COMPID = i }); } } else { ALRD_GovernmentKhasLandDataEntity entity = BuiltEntity(); long i = ALRD_GovernmentKhasLandDataService.GetService().Update(entity); if (i > 0) { SuccessMessage = "Information Updated Successfully"; LoadEntity(new ALRD_GovernmentKhasLandDataEntity { COMPID = entity.COMPID }); } } DateTime currentDate = DateTime.Now; ddlYear.SelectedValue = currentDate.Year.ToString(); ddlMonth.SelectedValue = currentDate.Month.ToString(); } catch (Exception ex) { Error = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { GlobalClass.GovtInfoID = -99; this.CheckFormPermission(this.FormID); this.CheckButtonPermission(null, null, null, lnkAddNew); LoadCombo(); SearchEntity = new ALRD_GovernmentKhasLandDataEntity(); SearchEntity.CurrentPage = 1; SearchEntity.PageSize = 10; LoadEntityList(SearchEntity); } } catch (Exception ex) { Error = ex.Message; } }
private void LoadEntity(ALRD_GovernmentKhasLandDataEntity entity) { try { ALRD_GovernmentKhasLandDataEntity objEntity = ALRD_GovernmentKhasLandDataService.GetService().GetAll(entity).FirstOrDefault(); ClearControlStates(pnlForm); if (objEntity != null && objEntity.COMPID != null && objEntity.COMPID > 0) { GlobalClass.FormUserID = (long)objEntity.COMPID; hdnCOMPID.Value = objEntity.COMPID.ToString(); if (objEntity.CollCollectionYear.HasValue) { ddlYear.SelectedValue = objEntity.CollCollectionYear.ToString(); } if (objEntity.CollectionMonth.HasValue) { ddlMonth.SelectedValue = objEntity.CollectionMonth.ToString(); } if (objEntity.DivisionID.HasValue) { ddlDivision.SelectedValue = objEntity.DivisionID.ToString(); } ddlDivision_SelectedIndexChanged(null, null); if (objEntity.DistrictID.HasValue && ddlDistrict.Items.FindByValue(objEntity.DistrictID.ToString()) != null) { ddlDistrict.SelectedValue = objEntity.DistrictID.ToString(); } ddlDistrict_SelectedIndexChanged(null, null); if (objEntity.UpazilaID.HasValue && ddlUpazilla.Items.FindByValue(objEntity.UpazilaID.ToString()) != null) { ddlUpazilla.SelectedValue = objEntity.UpazilaID.ToString(); } txtRemarks.Text = objEntity.Remarks; if (objEntity.TotalKhasLandAgri.HasValue) { txtTotalKhasLandAgri.Text = objEntity.TotalKhasLandAgri.ToString(); } if (objEntity.TotalKhasLandNonAgri.HasValue) { txtTotalKhasLandNonAgri.Text = objEntity.TotalKhasLandNonAgri.ToString(); } if (objEntity.DistributedKhasLandAgri.HasValue) { txtDistributedKhasLandAgri.Text = objEntity.DistributedKhasLandAgri.ToString(); } if (objEntity.DistributedKhasLandNonAgri.HasValue) { txtDistributedKhasLandNonAgri.Text = objEntity.DistributedKhasLandNonAgri.ToString(); } if (objEntity.DistributableKhasLandAgri.HasValue) { txtDistributableKhasLandAgri.Text = objEntity.DistributableKhasLandAgri.ToString(); } if (objEntity.DistributableKhasLandNonAgri.HasValue) { txtDistributableKhasLandNonAgri.Text = objEntity.DistributableKhasLandNonAgri.ToString(); } if (objEntity.NoOfFamilyGotKhasLandAgri.HasValue) { txtNoOfFamilyGotKhasLandAgri.Text = objEntity.NoOfFamilyGotKhasLandAgri.ToString(); } if (objEntity.NoOfFamilyGotKhasLandNonAgri.HasValue) { txtNoOfFamilyGotKhasLandNonAgri.Text = objEntity.NoOfFamilyGotKhasLandNonAgri.ToString(); } if (objEntity.IllegalOccupiedKhasLandAgri.HasValue) { txtIllegalOccupiedKhasLandAgri.Text = objEntity.IllegalOccupiedKhasLandAgri.ToString(); } if (objEntity.IllegalOccupiedKhasLandNonAgri.HasValue) { txtIllegalOccupiedKhasLandNonAgri.Text = objEntity.IllegalOccupiedKhasLandNonAgri.ToString(); } if (objEntity.KhasLandWithSuitCaseAgri.HasValue) { txtKhasLandWithSuitCaseAgri.Text = objEntity.KhasLandWithSuitCaseAgri.ToString(); } if (objEntity.KhasLandWithSuitCaseNonAgri.HasValue) { txtKhasLandWithSuitCaseNonAgri.Text = objEntity.KhasLandWithSuitCaseNonAgri.ToString(); } if (objEntity.CreatedBy.HasValue) { hdnCreatedBy.Value = objEntity.CreatedBy.ToString(); } hdnCreatedOn.Value = GetStringFromDate(objEntity.CreatedOn); btnSave.Text = "Update"; btnSave.OnClientClick = "javascript:return validateSubmit('Do you want to update this information?');"; this.CheckButtonPermission(null, btnSave, null); } else { GlobalClass.FormUserID = -99; btnSave.Text = "Save"; btnSave.OnClientClick = "javascript:return validateSubmit('Do you want to save this information?');"; this.CheckButtonPermission(btnSave, null, null); DateTime currentDate = DateTime.Now; ddlYear.SelectedValue = currentDate.Year.ToString(); ddlMonth.SelectedValue = currentDate.Month.ToString(); } } catch (Exception ex) { Error = ex.Message; } }
public static void FillParameters(ALRD_GovernmentKhasLandDataEntity entity, DbCommand cmd, Database Database, bool forDelete = false) { if (entity.COMPID.HasValue) { Database.AddInParameter(cmd, "@COMPID", DbType.Int64, entity.COMPID); } if (forDelete) { return; } if (!(string.IsNullOrEmpty(entity.Remarks))) { Database.AddInParameter(cmd, "@Remarks", DbType.String, entity.Remarks); } if (entity.CollectionMonth.HasValue) { Database.AddInParameter(cmd, "@CollectionMonth", DbType.Int64, entity.CollectionMonth); } if (entity.CollCollectionYear.HasValue) { Database.AddInParameter(cmd, "@CollCollectionYear", DbType.Int64, entity.CollCollectionYear); } if (entity.DivisionID.HasValue) { Database.AddInParameter(cmd, "@DivisionID", DbType.Int64, entity.DivisionID); } if (entity.DistrictID.HasValue) { Database.AddInParameter(cmd, "@DistrictID", DbType.Int64, entity.DistrictID); } if (entity.UpazilaID.HasValue) { Database.AddInParameter(cmd, "@UpazilaID", DbType.Int64, entity.UpazilaID); } if (entity.TotalKhasLandAgri.HasValue) { Database.AddInParameter(cmd, "@TotalKhasLandAgri", DbType.Decimal, entity.TotalKhasLandAgri); } if (entity.TotalKhasLandNonAgri.HasValue) { Database.AddInParameter(cmd, "@TotalKhasLandNonAgri", DbType.Decimal, entity.TotalKhasLandNonAgri); } if (entity.DistributedKhasLandAgri.HasValue) { Database.AddInParameter(cmd, "@DistributedKhasLandAgri", DbType.Decimal, entity.DistributedKhasLandAgri); } if (entity.DistributedKhasLandNonAgri.HasValue) { Database.AddInParameter(cmd, "@DistributedKhasLandNonAgri", DbType.Decimal, entity.DistributedKhasLandNonAgri); } if (entity.DistributableKhasLandAgri.HasValue) { Database.AddInParameter(cmd, "@DistributableKhasLandAgri", DbType.Decimal, entity.DistributableKhasLandAgri); } if (entity.DistributableKhasLandNonAgri.HasValue) { Database.AddInParameter(cmd, "@DistributableKhasLandNonAgri", DbType.Decimal, entity.DistributableKhasLandNonAgri); } if (entity.NoOfFamilyGotKhasLandAgri.HasValue) { Database.AddInParameter(cmd, "@NoOfFamilyGotKhasLandAgri", DbType.Decimal, entity.NoOfFamilyGotKhasLandAgri); } if (entity.NoOfFamilyGotKhasLandNonAgri.HasValue) { Database.AddInParameter(cmd, "@NoOfFamilyGotKhasLandNonAgri", DbType.Decimal, entity.NoOfFamilyGotKhasLandNonAgri); } if (entity.IllegalOccupiedKhasLandAgri.HasValue) { Database.AddInParameter(cmd, "@IllegalOccupiedKhasLandAgri", DbType.Decimal, entity.IllegalOccupiedKhasLandAgri); } if (entity.IllegalOccupiedKhasLandNonAgri.HasValue) { Database.AddInParameter(cmd, "@IllegalOccupiedKhasLandNonAgri", DbType.Decimal, entity.IllegalOccupiedKhasLandNonAgri); } if (entity.KhasLandWithSuitCaseAgri.HasValue) { Database.AddInParameter(cmd, "@KhasLandWithSuitCaseAgri", DbType.Decimal, entity.KhasLandWithSuitCaseAgri); } if (entity.KhasLandWithSuitCaseNonAgri.HasValue) { Database.AddInParameter(cmd, "@KhasLandWithSuitCaseNonAgri", DbType.Decimal, entity.KhasLandWithSuitCaseNonAgri); } if (entity.CreatedBy.HasValue) { Database.AddInParameter(cmd, "@CreatedBy", DbType.Int64, entity.CreatedBy); } if (entity.CreatedOn.HasValue) { Database.AddInParameter(cmd, "@CreatedOn", DbType.DateTime, entity.CreatedOn); } if (entity.UpdatedBy.HasValue) { Database.AddInParameter(cmd, "@UpdatedBy", DbType.Int64, entity.UpdatedBy); } if (entity.UpdatedOn.HasValue) { Database.AddInParameter(cmd, "@UpdatedOn", DbType.DateTime, entity.UpdatedOn); } }
IList <ALRD_GovernmentKhasLandDataEntity> IALRD_GovernmentKhasLandDataDao.GetAll(ALRD_GovernmentKhasLandDataEntity entity) { try { const string SP = "alrd_governmentkhaslanddata_GetAll"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddSortExpressionParameter(cmd, entity.SortExpression); FillParameters(entity, cmd, Database); IList <ALRD_GovernmentKhasLandDataEntity> itemList = new List <ALRD_GovernmentKhasLandDataEntity>(); using (IDataReader reader = Database.ExecuteReader(cmd)) { while (reader.Read()) { itemList.Add(new ALRD_GovernmentKhasLandDataEntity(reader)); } } return(itemList); } } catch (Exception ex) { throw GetDataAccessException(ex, SourceOfException("GetAll")); } }