public IList <CMBillEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression)
{
IList <CMBillEntity> cMBillEntityList = new List <CMBillEntity>();
try
{
if (pageSize == -1)
{
pageSize = 1000000000;
}
if (String.IsNullOrEmpty(sortExpression))
{
sortExpression = CMBillEntity.FLD_NAME_BillID + " " + SQLConstants.SORT_ORDER_DESCENDING;
}
startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1;
cMBillEntityList = FCCCMBill.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression);
if (cMBillEntityList != null && cMBillEntityList.Count > 0)
{
totalRowCount = cMBillEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(cMBillEntityList ?? new List <CMBillEntity>());
}
protected void lvCMBill_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 BillID;
Int64.TryParse(e.CommandArgument.ToString(), out BillID);
if (BillID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_BillID = BillID;
PrepareEditView();
if (CurrentCMBillEntity != null)
{
if (CurrentCMBillEntity.BillApprovalStatusID != MasterDataConstants.BillApprovalStatus.INITIATED)
{
}
}
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(CMBillEntity.FLD_NAME_BillID, BillID.ToString(), SQLMatchType.Equal);
CMBillEntity cMBillEntity = new CMBillEntity();
result = FCCCMBill.GetFacadeCreate().Delete(cMBillEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_BillID = 0;
_CMBillEntity = new CMBillEntity();
PrepareInitialView();
BindCMBillList();
MiscUtil.ShowMessage(lblMessage, "Bill has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Bill.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
protected void lvCMBill_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 BillID;
Int64.TryParse(e.CommandArgument.ToString(), out BillID);
if (BillID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_BillID = BillID;
String url = UrlHelper.BuildSecureUrl("~/CM/CMBill.aspx", string.Empty, UrlConstants.OVERVIEW_CM_BILL_ID, BillID.ToString()).ToString();
Response.Redirect(url);
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(CMBillEntity.FLD_NAME_BillID, BillID.ToString(), SQLMatchType.Equal);
CMBillEntity cMBillEntity = new CMBillEntity();
result = FCCCMBill.GetFacadeCreate().Delete(cMBillEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_BillID = 0;
_CMBillEntity = new CMBillEntity();
BindCMBillList();
MiscUtil.ShowMessage(lblMessage, "C MBill has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete C MBill.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
public IList <CMBillEntity> GetData()
{
IList <CMBillEntity> cMBillEntityList = new List <CMBillEntity>();
try
{
cMBillEntityList = FCCCMBill.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load);
if (cMBillEntityList != null && cMBillEntityList.Count > 0)
{
totalRowCount = cMBillEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(cMBillEntityList ?? new List <CMBillEntity>());
}
protected void lvPRMWorkOrder_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
PRMWorkOrder_DetailedEntity ent = (PRMWorkOrder_DetailedEntity)dataItem.DataItem;
HyperLink hypWorkOrderFloorwiseReport = (HyperLink)e.Item.FindControl("hypWorkOrderFloorwiseReport");
HyperLink hypWorkOrderNo = (HyperLink)e.Item.FindControl("hypWorkOrderNo");
HyperLink hypWorkOrderReport = (HyperLink)e.Item.FindControl("hypWorkOrderReport");
HyperLink hypWorkOrderAnnexureReport = (HyperLink)e.Item.FindControl("hypWorkOrderAnnexureReport");
HyperLink hypWorkOrderPaymentTerm = (HyperLink)e.Item.FindControl("hypWorkOrderPaymentTerm");
HyperLink lnkShowApprovalStatus = (HyperLink)e.Item.FindControl("lnkShowApprovalStatus");
LinkButton lnkBtnEdit = (LinkButton)e.Item.FindControl("lnkBtnEdit");
Button btnResetWorkOrderLV = (Button)e.Item.FindControl("btnResetWorkOrderLV");
hypWorkOrderPaymentTerm.NavigateUrl = UrlHelper.BuildSecureUrl("~/PRM/PRMWorkOrderPaymentTerm.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, ent.WorkOrderID.ToString(), PRMWorkOrderEntity.FLD_NAME_WorkOrderNo, ent.WorkOrderNo).ToString();
hypWorkOrderNo.NavigateUrl = UrlHelper.BuildSecureUrl("~/PRM/PRMWorkOrderItemMap.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, ent.WorkOrderID.ToString(), PRMWorkOrderEntity.FLD_NAME_WorkOrderNo, ent.WorkOrderNo).ToString();
hypWorkOrderReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.WORK_ORDER_REPORT, UrlConstants.OVERVIEW_WORKORDER_ID, ent.WorkOrderID.ToString()).ToString();
hypWorkOrderAnnexureReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.WORK_ORDER_REPORT_WITH_ANNEXURE, UrlConstants.OVERVIEW_WORKORDER_ID, ent.WorkOrderID.ToString()).ToString();
hypWorkOrderFloorwiseReport.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.WORK_ORDER_ITEM_FLOOR_DETAIL, UrlConstants.OVERVIEW_WORKORDER_ID, ent.WorkOrderID.ToString()).ToString();
APApprovalProcessEntity aPApprovalProcessEntity = APRobot.GetApprovalProcessByTypeAndReference(MasterDataConstants.APType.WORK_ORDER, ent.WorkOrderID);
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;
}
if (ent.WorkOrderStatusID == MasterDataConstants.WorkOrderStatus.APPROVED ||
ent.WorkOrderStatusID == MasterDataConstants.WorkOrderStatus.IN_APPROVE_PROCESS)
{
lnkBtnEdit.Visible = false;
hypWorkOrderNo.NavigateUrl = String.Empty;
hypWorkOrderPaymentTerm.NavigateUrl = String.Empty;
}
Panel pnlRequisitonNoLV = (Panel)e.Item.FindControl("pnlRequisitonNoLV");
Panel pnlMRRNoLV = (Panel)e.Item.FindControl("pnlMRRNoLV");
Panel pnlBillLV = (Panel)e.Item.FindControl("pnlBillLV");
if (ent.WorkOrderStatusID == MasterDataConstants.WorkOrderStatus.APPROVED ||
ent.WorkOrderStatusID == MasterDataConstants.WorkOrderStatus.CANCELED)
{
btnResetWorkOrderLV.Visible = true;
}
else
{
btnResetWorkOrderLV.Visible = false;
}
String fe_mrr = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveEntity.FLD_NAME_WorkOrderID, ent.WorkOrderID.ToString(), SQLMatchType.Equal);
IList <PRMMaterialReceiveEntity> lstPRMMaterialReceive = FCCPRMMaterialReceive.GetFacadeCreate().GetIL(null, null, String.Empty, fe_mrr, DatabaseOperationType.LoadWithFilterExpression);
if (lstPRMMaterialReceive != null && lstPRMMaterialReceive.Count > 0)
{
btnResetWorkOrderLV.Visible = false;
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";
pnlMRRNoLV.Controls.Add(hypMaterialReceive);
pnlMRRNoLV.Controls.Add(new LiteralControl("<br/>"));
}
}
String fe_req = SqlExpressionBuilder.PrepareFilterExpression("PRMWorkOrderItemMap." + PRMWorkOrderItemMapEntity.FLD_NAME_WorkOrderID, ent.WorkOrderID.ToString(), SQLMatchType.Equal);
IList <PRMWorkOrderItemMap_DetailedEntity> lstPRMWorkOrderItemMap = FCCPRMWorkOrderItemMap_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_req);
if (lstPRMWorkOrderItemMap != null && lstPRMWorkOrderItemMap.Count > 0)
{
List <PRMWorkOrderItemMap_DetailedEntity> distinct =
lstPRMWorkOrderItemMap
.GroupBy(car => car.WorkOrderID)
.Select(g => g.First())
.ToList();
foreach (PRMWorkOrderItemMap_DetailedEntity pRMWorkOrderItemMapEntity in distinct)
{
HyperLink hypRequisitionNo = new HyperLink();
hypRequisitionNo.Text = pRMWorkOrderItemMapEntity.RequisitionNo.ToString();
hypRequisitionNo.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.REQUISITION_REPORT, UrlConstants.REQUISITION_ID, pRMWorkOrderItemMapEntity.RequisitionID.ToString()).ToString();
hypRequisitionNo.Target = "_blank";
hypRequisitionNo.CssClass = "CommonButtonLink";
pnlRequisitonNoLV.Controls.Add(hypRequisitionNo);
pnlRequisitonNoLV.Controls.Add(new LiteralControl("<br/>"));
}
}
String fe_bill = SqlExpressionBuilder.PrepareFilterExpression(CMBillEntity.FLD_NAME_WorkOrderID, ent.WorkOrderID.ToString(), SQLMatchType.Equal);
IList <CMBillEntity> lstBill = FCCCMBill.GetFacadeCreate().GetIL(null, null, String.Empty, fe_bill, DatabaseOperationType.LoadWithFilterExpression);
if (lstBill != null && lstBill.Count > 0)
{
btnResetWorkOrderLV.Visible = false;
foreach (CMBillEntity cMBillEntity in lstBill)
{
HyperLink hypBill = new HyperLink();
hypBill.Text = cMBillEntity.BillNo.ToString();
//hypBill.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.REQUISITION_REPORT, UrlConstants.REQUISITION_ID, pRMWorkOrderItemMapEntity.RequisitionID.ToString()).ToString();
hypBill.NavigateUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", ReportConstants.BILL_REPORT, UrlConstants.OVERVIEW_CM_BILL_ID, cMBillEntity.BillID.ToString()).ToString();
hypBill.Target = "_blank";
hypBill.CssClass = "CommonButtonLink";
pnlBillLV.Controls.Add(hypBill);
pnlBillLV.Controls.Add(new LiteralControl("<br/>"));
}
}
hypWorkOrderPaymentTerm.Target = "_blank";
hypWorkOrderReport.Target = "_blank";
hypWorkOrderAnnexureReport.Target = "_blank";
}
}
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);
}
}
}
}
