protected void btnCancel_Click(object sender, EventArgs e)
{
CurrentACBankAccountDepositItemEntity = new ACBankAccountDepositItem_DetailedEntity();
txtItemName.Text = String.Empty;
hdEmpID.Value = "0";
txtMemoDetail.Text = String.Empty;
txtAmount.Text = String.Empty;
pnlUpdate.Visible = false;
pnlAdd.Visible = true;
}
protected void lvACBankAccountDepositItem_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
ACBankAccountDepositItem_DetailedEntity ent = (ACBankAccountDepositItem_DetailedEntity)dataItem.DataItem;
HyperLink hypRequisitionLV = (HyperLink)e.Item.FindControl("hypRequisitionLV");
HyperLink hypWorkOrderLV = (HyperLink)e.Item.FindControl("hypWorkOrderLV");
hypRequisitionLV.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.REQUISITION_REPORT, UrlConstants.REQUISITION_ID, ent.RequisitionID.ToString()).ToString();
hypRequisitionLV.Target = "_blank";
hypWorkOrderLV.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.WORK_ORDER_REPORT, UrlConstants.OVERVIEW_WORKORDER_ID, ent.WorkOrderID.ToString()).ToString();
hypWorkOrderLV.Target = "_blank";
}
}
protected void lvACBankAccountDepositItem_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 BankAccountDepositItemID;
Int64.TryParse(e.CommandArgument.ToString(), out BankAccountDepositItemID);
if (BankAccountDepositItemID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_BankAccountDepositItemID = BankAccountDepositItemID;
PrepareEditViewDepositeItem();
pnlAdd.Visible = false;
pnlUpdate.Visible = true;
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
ACBankAccountDepositItem_DetailedEntity depositeItemEntity = (from s in CurrentACBankAccountDepositItemList
where s.BankAccountDepositItemID == BankAccountDepositItemID
select s).FirstOrDefault();
CurrentACBankAccountDepositItemList.Remove(depositeItemEntity);
BindACBankAccountDepositItemList();
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (ValidateInputAccounts())
{
// Implement Update Code Here.
ACBankAccountDepositItem_DetailedEntity cust = (from c in CurrentACBankAccountDepositItemList
where c.BankAccountDepositItemID == CurrentACBankAccountDepositItemEntity.BankAccountDepositItemID
select c).SingleOrDefault();
CurrentACBankAccountDepositItemList.Remove(cust);
ACBankAccountDepositItem_DetailedEntity aCBankAccountDepositItemEntity = cust;
if (hdEmpID.Value != "0")
{
aCBankAccountDepositItemEntity.AccountID = Int64.Parse(hdEmpID.Value);
aCBankAccountDepositItemEntity.AccountName = txtItemName.Text.ToString().Trim();
}
if (ddlItemID.Items.Count > 0)
{
if (ddlItemID.SelectedValue == "0")
{
aCBankAccountDepositItemEntity.ItemID = null;
aCBankAccountDepositItemEntity.ItemName = String.Empty;
}
else
{
aCBankAccountDepositItemEntity.ItemID = Int64.Parse(ddlItemID.SelectedValue);
aCBankAccountDepositItemEntity.ItemName = ddlItemID.SelectedItem.ToString();
}
}
if (ddlRequisitionID.Items.Count > 0)
{
if (ddlRequisitionID.SelectedValue == "0")
{
aCBankAccountDepositItemEntity.RequisitionID = null;
aCBankAccountDepositItemEntity.RequisitionNo = String.Empty;
}
else
{
aCBankAccountDepositItemEntity.RequisitionID = Int64.Parse(ddlRequisitionID.SelectedValue);
aCBankAccountDepositItemEntity.RequisitionNo = ddlRequisitionID.SelectedItem.ToString();
}
}
if (ddlWorkOrderID.Items.Count > 0)
{
if (ddlWorkOrderID.SelectedValue == "0")
{
aCBankAccountDepositItemEntity.WorkOrderID = null;
aCBankAccountDepositItemEntity.WorkOrderNo = String.Empty;
}
else
{
aCBankAccountDepositItemEntity.WorkOrderID = Int64.Parse(ddlWorkOrderID.SelectedValue);
aCBankAccountDepositItemEntity.WorkOrderNo = ddlWorkOrderID.SelectedItem.ToString();
}
}
if (ddlBillID.Items.Count > 0)
{
if (ddlBillID.SelectedValue == "0")
{
aCBankAccountDepositItemEntity.BillID = null;
aCBankAccountDepositItemEntity.BillNo = String.Empty;
}
else
{
aCBankAccountDepositItemEntity.BillID = Int64.Parse(ddlBillID.SelectedValue);
aCBankAccountDepositItemEntity.BillNo = ddlBillID.SelectedItem.ToString();
}
}
if (ddlProjectID.Items.Count > 0)
{
if (ddlProjectID.SelectedValue == "0")
{
aCBankAccountDepositItemEntity.ProjectID = null;
aCBankAccountDepositItemEntity.ProjectName = String.Empty;
}
else
{
aCBankAccountDepositItemEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue);
aCBankAccountDepositItemEntity.ProjectName = ddlProjectID.SelectedItem.ToString();
}
}
if (ddlProjectFloorID.Items.Count > 0)
{
if (ddlProjectFloorID.SelectedValue == "0")
{
aCBankAccountDepositItemEntity.ProjectFloorID = null;
aCBankAccountDepositItemEntity.ProjectFloorName = String.Empty;
}
else
{
aCBankAccountDepositItemEntity.ProjectFloorID = Int64.Parse(ddlProjectFloorID.SelectedValue);
aCBankAccountDepositItemEntity.ProjectFloorName = ddlProjectFloorID.SelectedItem.ToString();
}
}
if (ddlProjectFloorUnitID.Items.Count > 0)
{
if (ddlProjectFloorUnitID.SelectedValue == "0")
{
aCBankAccountDepositItemEntity.ProjectFloorUnitID = null;
aCBankAccountDepositItemEntity.ProjectFloorUnitName = String.Empty;
}
else
{
aCBankAccountDepositItemEntity.ProjectFloorUnitID = Int64.Parse(ddlProjectFloorUnitID.SelectedValue);
aCBankAccountDepositItemEntity.ProjectFloorUnitName = ddlProjectFloorUnitID.SelectedItem.ToString();
}
}
if (!txtAmount.Text.Trim().IsNullOrEmpty())
{
aCBankAccountDepositItemEntity.Amount = Decimal.Parse(txtAmount.Text.Trim());
}
aCBankAccountDepositItemEntity.Memo = txtMemoDetail.Text.Trim();
CurrentACBankAccountDepositItemList.Add(aCBankAccountDepositItemEntity);
BindACBankAccountDepositItemList();
pnlAdd.Visible = true;
pnlUpdate.Visible = false;
ClearAll();
BuildTotalValueLabel();
}
}
private void SaveACBankAccountDepositEntity()
{
if (IsValid)
{
try
{
ACBankAccountDepositEntity aCBankAccountDepositEntity = BuildACBankAccountDepositEntity();
Int64 result = -1;
if (aCBankAccountDepositEntity.IsNew)
{
result = FCCACBankAccountDeposit.GetFacadeCreate().Add(aCBankAccountDepositEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(ACBankAccountDepositEntity.FLD_NAME_BankAccountDepositID, aCBankAccountDepositEntity.BankAccountDepositID.ToString(), SQLMatchType.Equal);
result = FCCACBankAccountDeposit.GetFacadeCreate().Update(aCBankAccountDepositEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
Int64 resut_two = -1;
if (!aCBankAccountDepositEntity.IsNew)
{
CurrentACBankAccountDepositItemList = new List <ACBankAccountDepositItem_DetailedEntity>();
ACBankAccountDepositItem_DetailedEntity aCBankAccountDepositItemEntity = new ACBankAccountDepositItem_DetailedEntity();
IList <ListViewDataItem> listBankDeposit = lvACBankAccountDepositItem.Items;
if (listBankDeposit != null && listBankDeposit.Count > 0)
{
String fe_del = SqlExpressionBuilder.PrepareFilterExpression(ACBankAccountDepositItemEntity.FLD_NAME_BankAccountDepositID, result.ToString(), SQLMatchType.Equal);
ACBankAccountDepositItemEntity acDopsitItem = new ACBankAccountDepositItemEntity();
FCCACBankAccountDepositItem.GetFacadeCreate().Delete(acDopsitItem, fe_del, DatabaseOperationType.Delete, TransactionRequired.No);
foreach (ListViewDataItem lvdi in listBankDeposit)
{
aCBankAccountDepositItemEntity = new ACBankAccountDepositItem_DetailedEntity();
Label lblAccountIDLV = (Label)lvdi.FindControl("lblAccountIDLV");
Label lblAccountNameLV = (Label)lvdi.FindControl("lblAccountNameLV");
Label lblAmountLV = (Label)lvdi.FindControl("lblAmountLV");
Label lblMemoLV = (Label)lvdi.FindControl("lblMemoLV");
aCBankAccountDepositItemEntity.BankAccountDepositItemID = CurrentACBankAccountDepositItemList.Count + 1;
if (lblAccountIDLV.Text.Trim().IsNotNullOrEmpty())
{
aCBankAccountDepositItemEntity.AccountID = Int64.Parse(lblAccountIDLV.Text.Trim());
aCBankAccountDepositItemEntity.AccountName = lblAccountNameLV.Text.ToString().Trim();
}
if (!lblAmountLV.Text.Trim().IsNullOrEmpty())
{
aCBankAccountDepositItemEntity.Amount = Decimal.Parse(lblAmountLV.Text.Trim());
}
aCBankAccountDepositItemEntity.Memo = lblMemoLV.Text.Trim();
#region Update Value
ACBankAccountDepositItemEntity acBankAccountDepositItemEntity = new ACBankAccountDepositItemEntity();
acBankAccountDepositItemEntity.AccountID = aCBankAccountDepositItemEntity.AccountID;
acBankAccountDepositItemEntity.DimensionID = aCBankAccountDepositItemEntity.DimensionID;
acBankAccountDepositItemEntity.Amount = aCBankAccountDepositItemEntity.Amount;
acBankAccountDepositItemEntity.Memo = aCBankAccountDepositItemEntity.Memo;
acBankAccountDepositItemEntity.ItemID = aCBankAccountDepositItemEntity.ItemID;
acBankAccountDepositItemEntity.RequisitionID = aCBankAccountDepositItemEntity.RequisitionID;
acBankAccountDepositItemEntity.WorkOrderID = aCBankAccountDepositItemEntity.WorkOrderID;
acBankAccountDepositItemEntity.BillID = aCBankAccountDepositItemEntity.BillID;
acBankAccountDepositItemEntity.ProjectID = aCBankAccountDepositItemEntity.ProjectID;
acBankAccountDepositItemEntity.ProjectFloorID = aCBankAccountDepositItemEntity.ProjectFloorID;
acBankAccountDepositItemEntity.ProjectFloorUnitID = aCBankAccountDepositItemEntity.ProjectFloorUnitID;
acBankAccountDepositItemEntity.BankAccountDepositID = result;
resut_two = FCCACBankAccountDepositItem.GetFacadeCreate().Add(acBankAccountDepositItemEntity, DatabaseOperationType.Add, TransactionRequired.No);
#endregion
CurrentACBankAccountDepositItemList.Add(aCBankAccountDepositItemEntity);
}
BindACBankAccountDepositItemList();
BuildTotalValueLabel();
}
}
if (aCBankAccountDepositEntity.IsNew)
{
if (CurrentACBankAccountDepositItemList != null && CurrentACBankAccountDepositItemList.Count > 0)
{
foreach (ACBankAccountDepositItem_DetailedEntity ent in CurrentACBankAccountDepositItemList)
{
ACBankAccountDepositItemEntity acBankAccountDepositItemEntity = new ACBankAccountDepositItemEntity();
acBankAccountDepositItemEntity.AccountID = ent.AccountID;
acBankAccountDepositItemEntity.DimensionID = ent.DimensionID;
acBankAccountDepositItemEntity.Amount = ent.Amount;
acBankAccountDepositItemEntity.Memo = ent.Memo;
acBankAccountDepositItemEntity.ItemID = ent.ItemID;
acBankAccountDepositItemEntity.RequisitionID = ent.RequisitionID;
acBankAccountDepositItemEntity.WorkOrderID = ent.WorkOrderID;
acBankAccountDepositItemEntity.BillID = ent.BillID;
acBankAccountDepositItemEntity.ProjectID = ent.ProjectID;
acBankAccountDepositItemEntity.ProjectFloorID = ent.ProjectFloorID;
acBankAccountDepositItemEntity.ProjectFloorUnitID = ent.ProjectFloorUnitID;
acBankAccountDepositItemEntity.BankAccountDepositID = result;
resut_two = FCCACBankAccountDepositItem.GetFacadeCreate().Add(acBankAccountDepositItemEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
}
}
hypReportLink.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.BANK_ACCOUNT_DEPOSIT_REPORT, UrlConstants.OVERVIEW_BANK_ACCOUNT_DEPOSIT_ID, result.ToString()).ToString();
hypReportLink.Target = "_blank";
hypReportLink.Visible = true;
String str = (String)ViewState["Action"].ToString();
if (str == "GenerateReport")
{
_BankAccountDepositID = result;
_bankAccountDepositID = result;
PrepareEditView();
}
else if (str == "Approval")
{
_BankAccountDepositID = 0;
_bankAccountDepositID = result;
_ACBankAccountDepositEntity = new ACBankAccountDepositEntity();
PrepareInitialView();
PrepareInitialViewDepositeItem();
CurrentACBankAccountDepositItemList = new List <ACBankAccountDepositItem_DetailedEntity>();
BindACBankAccountDepositItemList();
BuildTotalValueLabel();
}
if (aCBankAccountDepositEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Bank Account Deposit Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Bank Account Deposit Information has been updated successfully.", false);
}
}
else
{
if (aCBankAccountDepositEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Bank Account Deposit Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Bank Account Deposit Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
private void PrepareEditViewDepositeItem()
{
ACBankAccountDepositItem_DetailedEntity aCBankAccountDepositItemEntity = CurrentACBankAccountDepositItemEntity;
if (!aCBankAccountDepositItemEntity.IsNew)
{
if (aCBankAccountDepositItemEntity.AccountID > 0)
{
txtItemName.Text = aCBankAccountDepositItemEntity.AccountName.ToString();
hdEmpID.Value = aCBankAccountDepositItemEntity.AccountID.ToString();
}
if (ddlItemID.Items.Count > 0 && aCBankAccountDepositItemEntity.ItemID != null)
{
ddlItemID.SelectedValue = aCBankAccountDepositItemEntity.ItemID.ToString();
}
else if (aCBankAccountDepositItemEntity.ItemID == null)
{
ddlItemID.SelectedValue = "0";
}
if (ddlProjectID.Items.Count > 0 && aCBankAccountDepositItemEntity.ProjectID != null)
{
ddlProjectID.SelectedValue = aCBankAccountDepositItemEntity.ProjectID.ToString();
}
else if (aCBankAccountDepositItemEntity.ProjectID == null)
{
ddlProjectID.SelectedValue = "0";
}
BuildProjectWiseDropdownInfo();
if (ddlRequisitionID.Items.Count > 0 && aCBankAccountDepositItemEntity.RequisitionID != null)
{
ddlRequisitionID.SelectedValue = aCBankAccountDepositItemEntity.RequisitionID.ToString();
}
else if (aCBankAccountDepositItemEntity.RequisitionID == null)
{
ddlRequisitionID.SelectedValue = "0";
}
BuildRequisitionWiseInfo();
if (ddlWorkOrderID.Items.Count > 0 && aCBankAccountDepositItemEntity.WorkOrderID != null)
{
ddlWorkOrderID.SelectedValue = aCBankAccountDepositItemEntity.WorkOrderID.ToString();
}
else if (aCBankAccountDepositItemEntity.WorkOrderID == null)
{
ddlWorkOrderID.SelectedValue = "0";
}
BuildWorkorderWiseInfo();
if (ddlBillID.Items.Count > 0 && aCBankAccountDepositItemEntity.BillID != null)
{
ddlBillID.SelectedValue = aCBankAccountDepositItemEntity.BillID.ToString();
}
else if (aCBankAccountDepositItemEntity.BillID == null)
{
ddlBillID.SelectedValue = "0";
}
if (ddlProjectFloorID.Items.Count > 0 && aCBankAccountDepositItemEntity.ProjectFloorID != null)
{
ddlProjectFloorID.SelectedValue = aCBankAccountDepositItemEntity.ProjectFloorID.ToString();
}
else if (aCBankAccountDepositItemEntity.ProjectFloorID == null)
{
ddlProjectFloorID.SelectedValue = "0";
}
BuildFloorWiseInfo();
if (ddlProjectFloorUnitID.Items.Count > 0 && aCBankAccountDepositItemEntity.ProjectFloorUnitID != null)
{
ddlProjectFloorUnitID.SelectedValue = aCBankAccountDepositItemEntity.ProjectFloorUnitID.ToString();
}
else if (aCBankAccountDepositItemEntity.ProjectFloorUnitID == null)
{
ddlProjectFloorUnitID.SelectedValue = "0";
}
txtAmount.Text = aCBankAccountDepositItemEntity.Amount.ToString();
txtMemoDetail.Text = aCBankAccountDepositItemEntity.Memo.ToString();
}
}
protected void btnAddItem_Click(object sender, EventArgs e)
{
if (ValidateInputAccounts())
{
ACBankAccountDepositItem_DetailedEntity aCBankAccountDepositItemEntity = new ACBankAccountDepositItem_DetailedEntity();
aCBankAccountDepositItemEntity.BankAccountDepositItemID = CurrentACBankAccountDepositItemList.Count + 1;
if (hdEmpID.Value != "0")
{
aCBankAccountDepositItemEntity.AccountID = Int64.Parse(hdEmpID.Value);
aCBankAccountDepositItemEntity.AccountName = txtItemName.Text.ToString().Trim();
}
if (ddlItemID.Items.Count > 0)
{
if (ddlItemID.SelectedValue == "0")
{
aCBankAccountDepositItemEntity.ItemID = null;
}
else
{
aCBankAccountDepositItemEntity.ItemID = Int64.Parse(ddlItemID.SelectedValue);
aCBankAccountDepositItemEntity.ItemName = ddlItemID.SelectedItem.ToString();
}
}
if (ddlRequisitionID.Items.Count > 0)
{
if (ddlRequisitionID.SelectedValue == "0")
{
aCBankAccountDepositItemEntity.RequisitionID = null;
}
else
{
aCBankAccountDepositItemEntity.RequisitionID = Int64.Parse(ddlRequisitionID.SelectedValue);
aCBankAccountDepositItemEntity.RequisitionNo = ddlRequisitionID.SelectedItem.ToString();
}
}
if (ddlWorkOrderID.Items.Count > 0)
{
if (ddlWorkOrderID.SelectedValue == "0")
{
aCBankAccountDepositItemEntity.WorkOrderID = null;
}
else
{
aCBankAccountDepositItemEntity.WorkOrderID = Int64.Parse(ddlWorkOrderID.SelectedValue);
aCBankAccountDepositItemEntity.WorkOrderNo = ddlWorkOrderID.SelectedItem.ToString();
}
}
if (ddlBillID.Items.Count > 0)
{
if (ddlBillID.SelectedValue == "0")
{
aCBankAccountDepositItemEntity.BillID = null;
}
else
{
aCBankAccountDepositItemEntity.BillID = Int64.Parse(ddlBillID.SelectedValue);
aCBankAccountDepositItemEntity.BillNo = ddlBillID.SelectedItem.ToString();
}
}
if (ddlProjectID.Items.Count > 0)
{
if (ddlProjectID.SelectedValue == "0")
{
aCBankAccountDepositItemEntity.ProjectID = null;
}
else
{
aCBankAccountDepositItemEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue);
aCBankAccountDepositItemEntity.ProjectName = ddlProjectID.SelectedItem.ToString();
}
}
if (ddlProjectFloorID.Items.Count > 0)
{
if (ddlProjectFloorID.SelectedValue == "0")
{
aCBankAccountDepositItemEntity.ProjectFloorID = null;
}
else
{
aCBankAccountDepositItemEntity.ProjectFloorID = Int64.Parse(ddlProjectFloorID.SelectedValue);
aCBankAccountDepositItemEntity.ProjectFloorName = ddlProjectFloorID.SelectedItem.ToString();
}
}
if (ddlProjectFloorUnitID.Items.Count > 0)
{
if (ddlProjectFloorUnitID.SelectedValue == "0")
{
aCBankAccountDepositItemEntity.ProjectFloorUnitID = null;
}
else
{
aCBankAccountDepositItemEntity.ProjectFloorUnitID = Int64.Parse(ddlProjectFloorUnitID.SelectedValue);
aCBankAccountDepositItemEntity.ProjectFloorUnitName = ddlProjectFloorUnitID.SelectedItem.ToString();
}
}
if (!txtAmount.Text.Trim().IsNullOrEmpty())
{
aCBankAccountDepositItemEntity.Amount = Decimal.Parse(txtAmount.Text.Trim());
}
aCBankAccountDepositItemEntity.Memo = txtMemoDetail.Text.Trim();
CurrentACBankAccountDepositItemList.Add(aCBankAccountDepositItemEntity);
BindACBankAccountDepositItemList();
ClearAll();
BuildTotalValueLabel();
}
}
