private void BuildGrandTotalLabel()
{
if (PRMWorkOrderID > 0)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderItemMapEntity.FLD_NAME_WorkOrderID, PRMWorkOrderID.ToString(), SQLMatchType.Equal);
IList <PRMWorkOrderItemMapEntity> lst = FCCPRMWorkOrderItemMap.GetFacadeCreate().GetIL(100000, 1, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
if (lst != null && lst.Count > 0)
{
var transinfo = (from transaction in lst
select transaction.RequiredQty * transaction.Rate).Sum(val => val);
PRMWorkOrderEntity pRMWorkOrderEntity = FCCPRMWorkOrder.GetFacadeCreate().GetByID(PRMWorkOrderID);
Decimal totalPrice = transinfo;
Decimal AIT, Discount, Vat, Tax, CarryingCharge;
Decimal.TryParse(pRMWorkOrderEntity.AIT.ToString(), out AIT);
Decimal.TryParse(pRMWorkOrderEntity.Discount.ToString(), out Discount);
Decimal.TryParse(pRMWorkOrderEntity.CarryingCharge.ToString(), out CarryingCharge);
Decimal.TryParse(pRMWorkOrderEntity.VAT.ToString(), out Vat);
Decimal.TryParse(pRMWorkOrderEntity.Tax.ToString(), out Tax);
totalPrice += AIT;
totalPrice += Discount;
totalPrice -= Vat;
totalPrice -= Tax;
totalPrice -= CarryingCharge;
//lblGrandTotal.Text = Math.Round(transinfo,2).ToString();
lblGrandTotal.Text = MiscUtil.NumericCommaSeperatedFormat((Decimal)totalPrice);
}
}
}
Int64 IPRMWorkOrderDataAccess.Add(PRMWorkOrderEntity pRMWorkOrderEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
try
{
long retValues = -99;
switch (reqTran)
{
case TransactionRequired.No:
{
retValues = Add(pRMWorkOrderEntity, option);
break;
}
case TransactionRequired.Yes:
{
retValues = AddTran(pRMWorkOrderEntity, option);
break;
}
default:
{
retValues = -99;
break;
}
}
return(retValues);
}
catch (Exception ex)
{
throw ex;
}
}
private Int64 DeleteTran(PRMWorkOrderEntity pRMWorkOrderEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.PRMWorkOrder_SET";
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand cmd = db.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd, db);
AddFilterExpressionParameter(cmd, filterExpression, db);
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 btnPnlCancelWO_Click(object sender, EventArgs e)
{
PRMWorkOrderEntity pRMWorkOrderEntity = FCCPRMWorkOrder.GetFacadeCreate().GetByID(PRMWorkOrderID);
pRMWorkOrderEntity.WorkOrderStatusID = MasterDataConstants.WorkOrderStatus.CANCELED;
pRMWorkOrderEntity.Remarks = txtWOCancelRemarks.Text.Trim().ToString();
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderEntity.FLD_NAME_WorkOrderID, PRMWorkOrderID.ToString(), SQLMatchType.Equal);
result = FCCPRMWorkOrder.GetFacadeCreate().Update(pRMWorkOrderEntity, fe, DatabaseOperationType.Update, TransactionRequired.No);
if (result > 0)
{
#region AP Update
APApprovalProcessEntity aPApprovalProcessEntity = FCCAPApprovalProcess.GetFacadeCreate().GetByID(APApprovalProcessID);
if (aPApprovalProcessEntity != null && aPApprovalProcessEntity.APApprovalProcessID > 0)
{
aPApprovalProcessEntity.APStatusID = MasterDataConstants.APStatus.CANCELED;
Int64 resultOne = -1;
String fe_one = SqlExpressionBuilder.PrepareFilterExpression(APApprovalProcessEntity.FLD_NAME_APApprovalProcessID, APApprovalProcessID.ToString(), SQLMatchType.Equal);
resultOne = FCCAPApprovalProcess.GetFacadeCreate().Update(aPApprovalProcessEntity, fe_one, DatabaseOperationType.Update, TransactionRequired.No);
if (resultOne > 0)
{
APMemberFeedbackEntity aPMemberFeedbackEntity = FCCAPMemberFeedback.GetFacadeCreate().GetByID(APMemberFeedbackID);
if (aPMemberFeedbackEntity != null && aPMemberFeedbackEntity.APMemberFeedbackID > 0)
{
aPMemberFeedbackEntity.APFeedbackID = MasterDataConstants.APFeedback.CANCELED;
Int64 resultC = -1;
String fe_memberfeedback = SqlExpressionBuilder.PrepareFilterExpression(APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, APMemberFeedbackID.ToString(), SQLMatchType.Equal);
resultC = FCCAPMemberFeedback.GetFacadeCreate().Update(aPMemberFeedbackEntity, fe_memberfeedback, DatabaseOperationType.Update, TransactionRequired.No);
RedirectPageToPendingList();
}
}
}
#endregion
}
}
protected void lvPRMWorkOrder_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 WorkOrderID;
Int64.TryParse(e.CommandArgument.ToString(), out WorkOrderID);
if (WorkOrderID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
String url = UrlHelper.BuildSecureUrl("~/PRM/PRMWorkOrder.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, WorkOrderID.ToString()).ToString();
Response.Redirect(url);
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderEntity.FLD_NAME_WorkOrderID, WorkOrderID.ToString(), SQLMatchType.Equal);
PRMWorkOrderEntity pRMWorkOrderEntity = new PRMWorkOrderEntity();
result = FCCPRMWorkOrder.GetFacadeCreate().Delete(pRMWorkOrderEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_WorkOrderID = 0;
_PRMWorkOrderEntity = new PRMWorkOrderEntity();
PrepareInitialView();
BindPRMWorkOrderList();
MiscUtil.ShowMessage(lblMessage, "Work Order has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Work Order.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
private Int64 Delete(PRMWorkOrderEntity pRMWorkOrderEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.PRMWorkOrder_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("PRMWorkOrderEntity already exists. Please specify another PRMWorkOrderEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("PRMWorkOrderEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("PRMWorkOrderEntity already exists. Please specify another PRMWorkOrderEntity.");
}
}
}
}
return(returnCode);
}
Int64 IPRMWorkOrderFacade.Delete(PRMWorkOrderEntity pRMWorkOrderEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreatePRMWorkOrderDataAccess().Delete(pRMWorkOrderEntity, filterExpression, option, reqTran));
}
Int64 IPRMWorkOrderFacade.Add(PRMWorkOrderEntity pRMWorkOrderEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreatePRMWorkOrderDataAccess().Add(pRMWorkOrderEntity, option, reqTran));
}
private Int64 Add(PRMWorkOrderEntity pRMWorkOrderEntity, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.PRMWorkOrder_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddNullPrimaryKeyParameter(cmd, "WorkOrderID");
Database.AddInParameter(cmd, "@SupplierID", DbType.Int64, pRMWorkOrderEntity.SupplierID);
Database.AddInParameter(cmd, "@WorkOrderNo", DbType.String, pRMWorkOrderEntity.WorkOrderNo);
Database.AddInParameter(cmd, "@AttentionID", DbType.Int64, pRMWorkOrderEntity.AttentionID);
Database.AddInParameter(cmd, "@OtherAttention", DbType.String, pRMWorkOrderEntity.OtherAttention);
Database.AddInParameter(cmd, "@CreateDate", DbType.DateTime, pRMWorkOrderEntity.CreateDate);
Database.AddInParameter(cmd, "@Subject", DbType.String, pRMWorkOrderEntity.Subject);
Database.AddInParameter(cmd, "@BodyTitle", DbType.String, pRMWorkOrderEntity.BodyTitle);
Database.AddInParameter(cmd, "@StartDate", DbType.DateTime, pRMWorkOrderEntity.StartDate);
Database.AddInParameter(cmd, "@CompletionDate", DbType.DateTime, pRMWorkOrderEntity.CompletionDate);
Database.AddInParameter(cmd, "@Warranty", DbType.String, pRMWorkOrderEntity.Warranty);
Database.AddInParameter(cmd, "@DelayCharge", DbType.String, pRMWorkOrderEntity.DelayCharge);
Database.AddInParameter(cmd, "@AIT", DbType.Decimal, pRMWorkOrderEntity.AIT);
Database.AddInParameter(cmd, "@CarryingCharge", DbType.Decimal, pRMWorkOrderEntity.CarryingCharge);
Database.AddInParameter(cmd, "@Discount", DbType.Decimal, pRMWorkOrderEntity.Discount);
Database.AddInParameter(cmd, "@VAT", DbType.Decimal, pRMWorkOrderEntity.VAT);
Database.AddInParameter(cmd, "@Tax", DbType.Decimal, pRMWorkOrderEntity.Tax);
Database.AddInParameter(cmd, "@GrandTotal", DbType.Decimal, pRMWorkOrderEntity.GrandTotal);
Database.AddInParameter(cmd, "@RowText", DbType.String, pRMWorkOrderEntity.RowText);
Database.AddInParameter(cmd, "@Remarks", DbType.String, pRMWorkOrderEntity.Remarks);
Database.AddInParameter(cmd, "@FootNote", DbType.String, pRMWorkOrderEntity.FootNote);
Database.AddInParameter(cmd, "@PreparedByID", DbType.Int64, pRMWorkOrderEntity.PreparedByID);
Database.AddInParameter(cmd, "@WorkOrderStatusID", DbType.Int64, pRMWorkOrderEntity.WorkOrderStatusID);
Database.AddInParameter(cmd, "@IsFinalBilled", DbType.Boolean, pRMWorkOrderEntity.IsFinalBilled);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("PRMWorkOrderEntity already exists. Please specify another PRMWorkOrderEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("PRMWorkOrderEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("PRMWorkOrderEntity already exists. Please specify another PRMWorkOrderEntity.");
}
}
}
}
return(returnCode);
}
private Int64 UpdateTran(PRMWorkOrderEntity pRMWorkOrderEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.PRMWorkOrder_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, "@WorkOrderID", DbType.Int64, pRMWorkOrderEntity.WorkOrderID);
db.AddInParameter(cmd, "@SupplierID", DbType.Int64, pRMWorkOrderEntity.SupplierID);
db.AddInParameter(cmd, "@WorkOrderNo", DbType.String, pRMWorkOrderEntity.WorkOrderNo);
db.AddInParameter(cmd, "@AttentionID", DbType.Int64, pRMWorkOrderEntity.AttentionID);
db.AddInParameter(cmd, "@OtherAttention", DbType.String, pRMWorkOrderEntity.OtherAttention);
db.AddInParameter(cmd, "@CreateDate", DbType.DateTime, pRMWorkOrderEntity.CreateDate);
db.AddInParameter(cmd, "@Subject", DbType.String, pRMWorkOrderEntity.Subject);
db.AddInParameter(cmd, "@BodyTitle", DbType.String, pRMWorkOrderEntity.BodyTitle);
db.AddInParameter(cmd, "@StartDate", DbType.DateTime, pRMWorkOrderEntity.StartDate);
db.AddInParameter(cmd, "@CompletionDate", DbType.DateTime, pRMWorkOrderEntity.CompletionDate);
db.AddInParameter(cmd, "@Warranty", DbType.String, pRMWorkOrderEntity.Warranty);
db.AddInParameter(cmd, "@DelayCharge", DbType.String, pRMWorkOrderEntity.DelayCharge);
db.AddInParameter(cmd, "@AIT", DbType.Decimal, pRMWorkOrderEntity.AIT);
db.AddInParameter(cmd, "@CarryingCharge", DbType.Decimal, pRMWorkOrderEntity.CarryingCharge);
db.AddInParameter(cmd, "@Discount", DbType.Decimal, pRMWorkOrderEntity.Discount);
db.AddInParameter(cmd, "@VAT", DbType.Decimal, pRMWorkOrderEntity.VAT);
db.AddInParameter(cmd, "@Tax", DbType.Decimal, pRMWorkOrderEntity.Tax);
db.AddInParameter(cmd, "@GrandTotal", DbType.Decimal, pRMWorkOrderEntity.GrandTotal);
db.AddInParameter(cmd, "@RowText", DbType.String, pRMWorkOrderEntity.RowText);
db.AddInParameter(cmd, "@Remarks", DbType.String, pRMWorkOrderEntity.Remarks);
db.AddInParameter(cmd, "@FootNote", DbType.String, pRMWorkOrderEntity.FootNote);
db.AddInParameter(cmd, "@PreparedByID", DbType.Int64, pRMWorkOrderEntity.PreparedByID);
db.AddInParameter(cmd, "@WorkOrderStatusID", DbType.Int64, pRMWorkOrderEntity.WorkOrderStatusID);
db.AddInParameter(cmd, "@IsFinalBilled", DbType.Boolean, pRMWorkOrderEntity.IsFinalBilled);
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 lvPRMWorkOrder_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 WorkOrderID;
Int64.TryParse(e.CommandArgument.ToString(), out WorkOrderID);
if (WorkOrderID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
String url = UrlHelper.BuildSecureUrl("~/PRM/PRMWorkOrder.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, WorkOrderID.ToString()).ToString();
Response.Redirect(url);
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderEntity.FLD_NAME_WorkOrderID, WorkOrderID.ToString(), SQLMatchType.Equal);
PRMWorkOrderEntity pRMWorkOrderEntity = new PRMWorkOrderEntity();
result = FCCPRMWorkOrder.GetFacadeCreate().Delete(pRMWorkOrderEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_WorkOrderID = 0;
_PRMWorkOrderEntity = new PRMWorkOrderEntity();
PrepareInitialView();
BindPRMWorkOrderList();
MiscUtil.ShowMessage(lblMessage, "Work Order has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Work Order.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
else if (string.Equals(e.CommandName, "CancelItem"))
{
try
{
_WorkOrderID = WorkOrderID;
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderEntity.FLD_NAME_WorkOrderID, WorkOrderID.ToString(), SQLMatchType.Equal);
PRMWorkOrderEntity pRMWorkOrderEntity = CurrentPRMWorkOrderEntity;
pRMWorkOrderEntity.WorkOrderStatusID = MasterDataConstants.WorkOrderStatus.CANCELED;
result = FCCPRMWorkOrder.GetFacadeCreate().Update(pRMWorkOrderEntity, fe, DatabaseOperationType.Update, TransactionRequired.No);
if (result > 0)
{
_WorkOrderID = 0;
_PRMWorkOrderEntity = new PRMWorkOrderEntity();
PrepareInitialView();
BindPRMWorkOrderList();
MiscUtil.ShowMessage(lblMessage, "WorkOrder has been successfully Rejected.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to WorkOrder Rejected", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
else if (string.Equals(e.CommandName, "UpdateItem"))
{
try
{
#region Approval Process
Boolean apResult = APRobot.ResetApprovalProcessForWorkOrder(WorkOrderID);
if (apResult == true)
{
MiscUtil.ShowMessage(lblMessage, "Approval Process has been reset successfully.", UIConstants.MessageType.GREEN);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to reset approval process.", UIConstants.MessageType.RED);
}
// EnableDisableApprovalProcessCheck();
BindList();
#endregion
//Int64 result = -1;
//String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderEntity.FLD_NAME_WorkOrderID, WorkOrderID.ToString(), SQLMatchType.Equal);
//PRMWorkOrderEntity pRMWorkOrderEntity = new PRMWorkOrderEntity();
//result = FCCPRMWorkOrder.GetFacadeCreate().Delete(pRMWorkOrderEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
//if (result == 0)
//{
// _WorkOrderID = 0;
// _PRMWorkOrderEntity = new PRMWorkOrderEntity();
// PrepareInitialView();
// BindPRMWorkOrderList();
// MiscUtil.ShowMessage(lblMessage, "Work Order has been successfully deleted.", true);
//}
//else
//{
// MiscUtil.ShowMessage(lblMessage, "Failed to delete Work Order.", true);
//}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
protected void btnAddNew_Click(object sender, EventArgs e)
{
_WorkOrderID = 0;
_PRMWorkOrderEntity = new PRMWorkOrderEntity();
PrepareInitialView();
}
private void SavePRMWorkOrderEntity()
{
if (IsValid)
{
try
{
PRMWorkOrderEntity pRMWorkOrderEntity = BuildPRMWorkOrderEntity();
Int64 result = -1;
if (pRMWorkOrderEntity.IsNew)
{
result = FCCPRMWorkOrder.GetFacadeCreate().Add(pRMWorkOrderEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderEntity.FLD_NAME_WorkOrderID, pRMWorkOrderEntity.WorkOrderID.ToString(), SQLMatchType.Equal);
result = FCCPRMWorkOrder.GetFacadeCreate().Update(pRMWorkOrderEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
_WorkOrderID = result;
_PRMWorkOrderEntity = new PRMWorkOrderEntity();
PrepareInitialView();
PrepareEditView();
if (pRMWorkOrderEntity.IsNew)
{
if (result > 0)
{
_WorkOrderID = result;
BuildLabel(result);
String NavUrl = UrlHelper.BuildSecureUrl("~/PRM/PRMWorkOrderItemMap.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, result.ToString(), PRMWorkOrderEntity.FLD_NAME_WorkOrderNo, CurrentPRMWorkOrderEntity.WorkOrderNo.ToString()).ToString();
Response.Redirect(NavUrl);
}
MiscUtil.ShowMessage(lblMessage, "Work Order Information has been added successfully.", false);
}
else
{
String NavUrl = UrlHelper.BuildSecureUrl("~/PRM/PRMWorkOrderPaymentTerm.aspx", string.Empty, UrlConstants.OVERVIEW_WORKORDER_ID, result.ToString(), PRMWorkOrderEntity.FLD_NAME_WorkOrderNo, CurrentPRMWorkOrderEntity.WorkOrderNo.ToString()).ToString();
Response.Redirect(NavUrl);
MiscUtil.ShowMessage(lblMessage, "Work Order Information has been updated successfully.", false);
}
}
else
{
if (pRMWorkOrderEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Work Order Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Work Order Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
private PRMWorkOrderEntity BuildPRMWorkOrderEntity()
{
PRMWorkOrderEntity pRMWorkOrderEntity = CurrentPRMWorkOrderEntity;
if (ddlSupplierID.Items.Count > 0)
{
if (ddlSupplierID.SelectedValue == "0")
{
}
else
{
pRMWorkOrderEntity.SupplierID = Int64.Parse(ddlSupplierID.SelectedValue);
}
}
pRMWorkOrderEntity.WorkOrderNo = txtWorkOrderNo.Text.ToString();
if (ddlAttentionID.Items.Count > 0)
{
if (ddlAttentionID.SelectedValue == "0")
{
}
else
{
pRMWorkOrderEntity.AttentionID = Int64.Parse(ddlAttentionID.SelectedValue);
}
}
pRMWorkOrderEntity.OtherAttention = txtOtherAttention.Text.Trim();
if (txtCreateDate.Text.Trim().IsNotNullOrEmpty())
{
pRMWorkOrderEntity.CreateDate = MiscUtil.ParseToDateTime(txtCreateDate.Text);
}
pRMWorkOrderEntity.Subject = txtSubject.Text.Trim();
pRMWorkOrderEntity.BodyTitle = txtBodyTitle.Text.Trim();
if (txtStartDate.Text.Trim().IsNotNullOrEmpty())
{
pRMWorkOrderEntity.StartDate = MiscUtil.ParseToDateTime(txtStartDate.Text);
}
if (txtCompletionDate.Text.Trim().IsNotNullOrEmpty())
{
pRMWorkOrderEntity.CompletionDate = MiscUtil.ParseToDateTime(txtCompletionDate.Text);
}
pRMWorkOrderEntity.Warranty = txtWarranty.Text.Trim();
pRMWorkOrderEntity.DelayCharge = txtDelayCharge.Text.Trim();
if (!txtAIT.Text.Trim().IsNullOrEmpty())
{
pRMWorkOrderEntity.AIT = Decimal.Parse(txtAIT.Text.Trim());
}
else
{
pRMWorkOrderEntity.AIT = null;
}
if (!txtCarryingCharge.Text.Trim().IsNullOrEmpty())
{
pRMWorkOrderEntity.CarryingCharge = Decimal.Parse(txtCarryingCharge.Text.Trim());
}
else
{
pRMWorkOrderEntity.CarryingCharge = null;
}
if (!txtDiscount.Text.Trim().IsNullOrEmpty())
{
pRMWorkOrderEntity.Discount = Decimal.Parse(txtDiscount.Text.Trim());
}
else
{
pRMWorkOrderEntity.Discount = null;
}
if (!txtVAT.Text.Trim().IsNullOrEmpty())
{
pRMWorkOrderEntity.VAT = Decimal.Parse(txtVAT.Text.Trim());
}
else
{
pRMWorkOrderEntity.VAT = null;
}
if (!txtTax.Text.Trim().IsNullOrEmpty())
{
pRMWorkOrderEntity.Tax = Decimal.Parse(txtTax.Text.Trim());
}
else
{
pRMWorkOrderEntity.Tax = null;
}
if (!txtGrandTotal.Text.Trim().IsNullOrEmpty())
{
pRMWorkOrderEntity.GrandTotal = Decimal.Parse(txtGrandTotal.Text.Trim());
}
else
{
pRMWorkOrderEntity.GrandTotal = null;
}
pRMWorkOrderEntity.RowText = txtRowText.Text.Trim();
pRMWorkOrderEntity.Remarks = txtRemarks.Text.Trim();
pRMWorkOrderEntity.FootNote = txtFootNote.Text.Trim();
if (ddlPreparedByID.Items.Count > 0)
{
if (ddlPreparedByID.SelectedValue == "0")
{
}
else
{
pRMWorkOrderEntity.PreparedByID = Int64.Parse(ddlPreparedByID.SelectedValue);
}
}
if (ddlWorkOrderStatusID.Items.Count > 0)
{
if (ddlWorkOrderStatusID.SelectedValue == "0")
{
}
else
{
pRMWorkOrderEntity.WorkOrderStatusID = Int64.Parse(ddlWorkOrderStatusID.SelectedValue);
}
}
pRMWorkOrderEntity.IsFinalBilled = false;
return(pRMWorkOrderEntity);
}
private void PrepareEditView()
{
PRMWorkOrderEntity pRMWorkOrderEntity = CurrentPRMWorkOrderEntity;
if (!pRMWorkOrderEntity.IsNew)
{
if (ddlSupplierID.Items.Count > 0 && pRMWorkOrderEntity.SupplierID != null)
{
ddlSupplierID.SelectedValue = pRMWorkOrderEntity.SupplierID.ToString();
}
PopulatePRMSupplierContactPersonByVedor();
txtWorkOrderNo.Text = pRMWorkOrderEntity.WorkOrderNo.ToString();
if (ddlAttentionID.Items.Count > 0 && pRMWorkOrderEntity.AttentionID != null)
{
ddlAttentionID.SelectedValue = pRMWorkOrderEntity.AttentionID.ToString();
pnlOtherAttention.Visible = false;
}
if (ddlAttentionID.Items.Count > 0 && pRMWorkOrderEntity.AttentionID == null)
{
ddlAttentionID.SelectedValue = "0";
pnlOtherAttention.Visible = true;
}
txtOtherAttention.Text = pRMWorkOrderEntity.OtherAttention.ToString();
txtCreateDate.Text = pRMWorkOrderEntity.CreateDate.ToStringDefault();
txtSubject.Text = pRMWorkOrderEntity.Subject.ToString();
txtBodyTitle.Text = pRMWorkOrderEntity.BodyTitle.ToString();
txtStartDate.Text = pRMWorkOrderEntity.StartDate.ToStringDefault();
txtCompletionDate.Text = pRMWorkOrderEntity.CompletionDate.ToStringDefault();
txtWarranty.Text = pRMWorkOrderEntity.Warranty.ToString();
txtDelayCharge.Text = pRMWorkOrderEntity.DelayCharge.ToString();
txtAIT.Text = pRMWorkOrderEntity.AIT.ToString();
txtCarryingCharge.Text = pRMWorkOrderEntity.CarryingCharge.ToString();
txtDiscount.Text = pRMWorkOrderEntity.Discount.ToString();
txtVAT.Text = pRMWorkOrderEntity.VAT.ToString();
txtTax.Text = pRMWorkOrderEntity.Tax.ToString();
String fe_workorderItem = SqlExpressionBuilder.PrepareFilterExpression(PRMWorkOrderItemMapEntity.FLD_NAME_WorkOrderID, pRMWorkOrderEntity.WorkOrderID.ToString(), SQLMatchType.Equal);
IList <PRMWorkOrderItemMapEntity> lstPRMWorkOrderItemMap = FCCPRMWorkOrderItemMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe_workorderItem, DatabaseOperationType.LoadWithFilterExpression);
if (lstPRMWorkOrderItemMap != null && lstPRMWorkOrderItemMap.Count > 0)
{
txtTotal.Text = Math.Round(lstPRMWorkOrderItemMap.Sum(o => (o.RequiredQty * o.Rate)), 2).ToString();
}
else
{
txtTotal.Text = "0";
}
if (txtTotal.Text.Trim().IsNotNullOrEmpty())
{
Decimal total, ait, vat, tax, discount, carryingcharge, netAmount;
Decimal.TryParse(txtTotal.Text.Trim(), out total);
Decimal.TryParse(txtAIT.Text.Trim(), out ait);
Decimal.TryParse(txtVAT.Text.Trim(), out vat);
Decimal.TryParse(txtTax.Text.Trim(), out tax);
Decimal.TryParse(txtDiscount.Text.Trim(), out discount);
Decimal.TryParse(txtCarryingCharge.Text.Trim(), out carryingcharge);
netAmount = total - discount + carryingcharge + vat + tax;
txtGrandTotal.Text = Math.Round(netAmount, 2).ToString();
}
else
{
txtGrandTotal.Text = "0";
}
txtRowText.Text = pRMWorkOrderEntity.RowText.ToString();
txtRemarks.Text = pRMWorkOrderEntity.Remarks.ToString();
txtFootNote.Text = pRMWorkOrderEntity.FootNote.ToString();
if (ddlPreparedByID.Items.Count > 0 && pRMWorkOrderEntity.PreparedByID != null)
{
ddlPreparedByID.SelectedValue = pRMWorkOrderEntity.PreparedByID.ToString();
}
if (ddlWorkOrderStatusID.Items.Count > 0 && pRMWorkOrderEntity.WorkOrderStatusID != null)
{
ddlWorkOrderStatusID.SelectedValue = pRMWorkOrderEntity.WorkOrderStatusID.ToString();
}
btnSubmit.Text = "Update";
btnAddNew.Visible = true;
}
}
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);
}
}
}
}
