protected void lvACCPrePayableStatement_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
ACCPrePayableStatementEntity ent = (ACCPrePayableStatementEntity)dataItem.DataItem;
LinkButton lnkBtnEdit = (LinkButton)e.Item.FindControl("lnkBtnEdit");
LinkButton lnkBtnDelete = (LinkButton)e.Item.FindControl("lnkBtnDelete");
if (ent.PrePayableStatementID == MasterDataConstants.ACCPayableDefault.ACC_PRE_PAYABLE_STATEMENT_DEFAULT)
{
lnkBtnEdit.Visible = false;
lnkBtnDelete.Visible = false;
}
HyperLink hypPayableRef = (HyperLink)e.Item.FindControl("hypPayableRef");
HyperLink hypReport = (HyperLink)e.Item.FindControl("hypReport");
hypReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.PRE_PAYABLE_REPORT, UrlConstants.OVERVIEW_PRE_PAYABLE_STATEMENT_ID, ent.PrePayableStatementID.ToString()).ToString();
hypPayableRef.NavigateUrl = UrlHelper.BuildSecureUrl("~/ACC/ACCPrePayableStatementDetail.aspx", string.Empty, UrlConstants.OVERVIEW_PRE_PAYABLE_STATEMENT_ID, ent.PrePayableStatementID.ToString()).ToString();
hypReport.Target = "_blank";
}
}
Int64 IACCPrePayableStatementDataAccess.Add(ACCPrePayableStatementEntity aCCPrePayableStatementEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
try
{
long retValues = -99;
switch (reqTran)
{
case TransactionRequired.No:
{
retValues = Add(aCCPrePayableStatementEntity, option);
break;
}
case TransactionRequired.Yes:
{
retValues = AddTran(aCCPrePayableStatementEntity, option);
break;
}
default:
{
retValues = -99;
break;
}
}
return(retValues);
}
catch (Exception ex)
{
throw ex;
}
}
private ACCPrePayableStatementEntity BuildACCPrePayableStatementEntity()
{
ACCPrePayableStatementEntity aCCPrePayableStatementEntity = CurrentACCPrePayableStatementEntity;
aCCPrePayableStatementEntity.Ref = txtRef.Text.Trim();
if (txtCreateDate.Text.Trim().IsNotNullOrEmpty())
{
aCCPrePayableStatementEntity.CreateDate = MiscUtil.ParseToDateTime(txtCreateDate.Text);
}
if (txtStartDate.Text.Trim().IsNotNullOrEmpty())
{
aCCPrePayableStatementEntity.StartDate = MiscUtil.ParseToDateTime(txtStartDate.Text);
}
if (txtEndDate.Text.Trim().IsNotNullOrEmpty())
{
aCCPrePayableStatementEntity.EndDate = MiscUtil.ParseToDateTime(txtEndDate.Text);
}
aCCPrePayableStatementEntity.IsRemoved = chkIsRemoved.Checked;
return(aCCPrePayableStatementEntity);
}
private Int64 UpdateTran(ACCPrePayableStatementEntity aCCPrePayableStatementEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.ACCPrePayableStatement_SET";
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand cmd = db.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option, db);
AddOutputParameter(cmd, db);
AddFilterExpressionParameter(cmd, filterExpression, db);
db.AddInParameter(cmd, "@PrePayableStatementID", DbType.Int64, aCCPrePayableStatementEntity.PrePayableStatementID);
db.AddInParameter(cmd, "@Ref", DbType.String, aCCPrePayableStatementEntity.Ref);
db.AddInParameter(cmd, "@CreateDate", DbType.DateTime, aCCPrePayableStatementEntity.CreateDate);
db.AddInParameter(cmd, "@StartDate", DbType.DateTime, aCCPrePayableStatementEntity.StartDate);
db.AddInParameter(cmd, "@EndDate", DbType.DateTime, aCCPrePayableStatementEntity.EndDate);
db.AddInParameter(cmd, "@IsRemoved", DbType.Boolean, aCCPrePayableStatementEntity.IsRemoved);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
using (IDataReader reader = db.ExecuteReader(cmd, transaction))
{
returnCode = GetReturnCodeFromParameter(cmd);
}
if (returnCode > 0)
{
transaction.Commit();
}
else
{
throw new ArgumentException("Error Code." + returnCode.ToString());
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
transaction.Dispose();
connection.Close();
connection = null;
}
}
return(returnCode);
}
protected void lvACCPrePayableStatement_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 PrePayableStatementID;
Int64.TryParse(e.CommandArgument.ToString(), out PrePayableStatementID);
if (PrePayableStatementID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_PrePayableStatementID = PrePayableStatementID;
PrepareEditView();
cpeEditor.Collapsed = false;
cpeEditor.ClientState = "false";
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(ACCPrePayableStatementEntity.FLD_NAME_PrePayableStatementID, PrePayableStatementID.ToString(), SQLMatchType.Equal);
ACCPrePayableStatementEntity aCCPrePayableStatementEntity = new ACCPrePayableStatementEntity();
result = FCCACCPrePayableStatement.GetFacadeCreate().Delete(aCCPrePayableStatementEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_PrePayableStatementID = 0;
_ACCPrePayableStatementEntity = new ACCPrePayableStatementEntity();
PrepareInitialView();
BindACCPrePayableStatementList();
MiscUtil.ShowMessage(lblMessage, "Payable Statement has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Payable Statement.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
private Int64 Update(ACCPrePayableStatementEntity aCCPrePayableStatementEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.ACCPrePayableStatement_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
Database.AddInParameter(cmd, "@PrePayableStatementID", DbType.Int64, aCCPrePayableStatementEntity.PrePayableStatementID);
Database.AddInParameter(cmd, "@Ref", DbType.String, aCCPrePayableStatementEntity.Ref);
Database.AddInParameter(cmd, "@CreateDate", DbType.DateTime, aCCPrePayableStatementEntity.CreateDate);
Database.AddInParameter(cmd, "@StartDate", DbType.DateTime, aCCPrePayableStatementEntity.StartDate);
Database.AddInParameter(cmd, "@EndDate", DbType.DateTime, aCCPrePayableStatementEntity.EndDate);
Database.AddInParameter(cmd, "@IsRemoved", DbType.Boolean, aCCPrePayableStatementEntity.IsRemoved);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("ACCPrePayableStatementEntity already exists. Please specify another ACCPrePayableStatementEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("ACCPrePayableStatementEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("ACCPrePayableStatementEntity already exists. Please specify another ACCPrePayableStatementEntity.");
}
}
}
}
return(returnCode);
}
private void PrepareEditView()
{
ACCPrePayableStatementEntity aCCPrePayableStatementEntity = CurrentACCPrePayableStatementEntity;
if (!aCCPrePayableStatementEntity.IsNew)
{
txtRef.Text = aCCPrePayableStatementEntity.Ref.ToString();
txtCreateDate.Text = aCCPrePayableStatementEntity.CreateDate.ToStringDefault();
txtStartDate.Text = aCCPrePayableStatementEntity.StartDate.ToStringDefault();
txtEndDate.Text = aCCPrePayableStatementEntity.EndDate.ToStringDefault();
chkIsRemoved.Checked = aCCPrePayableStatementEntity.IsRemoved;
btnSubmit.Text = "Update";
btnAddNew.Visible = true;
cpeEditor.Collapsed = false;
cpeEditor.ClientState = "false";
}
}
private void SaveWOtoACCPrePayableStatementEntity()
{
if (IsValid)
{
try
{
#region AccPayableStatemenet Detail
IList <ACCPrePayableStatementDetailByWorkOrderNo_CustomEntity> lstACCPrePayableStatementDetail_CustomEntity = FCCACCPrePayableStatementDetailByWorkOrderNo_Custom.GetFacadeCreate().GetIL(Int64.Parse(ddlWorkOrderID.SelectedValue));
if (lstACCPrePayableStatementDetail_CustomEntity != null && lstACCPrePayableStatementDetail_CustomEntity.Count > 0)
{
IList <ACCPrePayableStatementDetailEntity> lstACCPrePayableStatementDetail = new List <ACCPrePayableStatementDetailEntity>();
foreach (ACCPrePayableStatementDetailByWorkOrderNo_CustomEntity entACCPrePayableStatementDetail_CustomEntity in lstACCPrePayableStatementDetail_CustomEntity)
{
ACCPrePayableStatementDetailEntity entACCPrePayableStatementDetail = new ACCPrePayableStatementDetailEntity();
//if (lstACCPrePayableStatementDetail != null && lstACCPrePayableStatementDetail.Count > 0)
//{
// ACCPrePayableStatementDetailEntity entTempACCPrePayableStatementDetail = (from s in lstACCPrePayableStatementDetail
// where s.BillID == entACCPrePayableStatementDetail_CustomEntity.BillID
// // where s.BillID == entACCPrePayableStatementDetail_CustomEntity.BillID && s.WorkOrderID == entACCPrePayableStatementDetail_CustomEntity.WorkOrderID
// //&& s.ApprovedBillAmount == entACCPrePayableStatementDetail_CustomEntity.BillAmount && s.RequisitionID != entACCPrePayableStatementDetail_CustomEntity.RequisitionID
// select s).FirstOrDefault();
// if (entTempACCPrePayableStatementDetail != null && entTempACCPrePayableStatementDetail.BillID > 0)
// {
// //Remove Previous Item
// lstACCPrePayableStatementDetail.Remove(entTempACCPrePayableStatementDetail);
// entTempACCPrePayableStatementDetail.RequisitionNo += "," + entACCPrePayableStatementDetail_CustomEntity.RequisitionNo;
// //Add New Edited Item.
// lstACCPrePayableStatementDetail.Add(entTempACCPrePayableStatementDetail);
// continue;
// }
//}
Decimal workOrderAgreementAmount = 0, paidAmount = 0, tDSAmount = 0, securityMoney = 0, billAmount = 0;
entACCPrePayableStatementDetail.PrePayableStatementID = ACCPrePayableStatementID;
if (entACCPrePayableStatementDetail_CustomEntity.WorkOrderNo.IsNotNullOrEmpty())
{
entACCPrePayableStatementDetail.WorkOrderNo = entACCPrePayableStatementDetail_CustomEntity.WorkOrderNo.Trim();
}
else
{
entACCPrePayableStatementDetail.WorkOrderNo = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.WOAmount.HasValue)
{
workOrderAgreementAmount = Decimal.Parse(entACCPrePayableStatementDetail_CustomEntity.WOAmount.ToString());
entACCPrePayableStatementDetail.WorkOrderAmount = workOrderAgreementAmount;
}
else
{
entACCPrePayableStatementDetail.WorkOrderAmount = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.WorkOrderID > 0)
{
entACCPrePayableStatementDetail.WorkOrderID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.WorkOrderID.ToString());
}
else
{
entACCPrePayableStatementDetail.WorkOrderID = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.StartDate != null)
{
entACCPrePayableStatementDetail.WorkOrderDate = entACCPrePayableStatementDetail_CustomEntity.StartDate;
}
else
{
entACCPrePayableStatementDetail.WorkOrderDate = null;
}
Decimal payableAgainstWO = (workOrderAgreementAmount - paidAmount - tDSAmount);
//Decimal netPayableConsideringBillSecurity = (billAmount - paidAmount - securityMoney - tDSAmount); //need to discuss with Rayan vaiya. To get value from formula or anywhere else???
Decimal netPayableConsideringBillSecurity = payableAgainstWO;
entACCPrePayableStatementDetail.PaidAmount = paidAmount;
entACCPrePayableStatementDetail.SecurityMoney = securityMoney;
entACCPrePayableStatementDetail.TDSAmount = tDSAmount;
entACCPrePayableStatementDetail.PayableAgainstWorkOrder = payableAgainstWO;
entACCPrePayableStatementDetail.NetPayableConsideringBillAndSecurity = netPayableConsideringBillSecurity;
entACCPrePayableStatementDetail.CreateDate = System.DateTime.Now;
entACCPrePayableStatementDetail.ApprovedBillAmount = 0;
entACCPrePayableStatementDetail.PartyReconcile = false;
Int64 requisitionID = 0;
Int64 projectID = 0;
String projectCode = null;
String requisitionNo = null;
DateTime requisitionDate = System.DateTime.Now;
if (entACCPrePayableStatementDetail_CustomEntity.WorkOrderID > 0)
{
String fe_WOItemMap = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderItemMapEntity.FLD_NAME_WorkOrderID, entACCPrePayableStatementDetail_CustomEntity.WorkOrderID.ToString(), SQLMatchType.Equal);
IList <PRMWorkOrderItemMapEntity> lstWOItemMap = FCCPRMWorkOrderItemMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe_WOItemMap, DatabaseOperationType.LoadWithFilterExpression);
if (lstWOItemMap != null && lstWOItemMap.Count > 0)
{
var distinctTypeIDs = lstWOItemMap.Select(x => x.RequisitionID).Distinct();
foreach (var ent in distinctTypeIDs)
{
String fe_requisition = SqlExpressionBuilder.PrepareFilterExpression("REQRequisition." + REQRequisitionEntity.FLD_NAME_RequisitionID, ent.ToString(), SQLMatchType.Equal);
IList <REQRequisition_DetailedEntity> lstReqRequisition_detailed = FCCREQRequisition_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_requisition);
if (lstReqRequisition_detailed != null && lstReqRequisition_detailed.Count > 0)
{
requisitionID = lstReqRequisition_detailed[0].RequisitionID;
projectCode = lstReqRequisition_detailed[0].ProjectCode;
requisitionNo += lstReqRequisition_detailed[0].RequisitionNo + " ";
requisitionDate = lstReqRequisition_detailed[0].RequisitionDate;
projectID = lstReqRequisition_detailed[0].ProjectID;
}
}
}
}
entACCPrePayableStatementDetail.RequisitionID = requisitionID;
entACCPrePayableStatementDetail.RequisitionNo = requisitionNo;
entACCPrePayableStatementDetail.RequisitionDate = requisitionDate;
entACCPrePayableStatementDetail.ProjectID = projectID;
entACCPrePayableStatementDetail.ProjectCode = projectCode;
//REQRequisitionEntity reqRequisitionEntity = null;
//if (entACCPrePayableStatementDetail_CustomEntity.RequisitionID > 0)
//{
// entACCPrePayableStatementDetail.RequisitionID = entACCPrePayableStatementDetail_CustomEntity.RequisitionID;
// reqRequisitionEntity = FCCREQRequisition.GetFacadeCreate().GetByID(entACCPrePayableStatementDetail_CustomEntity.RequisitionID);
// if (reqRequisitionEntity != null)
// {
// entACCPrePayableStatementDetail.RequisitionNo = reqRequisitionEntity.RequisitionNo; ;
// entACCPrePayableStatementDetail.RequisitionDate = reqRequisitionEntity.RequisitionDate;
// entACCPrePayableStatementDetail.ProjectID = reqRequisitionEntity.ProjectID; // Project ID should come from the first requisition Project ID.
// }
//}
//else
//{
// entACCPrePayableStatementDetail.RequisitionID = null;
//}
//if (entACCPrePayableStatementDetail_CustomEntity.RequisitionNo.IsNotNullOrEmpty())
//{
// entACCPrePayableStatementDetail.RequisitionNo = entACCPrePayableStatementDetail_CustomEntity.RequisitionNo;
//}
//else
//{
// entACCPrePayableStatementDetail.RequisitionNo = null;
//}
//if (entACCPrePayableStatementDetail_CustomEntity.RequisitionDate.HasValue)
//{
// entACCPrePayableStatementDetail.RequisitionDate = entACCPrePayableStatementDetail_CustomEntity.RequisitionDate;
//}
//else
//{
// entACCPrePayableStatementDetail.RequisitionDate = null;
//}
//entACCPrePayableStatementDetail.ProjectID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.ProjectID.ToString());
entACCPrePayableStatementDetail.BillID = null;
entACCPrePayableStatementDetail.BillDate = null;
entACCPrePayableStatementDetail.BillNo = null;
entACCPrePayableStatementDetail.VendorCategoryID = MasterDataConstants.MDVendorCategory.VENDOR;
entACCPrePayableStatementDetail.FromVendorID = entACCPrePayableStatementDetail_CustomEntity.SupplierID;
entACCPrePayableStatementDetail.CreateByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
entACCPrePayableStatementDetail.Ref = null;
entACCPrePayableStatementDetail.DueDate = DateTime.Now;
entACCPrePayableStatementDetail.PlannedDate = null;
entACCPrePayableStatementDetail.Remarks = null;
entACCPrePayableStatementDetail.AdditionalRemarks = null;
entACCPrePayableStatementDetail.ACCPayablePaymentStatusID = MasterDataConstants.MDACCPayablePaymentStatus.CURRENT;
entACCPrePayableStatementDetail.ACCPayableApprovalStatusID = MasterDataConstants.ACCPrePayableStatementApprovalStatus.INITIATED;
entACCPrePayableStatementDetail.AccountPaybleStatementDetailCategoryID = MasterDataConstants.MDAccountPaybleStatementDetailCategory.REGULAR;
entACCPrePayableStatementDetail.PayableClassificationID = MasterDataConstants.MDPayableClassification.AS;
entACCPrePayableStatementDetail.APPanelID = MasterDataConstants.DeafultAPPanel.DEFAULT_AP_PANEL;
entACCPrePayableStatementDetail.IsRemoved = false;
entACCPrePayableStatementDetail.IsLocked = false;
lstACCPrePayableStatementDetail.Add(entACCPrePayableStatementDetail);
break;
}
#region Insert To Payable Detail
if (lstACCPrePayableStatementDetail != null && lstACCPrePayableStatementDetail.Count > 0)
{
foreach (ACCPrePayableStatementDetailEntity ent in lstACCPrePayableStatementDetail)
{
FCCACCPrePayableStatementDetail.GetFacadeCreate().Add(ent, DatabaseOperationType.Add, TransactionRequired.No);
}
}
#endregion
MiscUtil.ShowMessage(lblMessage, "Pre Payable Statement Information has been added successfully.", false);
}
#endregion
_PrePayableStatementID = 0;
_ACCPrePayableStatementEntity = new ACCPrePayableStatementEntity();
PrepareInitialView();
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
private void SaveBilltoACCPrePayableStatementEntity()
{
if (IsValid)
{
try
{
#region AccPayableStatemenet Detail
IList <ACCPrePayableStatementDetailByBill_CustomEntity> lstACCPrePayableStatementDetail_CustomEntity = FCCACCPrePayableStatementDetailByBill_Custom.GetFacadeCreate().GetIL(Int64.Parse(ddlBillID.SelectedValue));
if (lstACCPrePayableStatementDetail_CustomEntity != null && lstACCPrePayableStatementDetail_CustomEntity.Count > 0)
{
IList <ACCPrePayableStatementDetailEntity> lstACCPrePayableStatementDetail = new List <ACCPrePayableStatementDetailEntity>();
foreach (ACCPrePayableStatementDetailByBill_CustomEntity entACCPrePayableStatementDetail_CustomEntity in lstACCPrePayableStatementDetail_CustomEntity)
{
ACCPrePayableStatementDetailEntity entACCPrePayableStatementDetail = new ACCPrePayableStatementDetailEntity();
if (lstACCPrePayableStatementDetail != null && lstACCPrePayableStatementDetail.Count > 0)
{
ACCPrePayableStatementDetailEntity entTempACCPrePayableStatementDetail = (from s in lstACCPrePayableStatementDetail
where s.BillID == entACCPrePayableStatementDetail_CustomEntity.BillID && s.WorkOrderID == entACCPrePayableStatementDetail_CustomEntity.WorkOrderID
// where s.BillID == entACCPrePayableStatementDetail_CustomEntity.BillID && s.WorkOrderID == entACCPrePayableStatementDetail_CustomEntity.WorkOrderID
//&& s.ApprovedBillAmount == entACCPrePayableStatementDetail_CustomEntity.BillAmount && s.RequisitionID != entACCPrePayableStatementDetail_CustomEntity.RequisitionID
select s).FirstOrDefault();
if (entTempACCPrePayableStatementDetail != null && entTempACCPrePayableStatementDetail.BillID > 0)
{
//Remove Previous Item
lstACCPrePayableStatementDetail.Remove(entTempACCPrePayableStatementDetail);
entTempACCPrePayableStatementDetail.RequisitionNo += "," + entACCPrePayableStatementDetail_CustomEntity.RequisitionNo;
//Add New Edited Item.
lstACCPrePayableStatementDetail.Add(entTempACCPrePayableStatementDetail);
continue;
}
}
Decimal workOrderAgreementAmount = 0, paidAmount = 0, tDSAmount = 0, securityMoney = 0;
entACCPrePayableStatementDetail.PrePayableStatementID = ACCPrePayableStatementID;
if (entACCPrePayableStatementDetail_CustomEntity.WorkOrderNo.IsNotNullOrEmpty())
{
entACCPrePayableStatementDetail.WorkOrderNo = entACCPrePayableStatementDetail_CustomEntity.WorkOrderNo.Trim();
}
else
{
entACCPrePayableStatementDetail.WorkOrderNo = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.WOAmount.HasValue)
{
workOrderAgreementAmount = Decimal.Parse(entACCPrePayableStatementDetail_CustomEntity.WOAmount.ToString());
entACCPrePayableStatementDetail.WorkOrderAmount = workOrderAgreementAmount;
}
else
{
entACCPrePayableStatementDetail.WorkOrderAmount = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.WorkOrderID > 0)
{
entACCPrePayableStatementDetail.WorkOrderID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.WorkOrderID.ToString());
}
else
{
entACCPrePayableStatementDetail.WorkOrderID = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.StartDate.HasValue)
{
entACCPrePayableStatementDetail.WorkOrderDate = entACCPrePayableStatementDetail_CustomEntity.StartDate;
}
else
{
entACCPrePayableStatementDetail.WorkOrderDate = null;
}
Decimal payableAgainstWO = (workOrderAgreementAmount - paidAmount - tDSAmount);
Decimal netPayableConsideringBillSecurity = (payableAgainstWO - paidAmount - securityMoney - tDSAmount);
entACCPrePayableStatementDetail.PaidAmount = paidAmount;
entACCPrePayableStatementDetail.SecurityMoney = securityMoney;
entACCPrePayableStatementDetail.TDSAmount = tDSAmount;
entACCPrePayableStatementDetail.PayableAgainstWorkOrder = payableAgainstWO;
entACCPrePayableStatementDetail.NetPayableConsideringBillAndSecurity = netPayableConsideringBillSecurity;
entACCPrePayableStatementDetail.CreateDate = System.DateTime.Now;
if (entACCPrePayableStatementDetail_CustomEntity.BillAmount.HasValue)
{
entACCPrePayableStatementDetail.ApprovedBillAmount = Decimal.Parse(entACCPrePayableStatementDetail_CustomEntity.BillAmount.ToString());
}
else
{
entACCPrePayableStatementDetail.ApprovedBillAmount = null;
}
entACCPrePayableStatementDetail.PartyReconcile = false;
if (entACCPrePayableStatementDetail_CustomEntity.RequisitionID > 0)
{
entACCPrePayableStatementDetail.RequisitionID = entACCPrePayableStatementDetail_CustomEntity.RequisitionID;
}
else
{
entACCPrePayableStatementDetail.RequisitionID = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.RequisitionNo.IsNotNullOrEmpty())
{
entACCPrePayableStatementDetail.RequisitionNo = entACCPrePayableStatementDetail_CustomEntity.RequisitionNo;
}
else
{
entACCPrePayableStatementDetail.RequisitionNo = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.RequisitionDate.HasValue)
{
entACCPrePayableStatementDetail.RequisitionDate = entACCPrePayableStatementDetail_CustomEntity.RequisitionDate;
}
else
{
entACCPrePayableStatementDetail.RequisitionDate = null;
}
entACCPrePayableStatementDetail.ProjectID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.ProjectID.ToString());
entACCPrePayableStatementDetail.BillID = entACCPrePayableStatementDetail_CustomEntity.BillID;
entACCPrePayableStatementDetail.BillDate = entACCPrePayableStatementDetail_CustomEntity.billlDate;
entACCPrePayableStatementDetail.BillNo = entACCPrePayableStatementDetail_CustomEntity.BillNo;
entACCPrePayableStatementDetail.VendorCategoryID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.VendorCategory.ToString());
entACCPrePayableStatementDetail.FromVendorID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.Vendor.ToString());
entACCPrePayableStatementDetail.CreateByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
entACCPrePayableStatementDetail.Ref = null;
entACCPrePayableStatementDetail.DueDate = DateTime.Now;
entACCPrePayableStatementDetail.PlannedDate = null;
entACCPrePayableStatementDetail.Remarks = null;
entACCPrePayableStatementDetail.AdditionalRemarks = null;
entACCPrePayableStatementDetail.ACCPayablePaymentStatusID = MasterDataConstants.MDACCPayablePaymentStatus.CURRENT;
entACCPrePayableStatementDetail.ACCPayableApprovalStatusID = MasterDataConstants.ACCPrePayableStatementApprovalStatus.INITIATED;
entACCPrePayableStatementDetail.AccountPaybleStatementDetailCategoryID = MasterDataConstants.MDAccountPaybleStatementDetailCategory.REGULAR;
entACCPrePayableStatementDetail.PayableClassificationID = MasterDataConstants.MDPayableClassification.AS;
entACCPrePayableStatementDetail.APPanelID = MasterDataConstants.DeafultAPPanel.DEFAULT_AP_PANEL;
entACCPrePayableStatementDetail.IsRemoved = false;
entACCPrePayableStatementDetail.IsLocked = false;
lstACCPrePayableStatementDetail.Add(entACCPrePayableStatementDetail);
}
#region Insert To Payable Detail
if (lstACCPrePayableStatementDetail != null && lstACCPrePayableStatementDetail.Count > 0)
{
foreach (ACCPrePayableStatementDetailEntity ent in lstACCPrePayableStatementDetail)
{
FCCACCPrePayableStatementDetail.GetFacadeCreate().Add(ent, DatabaseOperationType.Add, TransactionRequired.No);
}
}
#endregion
}
#endregion
_PrePayableStatementID = 0;
_ACCPrePayableStatementEntity = new ACCPrePayableStatementEntity();
PrepareInitialView();
MiscUtil.ShowMessage(lblMessage, "Pre Payable Statement Information has been added successfully.", false);
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
protected void btnAddNew_Click(object sender, EventArgs e)
{
_PrePayableStatementID = 0;
_ACCPrePayableStatementEntity = new ACCPrePayableStatementEntity();
PrepareInitialView();
}
private void SaveACCPrePayableStatementEntity()
{
if (IsValid)
{
try
{
ACCPrePayableStatementEntity aCCPrePayableStatementEntity = BuildACCPrePayableStatementEntity();
Int64 result = -1;
if (aCCPrePayableStatementEntity.IsNew)
{
result = FCCACCPrePayableStatement.GetFacadeCreate().Add(aCCPrePayableStatementEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(ACCPrePayableStatementEntity.FLD_NAME_PrePayableStatementID, aCCPrePayableStatementEntity.PrePayableStatementID.ToString(), SQLMatchType.Equal);
result = FCCACCPrePayableStatement.GetFacadeCreate().Update(aCCPrePayableStatementEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
#region AccPayableStatemenet Detail From Bill
IList <ACCPrePayableStatementDetail_CustomEntity> lstACCPrePayableStatementDetail_CustomEntity = FCCACCPrePayableStatementDetail_Custom.GetFacadeCreate().GetIL(aCCPrePayableStatementEntity.StartDate, aCCPrePayableStatementEntity.EndDate);
if (lstACCPrePayableStatementDetail_CustomEntity != null && lstACCPrePayableStatementDetail_CustomEntity.Count > 0)
{
IList <ACCPrePayableStatementDetailEntity> lstACCPrePayableStatementDetail = new List <ACCPrePayableStatementDetailEntity>();
foreach (ACCPrePayableStatementDetail_CustomEntity entACCPrePayableStatementDetail_CustomEntity in lstACCPrePayableStatementDetail_CustomEntity)
{
ACCPrePayableStatementDetailEntity entACCPrePayableStatementDetail = new ACCPrePayableStatementDetailEntity();
if (lstACCPrePayableStatementDetail != null && lstACCPrePayableStatementDetail.Count > 0)
{
ACCPrePayableStatementDetailEntity entTempACCPrePayableStatementDetail = (from s in lstACCPrePayableStatementDetail
where s.BillID == entACCPrePayableStatementDetail_CustomEntity.BillID && s.WorkOrderID == entACCPrePayableStatementDetail_CustomEntity.WorkOrderID
//where s.BillID == entACCPrePayableStatementDetail_CustomEntity.BillID && s.WorkOrderID == entACCPrePayableStatementDetail_CustomEntity.WorkOrderID
//&& s.ApprovedBillAmount == entACCPrePayableStatementDetail_CustomEntity.BillAmount && s.RequisitionID == entACCPrePayableStatementDetail_CustomEntity.RequisitionID
select s).FirstOrDefault();
if (entTempACCPrePayableStatementDetail != null && entTempACCPrePayableStatementDetail.BillID > 0)
{
//Remove Previous Item
lstACCPrePayableStatementDetail.Remove(entTempACCPrePayableStatementDetail);
///Clear this list................................
entTempACCPrePayableStatementDetail.RequisitionNo += "," + entACCPrePayableStatementDetail_CustomEntity.RequisitionNo;
//Add New Edited Item.
lstACCPrePayableStatementDetail.Add(entTempACCPrePayableStatementDetail);
continue;
}
}
//else if(Flag)
//{
Decimal workOrderAgreementAmount = 0, paidAmount = 0, tDSAmount = 0, securityMoney = 0, billamount = 0;
Decimal.TryParse(entACCPrePayableStatementDetail_CustomEntity.BillAmount.ToString(), out billamount);
entACCPrePayableStatementDetail.PrePayableStatementID = result;
if (entACCPrePayableStatementDetail_CustomEntity.WorkOrderNo.IsNotNullOrEmpty())
{
entACCPrePayableStatementDetail.WorkOrderNo = entACCPrePayableStatementDetail_CustomEntity.WorkOrderNo.Trim();
}
else
{
entACCPrePayableStatementDetail.WorkOrderNo = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.WOAmount.HasValue)
{
workOrderAgreementAmount = Decimal.Parse(entACCPrePayableStatementDetail_CustomEntity.WOAmount.ToString());
entACCPrePayableStatementDetail.WorkOrderAmount = workOrderAgreementAmount;
}
else
{
entACCPrePayableStatementDetail.WorkOrderAmount = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.WorkOrderID > 0)
{
entACCPrePayableStatementDetail.WorkOrderID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.WorkOrderID.ToString());
}
else
{
entACCPrePayableStatementDetail.WorkOrderID = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.StartDate.HasValue)
{
entACCPrePayableStatementDetail.WorkOrderDate = entACCPrePayableStatementDetail_CustomEntity.StartDate;
}
else
{
entACCPrePayableStatementDetail.WorkOrderDate = null;
}
Decimal payableAgainstWO = (workOrderAgreementAmount - paidAmount - tDSAmount);
Decimal netPayableConsideringBillSecurity = (billamount - paidAmount - securityMoney - tDSAmount);
entACCPrePayableStatementDetail.PaidAmount = paidAmount;
entACCPrePayableStatementDetail.SecurityMoney = securityMoney;
entACCPrePayableStatementDetail.TDSAmount = tDSAmount;
entACCPrePayableStatementDetail.PayableAgainstWorkOrder = payableAgainstWO;
entACCPrePayableStatementDetail.NetPayableConsideringBillAndSecurity = netPayableConsideringBillSecurity;
entACCPrePayableStatementDetail.CreateDate = System.DateTime.Now;
//if (!txtSecurityMoneyLV.Text.Trim().IsNullOrEmpty())
//{
// aCCPrePayableStatementDetailEntity.SecurityMoney = Decimal.Parse(txtSecurityMoneyLV.Text.Trim());
//}
//else
//{
// aCCPrePayableStatementDetailEntity.SecurityMoney = null;
//}
//if (!txtTDSAmountLV.Text.Trim().IsNullOrEmpty())
//{
// aCCPrePayableStatementDetailEntity.TDSAmount = Decimal.Parse(txtTDSAmountLV.Text.Trim());
//}
//else
//{
// aCCPrePayableStatementDetailEntity.TDSAmount = null;
//}
//if (!txtPayableAgainstWorkOrderLV.Text.Trim().IsNullOrEmpty())
//{
// aCCPrePayableStatementDetailEntity.PayableAgainstWorkOrder = Decimal.Parse(txtPayableAgainstWorkOrderLV.Text.Trim());
//}
//else
//{
// aCCPrePayableStatementDetailEntity.PayableAgainstWorkOrder = null;
//}
if (entACCPrePayableStatementDetail_CustomEntity.BillAmount.HasValue)
{
entACCPrePayableStatementDetail.ApprovedBillAmount = Decimal.Parse(entACCPrePayableStatementDetail_CustomEntity.BillAmount.ToString());
}
else
{
entACCPrePayableStatementDetail.ApprovedBillAmount = null;
}
//if (!txtNetPayableConsideringBillAndSecurityLV.Text.Trim().IsNullOrEmpty())
//{
// aCCPrePayableStatementDetailEntity.NetPayableConsideringBillAndSecurity = Decimal.Parse(txtNetPayableConsideringBillAndSecurityLV.Text.Trim());
//}
//else
//{
// aCCPrePayableStatementDetailEntity.NetPayableConsideringBillAndSecurity = null;
//}
entACCPrePayableStatementDetail.PartyReconcile = false;
if (entACCPrePayableStatementDetail_CustomEntity.RequisitionID > 0)
{
entACCPrePayableStatementDetail.RequisitionID = entACCPrePayableStatementDetail_CustomEntity.RequisitionID;
}
else
{
entACCPrePayableStatementDetail.RequisitionID = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.RequisitionNo.IsNotNullOrEmpty())
{
entACCPrePayableStatementDetail.RequisitionNo = entACCPrePayableStatementDetail_CustomEntity.RequisitionNo;
}
else
{
entACCPrePayableStatementDetail.RequisitionNo = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.RequisitionDate.HasValue)
{
entACCPrePayableStatementDetail.RequisitionDate = entACCPrePayableStatementDetail_CustomEntity.RequisitionDate;
}
else
{
entACCPrePayableStatementDetail.RequisitionDate = null;
}
entACCPrePayableStatementDetail.ProjectID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.ProjectID.ToString());
entACCPrePayableStatementDetail.BillID = entACCPrePayableStatementDetail_CustomEntity.BillID;
entACCPrePayableStatementDetail.BillDate = entACCPrePayableStatementDetail_CustomEntity.billlDate;
entACCPrePayableStatementDetail.BillNo = entACCPrePayableStatementDetail_CustomEntity.BillNo;
entACCPrePayableStatementDetail.VendorCategoryID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.VendorCategory.ToString());
entACCPrePayableStatementDetail.FromVendorID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.Vendor.ToString());
entACCPrePayableStatementDetail.CreateByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
entACCPrePayableStatementDetail.Ref = null;
entACCPrePayableStatementDetail.DueDate = DateTime.Now;
entACCPrePayableStatementDetail.PlannedDate = null;
entACCPrePayableStatementDetail.Remarks = null;
entACCPrePayableStatementDetail.AdditionalRemarks = null;
entACCPrePayableStatementDetail.ACCPayablePaymentStatusID = MasterDataConstants.MDACCPayablePaymentStatus.CURRENT;
entACCPrePayableStatementDetail.ACCPayableApprovalStatusID = MasterDataConstants.ACCPrePayableStatementApprovalStatus.INITIATED;
entACCPrePayableStatementDetail.AccountPaybleStatementDetailCategoryID = MasterDataConstants.MDAccountPaybleStatementDetailCategory.REGULAR;
entACCPrePayableStatementDetail.PayableClassificationID = MasterDataConstants.MDPayableClassification.AS;
entACCPrePayableStatementDetail.APPanelID = MasterDataConstants.DeafultAPPanel.DEFAULT_AP_PANEL;
entACCPrePayableStatementDetail.IsRemoved = false;
entACCPrePayableStatementDetail.IsLocked = false;
lstACCPrePayableStatementDetail.Add(entACCPrePayableStatementDetail);
//}
}
#region AccPayableStatemenet Detail
IList <ACCPrePayableStatementDetailFromWO_CustomEntity> lstACCPrePayableStatementDetailFromWO_CustomEntity = FCCACCPrePayableStatementDetailFromWO_Custom.GetFacadeCreate().GetIL();
if (lstACCPrePayableStatementDetailFromWO_CustomEntity != null && lstACCPrePayableStatementDetailFromWO_CustomEntity.Count > 0)
{
foreach (ACCPrePayableStatementDetailFromWO_CustomEntity entACCPrePayableStatementDetail_CustomEntity in lstACCPrePayableStatementDetailFromWO_CustomEntity)
{
ACCPrePayableStatementDetailEntity entACCPrePayableStatementDetail = new ACCPrePayableStatementDetailEntity();
//if (lstACCPrePayableStatementDetail != null && lstACCPrePayableStatementDetail.Count > 0)
//{
// ACCPrePayableStatementDetailEntity entTempACCPrePayableStatementDetail = (from s in lstACCPrePayableStatementDetail
// where s.BillID == entACCPrePayableStatementDetail_CustomEntity.BillID
// // where s.BillID == entACCPrePayableStatementDetail_CustomEntity.BillID && s.WorkOrderID == entACCPrePayableStatementDetail_CustomEntity.WorkOrderID
// //&& s.ApprovedBillAmount == entACCPrePayableStatementDetail_CustomEntity.BillAmount && s.RequisitionID != entACCPrePayableStatementDetail_CustomEntity.RequisitionID
// select s).FirstOrDefault();
// if (entTempACCPrePayableStatementDetail != null && entTempACCPrePayableStatementDetail.BillID > 0)
// {
// //Remove Previous Item
// lstACCPrePayableStatementDetail.Remove(entTempACCPrePayableStatementDetail);
// entTempACCPrePayableStatementDetail.RequisitionNo += "," + entACCPrePayableStatementDetail_CustomEntity.RequisitionNo;
// //Add New Edited Item.
// lstACCPrePayableStatementDetail.Add(entTempACCPrePayableStatementDetail);
// continue;
// }
//}
Decimal workOrderAgreementAmount = 0, paidAmount = 0, tDSAmount = 0, securityMoney = 0, billAmount = 0;
entACCPrePayableStatementDetail.PrePayableStatementID = result;
if (entACCPrePayableStatementDetail_CustomEntity.WorkOrderNo.IsNotNullOrEmpty())
{
entACCPrePayableStatementDetail.WorkOrderNo = entACCPrePayableStatementDetail_CustomEntity.WorkOrderNo.Trim();
}
else
{
entACCPrePayableStatementDetail.WorkOrderNo = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.WOAmount.HasValue)
{
workOrderAgreementAmount = Decimal.Parse(entACCPrePayableStatementDetail_CustomEntity.WOAmount.ToString());
entACCPrePayableStatementDetail.WorkOrderAmount = workOrderAgreementAmount;
}
else
{
entACCPrePayableStatementDetail.WorkOrderAmount = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.WorkOrderID > 0)
{
entACCPrePayableStatementDetail.WorkOrderID = Int64.Parse(entACCPrePayableStatementDetail_CustomEntity.WorkOrderID.ToString());
}
else
{
entACCPrePayableStatementDetail.WorkOrderID = null;
}
if (entACCPrePayableStatementDetail_CustomEntity.StartDate != null)
{
entACCPrePayableStatementDetail.WorkOrderDate = entACCPrePayableStatementDetail_CustomEntity.StartDate;
}
else
{
entACCPrePayableStatementDetail.WorkOrderDate = null;
}
Decimal payableAgainstWO = (workOrderAgreementAmount - paidAmount - tDSAmount);
//Decimal netPayableConsideringBillSecurity = (billAmount - paidAmount - securityMoney - tDSAmount); //need to discuss with Rayan vaiya. To get value from formula or anywhere else???
Decimal netPayableConsideringBillSecurity = payableAgainstWO;
entACCPrePayableStatementDetail.PaidAmount = paidAmount;
entACCPrePayableStatementDetail.SecurityMoney = securityMoney;
entACCPrePayableStatementDetail.TDSAmount = tDSAmount;
entACCPrePayableStatementDetail.PayableAgainstWorkOrder = payableAgainstWO;
entACCPrePayableStatementDetail.NetPayableConsideringBillAndSecurity = netPayableConsideringBillSecurity;
entACCPrePayableStatementDetail.CreateDate = System.DateTime.Now;
entACCPrePayableStatementDetail.ApprovedBillAmount = 0;
entACCPrePayableStatementDetail.PartyReconcile = false;
Int64 requisitionID = 0;
Int64 projectID = 0;
String projectCode = null;
String requisitionNo = null;
DateTime requisitionDate = System.DateTime.Now;
if (entACCPrePayableStatementDetail_CustomEntity.WorkOrderID > 0)
{
String fe_WOItemMap = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderItemMapEntity.FLD_NAME_WorkOrderID, entACCPrePayableStatementDetail_CustomEntity.WorkOrderID.ToString(), SQLMatchType.Equal);
IList <PRMWorkOrderItemMapEntity> lstWOItemMap = FCCPRMWorkOrderItemMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe_WOItemMap, DatabaseOperationType.LoadWithFilterExpression);
if (lstWOItemMap != null && lstWOItemMap.Count > 0)
{
var distinctTypeIDs = lstWOItemMap.Select(x => x.RequisitionID).Distinct();
foreach (var ent in distinctTypeIDs)
{
String fe_requisition = SqlExpressionBuilder.PrepareFilterExpression("REQRequisition." + REQRequisitionEntity.FLD_NAME_RequisitionID, ent.ToString(), SQLMatchType.Equal);
IList <REQRequisition_DetailedEntity> lstReqRequisition_detailed = FCCREQRequisition_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_requisition);
if (lstReqRequisition_detailed != null && lstReqRequisition_detailed.Count > 0)
{
requisitionID = lstReqRequisition_detailed[0].RequisitionID;
projectCode = lstReqRequisition_detailed[0].ProjectCode;
requisitionNo += lstReqRequisition_detailed[0].RequisitionNo + " ";
requisitionDate = lstReqRequisition_detailed[0].RequisitionDate;
projectID = lstReqRequisition_detailed[0].ProjectID;
}
}
}
}
entACCPrePayableStatementDetail.RequisitionID = requisitionID;
entACCPrePayableStatementDetail.RequisitionNo = requisitionNo;
entACCPrePayableStatementDetail.RequisitionDate = requisitionDate;
entACCPrePayableStatementDetail.ProjectID = projectID;
entACCPrePayableStatementDetail.ProjectCode = projectCode;
entACCPrePayableStatementDetail.BillID = null;
entACCPrePayableStatementDetail.BillDate = null;
entACCPrePayableStatementDetail.BillNo = null;
entACCPrePayableStatementDetail.VendorCategoryID = MasterDataConstants.MDVendorCategory.VENDOR;
entACCPrePayableStatementDetail.FromVendorID = entACCPrePayableStatementDetail_CustomEntity.SupplierID;
entACCPrePayableStatementDetail.CreateByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
entACCPrePayableStatementDetail.Ref = null;
entACCPrePayableStatementDetail.DueDate = DateTime.Now;
entACCPrePayableStatementDetail.PlannedDate = null;
entACCPrePayableStatementDetail.Remarks = null;
entACCPrePayableStatementDetail.AdditionalRemarks = null;
entACCPrePayableStatementDetail.ACCPayablePaymentStatusID = MasterDataConstants.MDACCPayablePaymentStatus.CURRENT;
entACCPrePayableStatementDetail.ACCPayableApprovalStatusID = MasterDataConstants.ACCPrePayableStatementApprovalStatus.INITIATED;
entACCPrePayableStatementDetail.AccountPaybleStatementDetailCategoryID = MasterDataConstants.MDAccountPaybleStatementDetailCategory.REGULAR;
entACCPrePayableStatementDetail.PayableClassificationID = MasterDataConstants.MDPayableClassification.AS;
entACCPrePayableStatementDetail.APPanelID = MasterDataConstants.DeafultAPPanel.DEFAULT_AP_PANEL;
entACCPrePayableStatementDetail.IsRemoved = false;
entACCPrePayableStatementDetail.IsLocked = false;
lstACCPrePayableStatementDetail.Add(entACCPrePayableStatementDetail);
}
//#region Insert To Payable Detail
//if (lstACCPrePayableStatementDetail != null && lstACCPrePayableStatementDetail.Count > 0)
//{
// foreach (ACCPrePayableStatementDetailEntity ent in lstACCPrePayableStatementDetail)
// {
// FCCACCPrePayableStatementDetail.GetFacadeCreate().Add(ent, DatabaseOperationType.Add, TransactionRequired.No);
// }
//}
//#endregion
//MiscUtil.ShowMessage(lblMessage, "Pre Payable Statement Information has been added successfully.", false);
}
#endregion
#region Insert To Payable Detail
if (lstACCPrePayableStatementDetail != null && lstACCPrePayableStatementDetail.Count > 0)
{
foreach (ACCPrePayableStatementDetailEntity ent in lstACCPrePayableStatementDetail)
{
FCCACCPrePayableStatementDetail.GetFacadeCreate().Add(ent, DatabaseOperationType.Add, TransactionRequired.No);
}
}
#endregion
}
#endregion
_PrePayableStatementID = 0;
_ACCPrePayableStatementEntity = new ACCPrePayableStatementEntity();
PrepareInitialView();
BindACCPrePayableStatementList();
String navUrl = UrlHelper.BuildSecureUrl("~/ACC/ACCPrePayableStatementDetail.aspx", string.Empty, UrlConstants.OVERVIEW_PRE_PAYABLE_STATEMENT_ID, result.ToString()).ToString();
Response.Redirect(navUrl);
if (aCCPrePayableStatementEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Pre Payable Statement Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Pre Payable Statement Information has been updated successfully.", false);
}
}
else
{
if (aCCPrePayableStatementEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Pre Payable Statement Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Pre Payable Statement Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
Int64 IACCPrePayableStatementFacade.Delete(ACCPrePayableStatementEntity aCCPrePayableStatementEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateACCPrePayableStatementDataAccess().Delete(aCCPrePayableStatementEntity, filterExpression, option, reqTran));
}
Int64 IACCPrePayableStatementFacade.Add(ACCPrePayableStatementEntity aCCPrePayableStatementEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateACCPrePayableStatementDataAccess().Add(aCCPrePayableStatementEntity, option, reqTran));
}
