private void SetInitialRowExpenseDtls()
{
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add("#", typeof(Int32));
dt.Columns.Add("ExpenseHdId", typeof(Int32));
dt.Columns.Add("Expense", typeof(string));
dt.Columns.Add("Amount", typeof(decimal));
dr = dt.NewRow();
dr["#"] = 0;
dr["ExpenseHdId"] = 0;
dr["Expense"] = "";
dr["Amount"] = 0;
dt.Rows.Add(dr);
ViewState["CurrentProexp"] = dt;
GrdProExpDtls.DataSource = dt;
GrdProExpDtls.DataBind();
}
protected void GrdProExpDtls_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
if (ViewState["CurrentProexp"] != null)
{
int id = e.RowIndex;
DataTable dt = (DataTable)ViewState["CurrentProexp"];
dt.Rows.RemoveAt(id);
if (dt.Rows.Count > 0)
{
GrdProExpDtls.DataSource = dt;
ViewState["CurrentProexp"] = dt;
GrdProExpDtls.DataBind();
}
else
{
SetInitialRowExpenseDtls();
}
MakeControlEmpty();
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
protected void ImgProExpDtlsAdd_Click(object sender, ImageClickEventArgs e)
{
try
{
if (ViewState["CurrentProexp"] != null)
{
DataTable dtCurrentTable = (DataTable)ViewState["CurrentProexp"];
DataRow dtTableRow = null;
int k = 0;
if (dtCurrentTable.Rows.Count > 0)
{
if (dtCurrentTable.Rows.Count == 1 && string.IsNullOrEmpty(dtCurrentTable.Rows[0]["Expense"].ToString()))
{
dtCurrentTable.Rows.RemoveAt(0);
}
if (ViewState["GridIndexNew"] != null)
{
k = Convert.ToInt32(ViewState["GridIndexNew"]);
dtCurrentTable.Rows[k]["#"] = Convert.ToInt32(ddlExpenseHead.SelectedValue);
dtCurrentTable.Rows[k]["Expense"] = ddlExpenseHead.SelectedItem;
dtCurrentTable.Rows[k]["ExpenseHdId"] = Convert.ToInt32(ddlExpenseHead.SelectedValue);
dtCurrentTable.Rows[k]["Amount"] = (!string.IsNullOrEmpty(txtExpAmount.Text)) ? Convert.ToDecimal(txtExpAmount.Text) : 0;
ViewState["CurrentProexp"] = dtCurrentTable;
GrdProExpDtls.DataSource = dtCurrentTable;
GrdProExpDtls.DataBind();
MakeControlEmpty();
}
else
{
dtTableRow = dtCurrentTable.NewRow();
int rowindex = Convert.ToInt32(ViewState["GridIndexNew"]);
dtTableRow["Expense"] = ddlExpenseHead.SelectedItem;
dtTableRow["ExpenseHdId"] = Convert.ToInt32(ddlExpenseHead.SelectedValue);
dtTableRow["#"] = Convert.ToInt32(ddlExpenseHead.SelectedValue);
dtTableRow["Amount"] = (!string.IsNullOrEmpty(txtExpAmount.Text)) ? Convert.ToDecimal(txtExpAmount.Text) : 0;
dtCurrentTable.Rows.Add(dtTableRow);
ViewState["CurrentProexp"] = dtCurrentTable;
GrdProExpDtls.DataSource = dtCurrentTable;
GrdProExpDtls.DataBind();
MakeControlEmpty();
}
}
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
protected void GrdReport_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
switch (e.CommandName)
{
case ("Select"):
{
if (Convert.ToInt32(e.CommandArgument) != 0)
{
ViewState["EditID"] = Convert.ToInt32(e.CommandArgument);
Ds = obj_Property.GetRocordtoEdit(Convert.ToInt32(e.CommandArgument), out StrError);
if (Ds.Tables.Count > 0 && Ds.Tables[0].Rows.Count > 0)
{
txtProperty.Text = Ds.Tables[0].Rows[0]["Property"].ToString();
txtPropertyAddress.Text = Ds.Tables[0].Rows[0]["PropertyAddress"].ToString();
ddlCompany.SelectedValue = Ds.Tables[0].Rows[0]["CompanyId"].ToString();
ddlProprtyType.SelectedValue = Ds.Tables[0].Rows[0]["PropertyTypeId"].ToString();
ddlProprtyType_SelectedIndexChanged(Convert.ToInt32(ddlProprtyType.SelectedValue), EventArgs.Empty);
ddlPropertySubType.SelectedValue = Ds.Tables[0].Rows[0]["PropertySubTypeId"].ToString();
ddlCity.SelectedValue = Ds.Tables[0].Rows[0]["CityId"].ToString();
ddlCity_SelectedIndexChanged(Convert.ToInt32(ddlCity.SelectedValue), EventArgs.Empty);
ddlLocation.SelectedValue = Ds.Tables[0].Rows[0]["LocationId"].ToString();
if (Ds.Tables.Count > 0 && Ds.Tables[1].Rows.Count > 0)
{
GridDetails.DataSource = Ds.Tables[1];
GridDetails.DataBind();
ViewState["CurrentTable"] = Ds.Tables[1];
}
else
{
SetInitialRow();
}
if (Ds.Tables.Count > 0 && Ds.Tables[2].Rows.Count > 0)
{
GrdProExpDtls.DataSource = Ds.Tables[2];
GrdProExpDtls.DataBind();
ViewState["CurrentProexp"] = Ds.Tables[2];
}
else
{
SetInitialRowExpenseDtls();
}
}
else
{
MakeEmptyForm();
}
BtnUpdate.Visible = true;
BtnSave.Visible = false;
BtnDelete.Visible = true;
}
break;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataSet DST = new DataSet();
if (!string.IsNullOrEmpty(Request.QueryString["PropertyId"]))
{
FillCombo();
int ProMaintId = Convert.ToInt32(Request.QueryString["PropertyId"]);
{
DST = obj_Property.GetRocordtoEdit(ProMaintId, out StrError);
if (DST.Tables.Count > 0 && DST.Tables[0].Rows.Count > 0)
{
txtProperty.Text = DST.Tables[0].Rows[0]["Property"].ToString();
txtPropertyAddress.Text = DST.Tables[0].Rows[0]["PropertyAddress"].ToString();
ddlCompany.SelectedValue = DST.Tables[0].Rows[0]["CompanyId"].ToString();
ddlProprtyType.SelectedValue = DST.Tables[0].Rows[0]["PropertyTypeId"].ToString();
ddlProprtyType_SelectedIndexChanged(Convert.ToInt32(ddlProprtyType.SelectedValue), EventArgs.Empty);
ddlPropertySubType.SelectedValue = DST.Tables[0].Rows[0]["PropertySubTypeId"].ToString();
ddlCity.SelectedValue = DST.Tables[0].Rows[0]["CityId"].ToString();
ddlCity_SelectedIndexChanged(Convert.ToInt32(ddlCity.SelectedValue), EventArgs.Empty);
ddlLocation.SelectedValue = DST.Tables[0].Rows[0]["LocationId"].ToString();
if (DST.Tables.Count > 0 && DST.Tables[1].Rows.Count > 0)
{
GridDetails.DataSource = DST.Tables[1];
GridDetails.DataBind();
ViewState["CurrentTable"] = DST.Tables[1];
}
else
{
SetInitialRow();
}
if (DST.Tables.Count > 0 && DST.Tables[2].Rows.Count > 0)
{
GrdProExpDtls.DataSource = DST.Tables[2];
GrdProExpDtls.DataBind();
ViewState["CurrentProexp"] = DST.Tables[2];
}
else
{
SetInitialRowExpenseDtls();
}
if (!FlagEdit)
{
BtnUpdate.Visible = true;
}
BtnSave.Visible = false;
}
else
{
// Make
}
}
}
else
{
FillCombo();
MakeEmptyForm();
}
//
//MakeEmptyForm();
}
}
