private void SaveCMBillEntity()
{
if (ValidationInput())
{
if (IsValid)
{
try
{
CMBillEntity cMBillEntity = BuildCMBillEntity();
Int64 result = -1;
if (cMBillEntity.IsNew)
{
result = FCCCMBill.GetFacadeCreate().Add(cMBillEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(CMBillEntity.FLD_NAME_BillID, cMBillEntity.BillID.ToString(), SQLMatchType.Equal);
result = FCCCMBill.GetFacadeCreate().Update(cMBillEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
#region Update WO Final Bill Status
if (cMBillEntity.BillStatusID == MasterDataConstants.MDBillStatus.FINAL_BILL)
{
PRMWorkOrderEntity prmWorkOrderEntity = FCCPRMWorkOrder.GetFacadeCreate().GetByID(cMBillEntity.WorkOrderID);
prmWorkOrderEntity.IsFinalBilled = true;
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderEntity.FLD_NAME_WorkOrderID, prmWorkOrderEntity.WorkOrderID.ToString(), SQLMatchType.Equal);
FCCPRMWorkOrder.GetFacadeCreate().Update(prmWorkOrderEntity, fe, DatabaseOperationType.Update, TransactionRequired.No);
}
#endregion
#region Bill Requisition Item Map
CMBillRequisitionItemMapEntity cMBillRequisitionItemMapEntity = new CMBillRequisitionItemMapEntity();
try
{
IList <ListViewDataItem> list = lvREQRequisitionItem.Items;
if (list != null && list.Count > 0)
{
foreach (ListViewDataItem lvdi in list)
{
Decimal billPriceLV;
TextBox txtBillPriceLV = (TextBox)lvdi.FindControl("txtBillPriceLV");
Decimal.TryParse(txtBillPriceLV.Text.Trim(), out billPriceLV);
if (billPriceLV > 0)
{
Label lblRequisitionIDLV = (Label)lvdi.FindControl("lblRequisitionIDLV");
Label lblRequisitionPriceLV = (Label)lvdi.FindControl("lblRequisitionPriceLV");
Label lblRequisitionItemIDLV = (Label)lvdi.FindControl("lblRequisitionItemIDLV");
cMBillRequisitionItemMapEntity.BillID = result;
cMBillRequisitionItemMapEntity.RequisitionID = Int64.Parse(lblRequisitionIDLV.Text);
cMBillRequisitionItemMapEntity.RequisitionItemID = Int64.Parse(lblRequisitionItemIDLV.Text);
cMBillRequisitionItemMapEntity.RequisitionPrice = Decimal.Parse(lblRequisitionPriceLV.Text.Trim());
if (billPriceLV > 0)
{
cMBillRequisitionItemMapEntity.BillPrice = Decimal.Parse(txtBillPriceLV.Text.Trim());
}
FCCCMBillRequisitionItemMap.GetFacadeCreate().Add(cMBillRequisitionItemMapEntity, DatabaseOperationType.Add, TransactionRequired.No);
//else
//{
// cMBillRequisitionItemMapEntity.BillPrice = null;
//}
}
}
}
}
catch (Exception ex)
{
}
#endregion
CMBillEntity _cMBillEntity = CurrentCMBillEntity;
_BillID = 0;
_CMBillEntity = new CMBillEntity();
PrepareInitialView();
BindCMBillList();
if (cMBillEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Bill Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Bill Information has been updated successfully.", false);
}
String NavUrl = UrlHelper.BuildSecureUrl("~/CM/CMBillUploadInfo.aspx", string.Empty, UrlConstants.OVERVIEW_CM_BILL_ID, result.ToString()).ToString();
Response.Redirect(NavUrl);
}
else
{
if (cMBillEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Bill Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Bill Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
private void SaveOTIssueEntity()
{
if (IsValid)
{
try
{
OTIssueEntity oTIssueEntity = BuildOTIssueEntity();
Int64 result = -1;
if (oTIssueEntity.IsNew)
{
result = FCCOTIssue.GetFacadeCreate().Add(oTIssueEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(OTIssueEntity.FLD_NAME_IssueID, oTIssueEntity.IssueID.ToString(), SQLMatchType.Equal);
result = FCCOTIssue.GetFacadeCreate().Update(oTIssueEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
if (oTIssueEntity.IsNew)
{
#region Send Notification
String mailSubject = String.Empty;
String mailBody = String.Empty;
String[] mailTo = new String[1];
String fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueID, result.ToString(), SQLMatchType.Equal);
IList <OTIssue_DetailedEntity> lstOTIssueEntity = FCCOTIssue_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe);
if (lstOTIssueEntity != null && lstOTIssueEntity.Count > 0)
{
mailSubject = lstOTIssueEntity[0].Title.ToString() + "-" + lstOTIssueEntity[0].SupervisorFullName;
mailBody = lstOTIssueEntity[0].Description.ToString();
mailBody += "<br/>";
mailBody += "<br/>";
mailBody += "Expected Start Date: " + lstOTIssueEntity[0].ExpectedStartDate.ToString(UIConstants.SHORT_DATE_FORMAT);
mailBody += "<br/>";
mailBody += "Expected End Date: " + lstOTIssueEntity[0].ExpectedEndDate.ToString(UIConstants.SHORT_DATE_FORMAT);
HREmployeeEntity hREmployeeEntitiy = FCCHREmployee.GetFacadeCreate().GetByID(lstOTIssueEntity[0].AssignedToEmployeeID);
if (hREmployeeEntitiy != null && hREmployeeEntitiy.EmployeeID > 0)
{
mailTo[0] = hREmployeeEntitiy.PrimaryEmail;
MiscUtil.SendMail(mailTo, mailSubject, mailBody);
}
}
#endregion
_IssueID = 0;
_OTIssueEntity = new OTIssueEntity();
PrepareInitialView();
MiscUtil.ShowMessage(lblMessage, "Issue Information has been added successfully.", false);
String NavigationUrl = UrlHelper.BuildSecureUrl("~/OT/OTIssueAssignedResource.aspx", string.Empty, UrlConstants.OVERVIEW_ISSUE_ID, result.ToString()).ToString();
Response.Redirect(NavigationUrl);
}
else
{
PrepareInitialView();
PrepareEditView();
MiscUtil.ShowMessage(lblMessage, "Issue Information has been updated successfully.", false);
//String NavigationUrl = UrlHelper.BuildSecureUrl("~/OT/OTIssueAssignedResource.aspx", string.Empty, UrlConstants.OVERVIEW_ISSUE_ID, result.ToString()).ToString();
//Response.Redirect(NavigationUrl);
}
}
else
{
if (oTIssueEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Issue Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Issue Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
PRMBOQTemplateEntity IPRMBOQTemplateFacade.GetByID(Int64 iD)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQTemplateEntity.FLD_NAME_BOQTemplateID, iD.ToString(), SQLMatchType.Equal);
return(DataAccessFactory.CreatePRMBOQTemplateDataAccess().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression)[0]);
}
MDProjectCollectedDocumentStatusEntity IMDProjectCollectedDocumentStatusFacade.GetByID(Int64 iD)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(MDProjectCollectedDocumentStatusEntity.FLD_NAME_ProjectCollectedDocumentStatusID, iD.ToString(), SQLMatchType.Equal);
return(DataAccessFactory.CreateMDProjectCollectedDocumentStatusDataAccess().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression)[0]);
}
private String BuildFilterArgument(String fe)
{
#region One argument
if (ddlProjectID.SelectedValue != "0" && ddlStoreUnitID.SelectedValue == "0" && ddlItemID.SelectedValue == "0")
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("BDProject.ProjectID", ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal);
fe = fe1;
}
if (ddlStoreUnitID.SelectedValue != "0" && ddlProjectID.SelectedValue == "0" && ddlItemID.SelectedValue == "0")
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("INVStoreUnitItem." + INVStoreUnitItem_DetailedEntity.FLD_NAME_StoreUnitID, ddlStoreUnitID.SelectedValue.ToString(), SQLMatchType.Equal);
fe = fe1;
}
if (ddlItemID.SelectedValue != "0" && ddlProjectID.SelectedValue == "0" && ddlStoreUnitID.SelectedValue == "0")
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("INVStoreUnitItem." + INVStoreUnitItem_DetailedEntity.FLD_NAME_ItemID, ddlItemID.SelectedValue.ToString(), SQLMatchType.Equal);
fe = fe1;
}
#endregion
#region Two Arguments
if (ddlProjectID.SelectedValue != "0" && ddlStoreUnitID.SelectedValue != "0" && ddlItemID.SelectedValue == "0")
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("BDProject.ProjectID", ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("INVStoreUnitItem." + INVStoreUnitItem_DetailedEntity.FLD_NAME_StoreUnitID, ddlStoreUnitID.SelectedValue.ToString(), SQLMatchType.Equal);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
}
if (ddlProjectID.SelectedValue != "0" && ddlStoreUnitID.SelectedValue == "0" && ddlItemID.SelectedValue != "0")
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("BDProject.ProjectID", ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("INVStoreUnitItem." + INVStoreUnitItem_DetailedEntity.FLD_NAME_ItemID, ddlItemID.SelectedValue.ToString(), SQLMatchType.Equal);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
}
if (ddlProjectID.SelectedValue == "0" && ddlStoreUnitID.SelectedValue != "0" && ddlItemID.SelectedValue != "0")
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("INVStoreUnitItem." + INVStoreUnitItem_DetailedEntity.FLD_NAME_StoreUnitID, ddlStoreUnitID.SelectedValue.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("INVStoreUnitItem." + INVStoreUnitItem_DetailedEntity.FLD_NAME_ItemID, ddlItemID.SelectedValue.ToString(), SQLMatchType.Equal);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
}
#endregion
#region Three Arguments
if (ddlProjectID.SelectedValue != "0" && ddlStoreUnitID.SelectedValue != "0" && ddlItemID.SelectedValue != "0")
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("INVStoreUnitItem." + INVStoreUnitItem_DetailedEntity.FLD_NAME_StoreUnitID, ddlStoreUnitID.SelectedValue.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("INVStoreUnitItem." + INVStoreUnitItem_DetailedEntity.FLD_NAME_ItemID, ddlItemID.SelectedValue.ToString(), SQLMatchType.Equal);
String fe3 = SqlExpressionBuilder.PrepareFilterExpression("BDProject.ProjectID", ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal);
String fe4 = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe3, SQLJoinType.AND, fe4);
}
#endregion
return(fe);
}
ACCPrePayableStatementEntity IACCPrePayableStatementFacade.GetByID(Int64 iD)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(ACCPrePayableStatementEntity.FLD_NAME_PrePayableStatementID, iD.ToString(), SQLMatchType.Equal);
return(DataAccessFactory.CreateACCPrePayableStatementDataAccess().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression)[0]);
}
protected void lvREQRequisition_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
REQRequisition_DetailedEntity ent = (REQRequisition_DetailedEntity)dataItem.DataItem;
HyperLink hypRequisition = (HyperLink)e.Item.FindControl("hypRequisition");
HyperLink hypEdit = (HyperLink)e.Item.FindControl("lnkBtnEdit");
HyperLink hypRequisitionReport = (HyperLink)e.Item.FindControl("hypRequisitionReport");
HyperLink hypCRMAdRequisitionReport = (HyperLink)e.Item.FindControl("hypCRMAdRequisitionReport");
HyperLink hypRequisitionDetail = (HyperLink)e.Item.FindControl("hypRequisitionDetail");
HyperLink lnkShowApprovalStatus = (HyperLink)e.Item.FindControl("lnkShowApprovalStatus");
Label lblRequisitionItem = (Label)e.Item.FindControl("lblRequisitionItem");
Label lblWorkOrderCreated = (Label)e.Item.FindControl("lblWorkOrderCreated");
if (ent.RequisitionStatusID == MasterDataConstants.RequisitionStatus.MIGRATE_TO_TRF)
{
String fe_TRF = SqlExpressionBuilder.PrepareFilterExpression(INVTransferEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), SQLMatchType.Equal);
IList <INVTransferEntity> iNVTransferEntityList = FCCINVTransfer.GetFacadeCreate().GetIL(null, null, String.Empty, fe_TRF, DatabaseOperationType.LoadWithFilterExpression);
if (iNVTransferEntityList != null && iNVTransferEntityList.Count > 0)
{
Panel pnlTRFNoLV = (Panel)e.Item.FindControl("pnlTRFNoLV");
foreach (INVTransferEntity invTransferEntity in iNVTransferEntityList)
{
HyperLink hypTRFNoLV = new HyperLink();
hypTRFNoLV.Text = iNVTransferEntityList[0].TRFNo;
hypTRFNoLV.NavigateUrl = UrlHelper.BuildSecureUrl("~/INV/INVTransferItem.aspx", string.Empty, UrlConstants.OVERVIEW_TRANSFER_ID, invTransferEntity.TransferID.ToString()).ToString();
hypTRFNoLV.Target = "_blank";
hypTRFNoLV.CssClass = "CommonButtonLink";
pnlTRFNoLV.Controls.Add(hypTRFNoLV);
pnlTRFNoLV.Controls.Add(new LiteralControl("<br/>"));
}
}
}
Boolean IsAdvertisementRequisition = false;
String feReqItem = SqlExpressionBuilder.PrepareFilterExpression("REQRequisitionItem." + REQRequisitionItemEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), SQLMatchType.Equal);
IList <REQRequisitionItem_DetailedEntity> lst = FCCREQRequisitionItem_Detailed.GetFacadeCreate().GetIL(100000, 1, String.Empty, feReqItem);
if (lst != null && lst.Count > 0)
{
foreach (REQRequisitionItem_DetailedEntity entREQRequisitionItem_DetailedEntity in lst)
{
lblRequisitionItem.Text += entREQRequisitionItem_DetailedEntity.MDItemItemName + ", ";
if (entREQRequisitionItem_DetailedEntity.ItemCategoryID == MasterDataConstants.ItemDefaults.DEFAULT_ADVERTIESMENT_ITEM_CATEGORY)
{
IsAdvertisementRequisition = true;
}
}
lblRequisitionItem.Text = lblRequisitionItem.Text.Substring(0, lblRequisitionItem.Text.Length - 2);
}
IList <PRMWorkOrderNoByRequisition_CustomEntity> lstWONO = FCCPRMWorkOrderNoByRequisition_Custom.GetFacadeCreate().GetIL(Int64.Parse(ent.RequisitionID.ToString()));
if (lstWONO != null && lstWONO.Count > 0)
{
lblWorkOrderCreated.Text = lstWONO[0].WorkOrderNo.ToString();
}
String fe_req = SqlExpressionBuilder.PrepareFilterExpression("PRMWorkOrderItemMap." + PRMWorkOrderItemMapEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), SQLMatchType.Equal);
IList <PRMWorkOrderItemMap_DetailedEntity> lstPRMWorkOrderItemMap = FCCPRMWorkOrderItemMap_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_req);
if (lstPRMWorkOrderItemMap != null && lstPRMWorkOrderItemMap.Count > 0)
{
Panel pnlWorkOrderLV = (Panel)e.Item.FindControl("pnlWorkOrderLV");
List <PRMWorkOrderItemMap_DetailedEntity> distinct =
lstPRMWorkOrderItemMap
.GroupBy(car => car.WorkOrderID)
.Select(g => g.First())
.ToList();
foreach (PRMWorkOrderItemMap_DetailedEntity pRMWorkOrderItemMapEntity in distinct)
{
HyperLink hypWorkOrder = new HyperLink();
hypWorkOrder.Text = pRMWorkOrderItemMapEntity.WorkOrderNo.ToString();
hypWorkOrder.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.WORK_ORDER_REPORT, UrlConstants.OVERVIEW_WORKORDER_ID, pRMWorkOrderItemMapEntity.WorkOrderID.ToString()).ToString();
hypWorkOrder.Target = "_blank";
hypWorkOrder.CssClass = "CommonButtonLink";
pnlWorkOrderLV.Controls.Add(hypWorkOrder);
pnlWorkOrderLV.Controls.Add(new LiteralControl("<br/>"));
String fe_mrr = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveEntity.FLD_NAME_WorkOrderID, pRMWorkOrderItemMapEntity.WorkOrderID.ToString(), SQLMatchType.Equal);
IList <PRMMaterialReceiveEntity> lstPRMMaterialReceive = FCCPRMMaterialReceive.GetFacadeCreate().GetIL(null, null, String.Empty, fe_mrr, DatabaseOperationType.LoadWithFilterExpression);
if (lstPRMMaterialReceive != null && lstPRMMaterialReceive.Count > 0)
{
Panel pnlMRRLV = (Panel)e.Item.FindControl("pnlMRRLV");
foreach (PRMMaterialReceiveEntity pRMMaterialReceiveEntity in lstPRMMaterialReceive)
{
HyperLink hypMaterialReceive = new HyperLink();
hypMaterialReceive.Text = pRMMaterialReceiveEntity.MRRNo;
hypMaterialReceive.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", "MaterialReceiveReport", UrlConstants.OVERVIEW_MATERIAL_RECEIVE_ID, pRMMaterialReceiveEntity.MaterialReceiveID.ToString()).ToString();
hypMaterialReceive.Target = "_blank";
hypMaterialReceive.CssClass = "CommonButtonLink";
pnlMRRLV.Controls.Add(hypMaterialReceive);
pnlMRRLV.Controls.Add(new LiteralControl("<br/>"));
}
}
}
}
if (ent.RequisitionStatusID == MasterDataConstants.RequisitionStatus.APPROVED ||
ent.RequisitionStatusID == MasterDataConstants.RequisitionStatus.MIGRATE_TO_TRF)
{
hypEdit.Visible = false;
}
String NavigationUrl = String.Empty;
NavigationUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", "RequisitionReport", UrlConstants.REQUISITION_ID, ent.RequisitionID.ToString()).ToString();
if (IsAdvertisementRequisition)
{
NavigationUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.CRM_AD_REQUISITION_REPORT, UrlConstants.REQUISITION_ID, ent.RequisitionID.ToString()).ToString();
}
hypRequisitionReport.NavigateUrl = NavigationUrl;
hypRequisitionReport.Target = "_blank";
hypEdit.NavigateUrl = UrlHelper.BuildSecureUrl("~/REQ/REQRequisition.aspx", string.Empty, "do", "Edit", UrlConstants.REQUISITION_ID, ent.RequisitionID.ToString()).ToString();
if (this.OverviewProjectID > 0)
{
hypRequisition.NavigateUrl = UrlHelper.BuildSecureUrl("~/BD/BDProjectRequisitionItem.aspx", string.Empty, UrlConstants.OVERVIEW_PROJECT_ID, this.OverviewProjectID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionNo, ent.RequisitionNo.ToString()).ToString();
}
else
{
hypRequisition.NavigateUrl = UrlHelper.BuildSecureUrl("~/REQ/REQRequisitionItem.aspx", string.Empty, UrlConstants.OVERVIEW_PROJECT_ID, this.OverviewProjectID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionNo, ent.RequisitionNo.ToString()).ToString();
hypRequisitionDetail.NavigateUrl = UrlHelper.BuildSecureUrl("~/Site/REQRequisitionItemView.aspx", string.Empty, UrlConstants.OVERVIEW_PROJECT_ID, this.OverviewProjectID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionID, ent.RequisitionID.ToString(), REQRequisitionEntity.FLD_NAME_RequisitionNo, ent.RequisitionNo.ToString()).ToString();
}
APApprovalProcessEntity aPApprovalProcessEntity = APRobot.GetApprovalProcessByTypeAndReference(MasterDataConstants.APType.REQUISITION, ent.RequisitionID);
if (aPApprovalProcessEntity.APApprovalProcessID > 0)
{
lnkShowApprovalStatus.NavigateUrl = UrlHelper.BuildSecureUrl(
"~/AP/APView.aspx",
string.Empty,
APApprovalProcessEntity.FLD_NAME_APApprovalProcessID,
aPApprovalProcessEntity.APApprovalProcessID.ToString()
).ToString();
lnkShowApprovalStatus.Target = "_blank";
}
else
{
lnkShowApprovalStatus.NavigateUrl = String.Empty;
lnkShowApprovalStatus.Enabled = false;
}
hypEdit.Target = "_blank";
hypRequisitionReport.Target = "_blank";
hypRequisitionDetail.Target = "_blank";
}
}
protected void odsActivityLog_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(ActivityLogEntity.FLD_NAME_UserId, Overview_aspnetUserID.ToString(), SQLMatchType.Equal);
e.InputParameters["filterExpression"] = fe;
}
protected void btnMakePayment_Click(object sender, EventArgs e)
{
try
{
IList <ListViewDataItem> list = lvACCPrePayableStatementDetail.Items;
if (list != null && list.Count > 0)
{
Int32 tempDataItemIndex = 0;
foreach (ListViewDataItem lvdi in list)
{
DataKey currentDataKey = lvACCPrePayableStatementDetail.DataKeys[tempDataItemIndex++];
Int64 _postPayableStatementDetailID = (Int64)currentDataKey["PostPayableStatementDetailID"];
_PostPayableStatementDetailID = _postPayableStatementDetailID;
}
}
}
catch (Exception ex)
{
}
if (_PostPayableStatementDetailID > 0)
{
ACCPostPayableStatementDetailEntity aCCPostPayableStatementDetailEntity = CurrentACCPostPayableStatementDetailEntity;
if (aCCPostPayableStatementDetailEntity != null && aCCPostPayableStatementDetailEntity.PostPayableStatementDetailID > 0)
{
txtAmount.Text = aCCPostPayableStatementDetailEntity.NetPayableConsideringBillAndSecurity.ToString();
PRMSupplierEntity pRMSupplierEntity = FCCPRMSupplier.GetFacadeCreate().GetByID(aCCPostPayableStatementDetailEntity.FromVendorID);
String compositeID = String.Empty;
Int64 accountID = 0;
if (pRMSupplierEntity != null && pRMSupplierEntity.SupplierID > 0)
{
Int64 referenceID, resourceCategoryID = 0;
referenceID = pRMSupplierEntity.SupplierID;
switch (pRMSupplierEntity.SupplierTypeID)
{
case MasterDataConstants.MDSupplierType.LOCAL:
case MasterDataConstants.MDSupplierType.IMPORTER:
case MasterDataConstants.MDSupplierType.LOCAL_AND_IMPORTER:
resourceCategoryID = MasterDataConstants.ACMDAccountResourceCategory.VENDOR;
break;
case MasterDataConstants.MDSupplierType.CONTRACTOR:
resourceCategoryID = MasterDataConstants.ACMDAccountResourceCategory.CONTRACTOR;
break;
case MasterDataConstants.MDSupplierType.CONSULTANT:
resourceCategoryID = MasterDataConstants.ACMDAccountResourceCategory.CONSULTANT;
break;
}
if (referenceID > 0 && resourceCategoryID > 0)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression(ACAccountResourceAccountMapEntity.FLD_NAME_AccountResourceCategoryID, resourceCategoryID.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression(ACAccountResourceAccountMapEntity.FLD_NAME_ReferenceID, referenceID.ToString(), SQLMatchType.Equal);
String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
IList <ACAccountResourceAccountMapEntity> lst = FCCACAccountResourceAccountMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
if (lst != null && lst.Count > 0)
{
foreach (ACAccountResourceAccountMapEntity ent in lst)
{
compositeID += ent.ReferenceID + ",";
accountID = ent.AccountID;
}
compositeID = compositeID.Substring(0, compositeID.Length - 1);
}
}
}
MiscUtil.PopulateACAccountByAccountGroupByReference(ddlACCAccountID, false, compositeID);
if (ddlACCAccountID != null && ddlACCAccountID.Items.Count > 0)
{
//ddlACCAccountID.SelectedValue = accountID.ToString();
}
}
}
this.Panel1_ModalPopupExtender.Show();
}
protected void odsCMConsultantAssignedWorkArea_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression("CMConsultantAssignedWorkArea." + CMConsultantAssignedWorkAreaEntity.FLD_NAME_ConsultantID, this.OverviewConsultantID.ToString(), SQLMatchType.Equal);
e.InputParameters["filterExpression"] = fe;
}
private void UpdatePayableStatementDetail()
{
try
{
IList <ListViewDataItem> list = lvACCPrePayableStatementDetail.Items;
if (list != null && list.Count > 0)
{
Int32 tempDataItemIndex = 0;
foreach (ListViewDataItem lvdi in list)
{
DataKey currentDataKey = lvACCPrePayableStatementDetail.DataKeys[tempDataItemIndex++];
Int64 _postPayableStatementDetailID = (Int64)currentDataKey["PostPayableStatementDetailID"];
// Decimal workOrderAgreementAmount = 0, paidAmount = 0, tDSAmount = 0, securityMoney = 0;
ACCPostPayableStatementDetailEntity aCCPrePayableStatementDetailEntity = FCCACCPostPayableStatementDetail.GetFacadeCreate().GetByID(_postPayableStatementDetailID);
DropDownList ddlACCPayableApprovalStatusIDLV = (DropDownList)lvdi.FindControl("ddlACCPayableApprovalStatusIDLV");
DropDownList ddlACCPayablePaymentStatusIDLV = (DropDownList)lvdi.FindControl("ddlACCPayablePaymentStatusIDLV");
DropDownList ddlAccountPaybleStatementDetailCategoryIDLV = (DropDownList)lvdi.FindControl("ddlAccountPaybleStatementDetailCategoryIDLV");
DropDownList ddlPayableClassificationIDLV = (DropDownList)lvdi.FindControl("ddlPayableClassificationIDLV");
CheckBox chkPartyReconcileLV = (CheckBox)lvdi.FindControl("chkPartyReconcileLV");
//L lblWorkOrderNoLV = (TextBox)lvdi.FindControl("lblWorkOrderNoLV");
//TextBox txtWorkOrderAmountLV = (TextBox)lvdi.FindControl("txtWorkOrderAmountLV");
//TextBox txtWorkOrderDateLV = (TextBox)lvdi.FindControl("txtWorkOrderDateLV");
//TextBox txtPaidAmountLV = (TextBox)lvdi.FindControl("txtPaidAmountLV");
//TextBox txtSecurityMoneyLV = (TextBox)lvdi.FindControl("txtSecurityMoneyLV");
TextBox txtPayableAgainstWorkOrderLV = (TextBox)lvdi.FindControl("txtPayableAgainstWorkOrderLV");
//TextBox txtTDSAmountLV = (TextBox)lvdi.FindControl("txtTDSAmountLV");
//TextBox txtApprovedBillAmountLV = (TextBox)lvdi.FindControl("txtApprovedBillAmountLV");
TextBox txtNetPayableConsideringBillAndSecurityLV = (TextBox)lvdi.FindControl("txtNetPayableConsideringBillAndSecurityLV");
//TextBox txtRequisitionNoLV = (TextBox)lvdi.FindControl("txtRequisitionNoLV");
//TextBox txtRequisitionDateLV = (TextBox)lvdi.FindControl("txtRequisitionDateLV");
// TextBox txtBillNoLV = (TextBox)lvdi.FindControl("txtBillNoLV");
//TextBox txtBillDateLV = (TextBox)lvdi.FindControl("txtBillDateLV");
//TextBox txtRefLV = (TextBox)lvdi.FindControl("txtRefLV");
//TextBox txtCreateDateLV = (TextBox)lvdi.FindControl("txtCreateDateLV");
TextBox txtDueDateLV = (TextBox)lvdi.FindControl("txtDueDateLV");
TextBox txtPlannedDateLV = (TextBox)lvdi.FindControl("txtPlannedDateLV");
TextBox txtRemarksLV = (TextBox)lvdi.FindControl("txtRemarksLV");
//TextBox txtAdditionalRemarksLV = (TextBox)lvdi.FindControl("txtAdditionalRemarksLV");
//if (!lblWorkOrderNoLV.Text.Trim().IsNullOrEmpty())
//{
// aCCPrePayableStatementDetailEntity.WorkOrderNo = lblWorkOrderNoLV.Text.Trim();
//}
//else
//{
// aCCPrePayableStatementDetailEntity.WorkOrderNo = null;
//}
//Decimal payableAgainstWO = (workOrderAgreementAmount - paidAmount - tDSAmount);
//Decimal netPayableConsideringBillSecurity = (payableAgainstWO - paidAmount - securityMoney - tDSAmount);
//if (!txtWorkOrderAmountLV.Text.Trim().IsNullOrEmpty())
//{
// aCCPrePayableStatementDetailEntity.WorkOrderAmount = Decimal.Parse(txtWorkOrderAmountLV.Text.Trim());
//}
//else
//{
// aCCPrePayableStatementDetailEntity.WorkOrderAmount = null;
//}
//if (txtWorkOrderDateLV.Text.Trim().IsNotNullOrEmpty())
//{
// aCCPrePayableStatementDetailEntity.WorkOrderDate = MiscUtil.ParseToDateTime(txtWorkOrderDateLV.Text);
//}
//else
//{
// aCCPrePayableStatementDetailEntity.WorkOrderDate = null;
//}
//if (!txtPaidAmountLV.Text.Trim().IsNullOrEmpty())
//{
// aCCPrePayableStatementDetailEntity.PaidAmount = Decimal.Parse(txtPaidAmountLV.Text.Trim());
//}
//else
//{
// aCCPrePayableStatementDetailEntity.PaidAmount = null;
//}
//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 (!txtApprovedBillAmountLV.Text.Trim().IsNullOrEmpty())
//{
// aCCPrePayableStatementDetailEntity.ApprovedBillAmount = Decimal.Parse(txtApprovedBillAmountLV.Text.Trim());
//}
//else
//{
// aCCPrePayableStatementDetailEntity.ApprovedBillAmount = null;
//}
if (!txtNetPayableConsideringBillAndSecurityLV.Text.Trim().IsNullOrEmpty())
{
aCCPrePayableStatementDetailEntity.NetPayableConsideringBillAndSecurity = Decimal.Parse(txtNetPayableConsideringBillAndSecurityLV.Text.Trim());
}
else
{
aCCPrePayableStatementDetailEntity.NetPayableConsideringBillAndSecurity = null;
}
aCCPrePayableStatementDetailEntity.PartyReconcile = chkPartyReconcileLV.Checked;
//aCCPrePayableStatementDetailEntity.RequisitionNo = txtRequisitionNoLV.Text.Trim();
//if (txtRequisitionDateLV.Text.Trim().IsNotNullOrEmpty())
//{
// aCCPrePayableStatementDetailEntity.RequisitionDate = MiscUtil.ParseToDateTime(txtRequisitionDateLV.Text);
//}
//else
//{
// aCCPrePayableStatementDetailEntity.RequisitionDate = null;
//}
//aCCPrePayableStatementDetailEntity.BillNo = txtBillNoLV.Text.Trim();
//if (txtBillDateLV.Text.Trim().IsNotNullOrEmpty())
//{
// aCCPrePayableStatementDetailEntity.BillDate = MiscUtil.ParseToDateTime(txtBillDateLV.Text);
//}
//else
//{
// aCCPrePayableStatementDetailEntity.BillDate = null;
//}
aCCPrePayableStatementDetailEntity.Remarks = txtRemarksLV.Text.Trim();
// aCCPrePayableStatementDetailEntity.Ref = txtRemarksLV.Text.Trim();
//if (txtCreateDateLV.Text.Trim().IsNotNullOrEmpty())
//{
// aCCPrePayableStatementDetailEntity.CreateDate = MiscUtil.ParseToDateTime(txtCreateDateLV.Text);
//}
aCCPrePayableStatementDetailEntity.CreateDate = System.DateTime.Now;
if (txtDueDateLV.Text.Trim().IsNotNullOrEmpty())
{
aCCPrePayableStatementDetailEntity.DueDate = MiscUtil.ParseToDateTime(txtDueDateLV.Text);
}
if (txtPlannedDateLV.Text.Trim().IsNotNullOrEmpty())
{
aCCPrePayableStatementDetailEntity.PlannedDate = MiscUtil.ParseToDateTime(txtPlannedDateLV.Text);
}
else
{
aCCPrePayableStatementDetailEntity.PlannedDate = null;
}
// aCCPrePayableStatementDetailEntity.AdditionalRemarks = txtAdditionalRemarksLV.Text.Trim();
if (ddlACCPayablePaymentStatusIDLV.Items.Count > 0)
{
if (ddlACCPayablePaymentStatusIDLV.SelectedValue == "0")
{
}
else
{
aCCPrePayableStatementDetailEntity.ACCPayablePaymentStatusID = Int64.Parse(ddlACCPayablePaymentStatusIDLV.SelectedValue);
}
}
if (ddlACCPayableApprovalStatusIDLV.Items.Count > 0)
{
if (ddlACCPayableApprovalStatusIDLV.SelectedValue == "0")
{
}
else
{
aCCPrePayableStatementDetailEntity.ACCPayableApprovalStatusID = Int64.Parse(ddlACCPayableApprovalStatusIDLV.SelectedValue);
}
}
if (ddlAccountPaybleStatementDetailCategoryIDLV.Items.Count > 0)
{
if (ddlAccountPaybleStatementDetailCategoryIDLV.SelectedValue == "0")
{
}
else
{
aCCPrePayableStatementDetailEntity.AccountPaybleStatementDetailCategoryID = Int64.Parse(ddlAccountPaybleStatementDetailCategoryIDLV.SelectedValue);
}
}
if (ddlPayableClassificationIDLV.Items.Count > 0)
{
if (ddlPayableClassificationIDLV.SelectedValue == "0")
{
}
else
{
aCCPrePayableStatementDetailEntity.PayableClassificationID = Int64.Parse(ddlPayableClassificationIDLV.SelectedValue);
}
}
aCCPrePayableStatementDetailEntity.CreateByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
aCCPrePayableStatementDetailEntity.IPAddress = MiscUtil.GetLocalIP();
aCCPrePayableStatementDetailEntity.IsRemoved = false;
aCCPrePayableStatementDetailEntity.IsLocked = false;
String fe_member = SqlExpressionBuilder.PrepareFilterExpression(ACCPostPayableStatementDetailEntity.FLD_NAME_PostPayableStatementDetailID, _postPayableStatementDetailID.ToString(), SQLMatchType.Equal);
FCCACCPostPayableStatementDetail.GetFacadeCreate().Update(aCCPrePayableStatementDetailEntity, fe_member, DatabaseOperationType.Update, TransactionRequired.No);
}
PrepareInitialView();
MiscUtil.ShowMessage(lblMessage, "Accounts Payable Information has been saved successfully.", false);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, "Failed to Save Accounts Payable Information.", true);
}
}
long IASUserPermissionExcludedFacade.Delete(ASUserPermissionExcludedEntity asuserpermissionexcluded)
{
return((this as IASUserPermissionExcludedFacade).Delete(asuserpermissionexcluded, SqlExpressionBuilder.PrepareFilterExpression(ASUserPermissionExcludedEntity.FLD_NAME_ASUserPermissionExcludedID, asuserpermissionexcluded.ASUserPermissionExcludedID.ToString(), SQLMatchType.Equal), DatabaseOperationType.Delete, TransactionRequired.No));
}
IList <ASUserPermissionExcludedEntity> IASUserPermissionExcludedFacade.GetByUserName(string username)
{
IList <ASUserPermissionExcludedEntity> allobjects = null;
allobjects = (this as IASUserPermissionExcludedFacade).GetIL(null, null, null, SqlExpressionBuilder.PrepareFilterExpression(ASUserPermissionExcludedEntity.FLD_NAME_ASUserName, username, SQLMatchType.Equal), DatabaseOperationType.LoadWithFilterExpression);
if (allobjects == null)
{
allobjects = new List <ASUserPermissionExcludedEntity>();
}
return(allobjects);
}
MDItemCategoryEntity IMDItemCategoryFacade.GetByID(Int64 iD)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(MDItemCategoryEntity.FLD_NAME_ItemCategoryID, iD.ToString(), SQLMatchType.Equal);
return(DataAccessFactory.CreateMDItemCategoryDataAccess().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression)[0]);
}
protected void odsREQRequisition_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe = String.Empty;
if (this.OverviewProjectID > 0)
{
fe = SqlExpressionBuilder.PrepareFilterExpression("REQRequisition." + REQRequisitionEntity.FLD_NAME_ProjectID, this.OverviewProjectID.ToString(), SQLMatchType.Equal);
}
else
{
fe = "REQRequisition." + REQRequisitionEntity.FLD_NAME_ProjectID + "<> " + "4545454545";
}
if (PageListType == "RCSRequisitionList")
{
String fe1 = "REQRequisition.IsRCS = 1";
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe1);
}
if (chbxFilter.Checked)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("REQRequisition.RequisitionNo", txtSearchText.Text.ToString(), SQLMatchType.LikeWithBothMath);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("MDRequisitionStatus.Name", txtSearchText.Text.ToString(), SQLMatchType.LikeWithSuffixMath);
String fe3 = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.OR, fe2);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe3);
if (txtSearchText.Text.Trim().IsNotNullOrEmpty())
{
// Activity Log
// base.LogActivity("Searching Requisition With " + txtSearchText.Text.Trim().ToString(), true);
}
}
if (chbxShowLogedinApprovedRequisition.Checked)
{
Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
String compositeRequisitionID = String.Empty;
if (employeeID > 0)
{
IList <APApprovedRequisitionForWOByPanelMember_CustomEntity> lst = FCCAPApprovedRequisitionForWOByPanelMember_Custom.GetFacadeCreate().GetIL(employeeID);
if (lst != null && lst.Count > 0)
{
foreach (APApprovedRequisitionForWOByPanelMember_CustomEntity ent in lst)
{
compositeRequisitionID += ent.ReferenceID + ",";
}
compositeRequisitionID = compositeRequisitionID.Substring(0, compositeRequisitionID.Length - 1);
}
}
String fe_panelWO = "REQRequisition.RequisitionID in(" + compositeRequisitionID + ")";
String fe_approved = SqlExpressionBuilder.PrepareFilterExpression("REQRequisition." + REQRequisitionEntity.FLD_NAME_RequisitionStatusID, MasterDataConstants.RequisitionStatus.APPROVED.ToString(), SQLMatchType.Equal);
String fe_all = SqlExpressionBuilder.PrepareFilterExpression(fe_approved, SQLJoinType.AND, fe_panelWO);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe_all);
}
if (this.Page.User.Identity.IsAuthenticated == true)
{
if (Roles.IsUserInRole(this.Page.User.Identity.Name, "SiteUser") == true)
{
String fe_assignedPerson1 = SqlExpressionBuilder.PrepareFilterExpression(BDProjectAssignedPersonEntity.FLD_NAME_EmployeeID, MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString(), SQLMatchType.Equal);
String fe_assignedPerson2 = SqlExpressionBuilder.PrepareFilterExpression(BDProjectAssignedPersonEntity.FLD_NAME_ProjectAssignedPersonTeamRoleID, MasterDataConstants.ProjectAssignedTeamRole.SITE_INCHARGE.ToString(), SQLMatchType.Equal);
String fe_assignedPerson = SqlExpressionBuilder.PrepareFilterExpression(fe_assignedPerson1, SQLJoinType.AND, fe_assignedPerson2);
IList <BDProjectAssignedPersonEntity> lst = FCCBDProjectAssignedPerson.GetFacadeCreate().GetIL(null, null, String.Empty, fe_assignedPerson, DatabaseOperationType.LoadWithFilterExpression);
if (lst != null && lst.Count > 0)
{
String compositeProjectID = String.Empty;
foreach (BDProjectAssignedPersonEntity ent in lst)
{
compositeProjectID += ent.ProjectID + ",";
}
compositeProjectID = compositeProjectID.Substring(0, compositeProjectID.Length - 1);
String fe1 = "REQRequisition.ProjectID In(" + compositeProjectID + ")";
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe1);
}
}
else if (Roles.IsUserInRole(this.Page.User.Identity.Name, "Store Keeper") == true)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("REQRequisition." + REQRequisitionEntity.FLD_NAME_PreparedByMemberID, this.CurrentMember.MemberID.ToString(), SQLMatchType.Equal);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe1);
}
}
e.InputParameters["filterExpression"] = fe;
}
private void PrepareInitialView()
{
BuildDropDownList();
//String se = SqlExpressionBuilder.PrepareSortExpression(PRMWorkOrderEntity.FLD_NAME_WorkOrderID, SQLSortOrderType.Decending);
//IList<PRMWorkOrderEntity> workOrderList = FCCPRMWorkOrder.GetFacadeCreate().GetIL(null, null, se, String.Empty, DatabaseOperationType.LoadWithSortExpression);
//Int64 workOrderNo = 0;
//if (workOrderList != null && workOrderList.Count > 0)
//{
// workOrderNo = (from c in workOrderList
// select Convert.ToInt64(c.WorkOrderNo)).Max() + 1;
// txtWorkOrderNo.Text = workOrderNo.ToString();
//}
//else
//{
// //Put The Start Project Code Here.
// txtWorkOrderNo.Text = "00001";
//}
txtWorkOrderNo.Text = MasterDataConstants.AutoAssigned.DEFAULT_AUTO_ASSIGNED;
txtOtherAttention.Text = String.Empty;
txtCreateDate.Text = DateTime.Now.ToString(UIConstants.SHORT_DATE_FORMAT);
txtSubject.Text = String.Empty;
txtBodyTitle.Text = String.Empty;
txtStartDate.Text = System.DateTime.Now.ToString("dd-MM-yyyy");
txtCompletionDate.Text = System.DateTime.Now.AddDays(7).ToString("dd-MM-yyyy");
txtWarranty.Text = "N/A";
txtDelayCharge.Text = "N/A";
txtRowText.Text = String.Empty;
txtRemarks.Text = "N/A";
txtFootNote.Text = "TDS will be deducted as per government rule.";
hypWorkOrderItemMap.Visible = false;
hypWorkOrderPaymentTerm.Visible = false;
txtAIT.Text = "0";
txtCarryingCharge.Text = "0";
txtDiscount.Text = "0";
txtVAT.Text = "0";
txtTax.Text = "0";
txtGrandTotal.Text = String.Empty;
btnSubmit.Text = "Save & Next";
btnAddNew.Visible = false;
Int64 workOrderID = 0;
if (!StringHelper.IsBlank(Helper.Url.SecureUrl[UrlConstants.OVERVIEW_WORKORDER_ID]))
{
Int64.TryParse(Helper.Url.SecureUrl[UrlConstants.OVERVIEW_WORKORDER_ID], out workOrderID);
_WorkOrderID = workOrderID;
BuildLabel(workOrderID);
}
// pnlOtherAttention.Visible = false;
if (ddlPreparedByID != null && ddlPreparedByID.Items.Count > 0)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeEntity.FLD_NAME_MemberID, this.CurrentMember.MemberID.ToString(), SQLMatchType.Equal);
IList <HREmployeeEntity> lstEmployee = FCCHREmployee.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
if (lstEmployee != null && lstEmployee.Count > 0)
{
ddlPreparedByID.SelectedValue = lstEmployee[0].EmployeeID.ToString();
}
}
}
CMConsultantEnlistedWorkAreaEntity ICMConsultantEnlistedWorkAreaFacade.GetByID(Int64 iD)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(CMConsultantEnlistedWorkAreaEntity.FLD_NAME_ConsultantEnlistedWorkAreaID, iD.ToString(), SQLMatchType.Equal);
return(DataAccessFactory.CreateCMConsultantEnlistedWorkAreaDataAccess().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression)[0]);
}
