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"));
}
}
