protected void odsOTIssue_Detailed_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe = String.Empty;
Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
//String fe_assignToEmployee = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_AssignedToEmployeeID, OverviewEmployeeID.ToString(), SQLMatchType.Equal);
String fe_assignToEmployee = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_AssignedToEmployeeID, "00", SQLMatchType.Equal);
fe = fe_assignToEmployee;
if (chbxFilter.Checked)
{
if (txtRequestStartDate.Text.IsNotNullOrEmpty() || txtRequestEndDate.Text.IsNotNullOrEmpty())
{
String fe2 = "OTIssue.AssignedToEmployeeID = " + OverviewEmployeeID + " and ( OTIssue.ExpectedStartDate >= '" + MiscUtil.ParseToDateTime(txtRequestStartDate.Text) + "' and OTIssue.ExpectedEndDate <='" + MiscUtil.ParseToDateTime(txtRequestEndDate.Text) + "' or OTIssue.ExpectedEndDate >= '" + MiscUtil.ParseToDateTime(txtRequestStartDate.Text) + "' and OTIssue.ExpectedStartDate <='" + MiscUtil.ParseToDateTime(txtRequestEndDate.Text) + "')";
fe = fe2;
}
else
{
this.messageDetails.Text = "Please Select Request Start Date and End Date. First";
this.MPE.Show();
}
}
//fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.OR, fe_assignToEmployee);
e.InputParameters["filterExpression"] = fe;
}
private HREmployeeNoticeTemplateEntity BuildHREmployeeNoticeTemplateEntity()
{
HREmployeeNoticeTemplateEntity hREmployeeNoticeTemplateEntity = CurrentHREmployeeNoticeTemplateEntity;
if (ddlNoticeTemplateTypeID.Items.Count > 0)
{
if (ddlNoticeTemplateTypeID.SelectedValue == "0")
{
}
else
{
hREmployeeNoticeTemplateEntity.NoticeTemplateTypeID = Int64.Parse(ddlNoticeTemplateTypeID.SelectedValue);
}
}
hREmployeeNoticeTemplateEntity.TemplateName = txtTemplateName.Text.Trim();
hREmployeeNoticeTemplateEntity.Text = txtText.Content.Trim();
hREmployeeNoticeTemplateEntity.Remarks = txtRemarks.Text.Trim();
hREmployeeNoticeTemplateEntity.CreateDate = System.DateTime.Now;
hREmployeeNoticeTemplateEntity.IP = MiscUtil.GetLocalIP();
hREmployeeNoticeTemplateEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
return(hREmployeeNoticeTemplateEntity);
}
private ACBankAccountDepositEntity BuildACBankAccountDepositEntity()
{
ACBankAccountDepositEntity aCBankAccountDepositEntity = CurrentACBankAccountDepositEntity;
if (txtDepositDate.Text.Trim().IsNotNullOrEmpty())
{
aCBankAccountDepositEntity.DepositDate = MiscUtil.ParseToDateTime(txtDepositDate.Text);
}
if (ddlPaidFromID.Items.Count > 0)
{
if (ddlPaidFromID.SelectedValue == "0")
{
}
else
{
aCBankAccountDepositEntity.PaidFromID = Int64.Parse(ddlPaidFromID.SelectedValue);
}
}
if (ddlReferenceID.Items.Count > 0 && ddlReferenceID.SelectedValue != "0")
{
aCBankAccountDepositEntity.ReferenceID = Int64.Parse(ddlReferenceID.SelectedValue);
}
else
{
aCBankAccountDepositEntity.ReferenceID = null;
}
if (ddlBankAccountID.Items.Count > 0)
{
if (ddlBankAccountID.SelectedValue == "0")
{
}
else
{
aCBankAccountDepositEntity.BankAccountID = Int64.Parse(ddlBankAccountID.SelectedValue);
}
}
//if (ddlProjectID.Items.Count > 0)
//{
// if (ddlProjectID.SelectedValue == "0")
// {
// }
// else
// {
// aCBankAccountDepositEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue);
// }
//}
aCBankAccountDepositEntity.BankAccountDepositApprovalStatusID = MasterDataConstants.ACMDBankAccountDepositApprovalStatus.INITIATED;
aCBankAccountDepositEntity.Reference = txtReference.Text.Trim();
aCBankAccountDepositEntity.Name = txtName.Text.Trim();
aCBankAccountDepositEntity.Memo = txtMemo.Text.Trim();
aCBankAccountDepositEntity.PreparedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
return(aCBankAccountDepositEntity);
}
private PRMMaterialReceiveEntity BuildPRMMaterialReceiveEntity()
{
PRMMaterialReceiveEntity pRMMaterialReceiveEntity = CurrentPRMMaterialReceiveEntity;
if (ddlProjectID.Items.Count > 0)
{
if (ddlProjectID.SelectedValue == "0")
{
}
else
{
pRMMaterialReceiveEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue);
}
}
if (ddlSupplierID.Items.Count > 0)
{
if (ddlSupplierID.SelectedValue == "0")
{
}
else
{
pRMMaterialReceiveEntity.SupplierID = Int64.Parse(ddlSupplierID.SelectedValue);
}
}
if (ddlRequisitionID.Items.Count > 0)
{
if (ddlRequisitionID.SelectedValue == "0")
{
}
else
{
pRMMaterialReceiveEntity.RequisitionID = Int64.Parse(ddlRequisitionID.SelectedValue);
}
}
if (ddlWorkOrderID.Items.Count > 0)
{
if (ddlWorkOrderID.SelectedValue == "0")
{
}
else
{
pRMMaterialReceiveEntity.WorkOrderID = Int64.Parse(ddlWorkOrderID.SelectedValue);
}
}
pRMMaterialReceiveEntity.MRRNo = txtMRRNo.Text.Trim();
if (txtMRRDate.Text.Trim().IsNotNullOrEmpty())
{
pRMMaterialReceiveEntity.MRRDate = MiscUtil.ParseToDateTime(txtMRRDate.Text);
}
pRMMaterialReceiveEntity.Remarks = txtRemarks.Text.Trim();
pRMMaterialReceiveEntity.MaterialReceiveApprovalStatusID = MasterDataConstants.MDMaterialReceiveApprovalStatus.INITIATED;
pRMMaterialReceiveEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
return(pRMMaterialReceiveEntity);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
StringBuilder xmlStr = new StringBuilder();
Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
String ip = MiscUtil.GetLocalIP();
Int64 projectID = 0;
if (ddlProjectID != null && ddlProjectID.SelectedValue != "0")
{
projectID = Int64.Parse(ddlProjectID.SelectedValue);
}
xmlStr.Append("<m>");
foreach (TreeNode tn in treeTask.CheckedNodes)
{
String subXmlStr = null;
subXmlStr = subXmlStr + "<i><a>" + tn.Text + "</a><b>" + employeeID + "</b><c>" + ddlAssignedToEmployeeID.SelectedValue + "</c><d>" + ip + "</d><e>" + CurrentMember.MemberID + "</e><f>" + projectID + "</f></i>";
xmlStr.Append(subXmlStr.ToString());
}
xmlStr.Append("</m>");
FCCBulkInsertXML.GetFacadeCreate().GetIL(xmlStr.ToString(), CommonConstants.TaskTemplateInfo);
MiscUtil.ShowMessage(lblMessage, "Task Template Item Map Save Successfully.", false);
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, "An Error Occoured.", true);
}
}
private void PrepareInitialView()
{
BuildDropDownList();
txtDiscussionDate.Text = System.DateTime.Now.ToString(UIConstants.SHORT_DATE_FORMAT);
txtTopics.Text = String.Empty;
txtNote.Text = String.Empty;
chkIsFollowUpNeeded.Checked = false;
chkIsIWillCall.Checked = false;
chkIsField1.Checked = false;
txtNextAction.Text = String.Empty;
txtNextCommunicationDate.Text = System.DateTime.Now.AddDays(7).ToString(UIConstants.SHORT_DATE_FORMAT);
if (ddlCommunicateByEmployeeID.Items.Count > 0 && ddlCommunicateByEmployeeID != null)
{
Int64 currentEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
if (currentEmployeeID > 0)
{
ddlCommunicateByEmployeeID.SelectedValue = currentEmployeeID.ToString();
}
}
btnSubmit.Text = "Add";
btnAddNew.Visible = false;
}
private void PrepareInitialView()
{
BuildDropDownList();
txtStartDate.Text = System.DateTime.Now.AddDays(-7).ToString(UIConstants.SHORT_DATE_FORMAT);
txtEndDate.Text = System.DateTime.Now.ToString(UIConstants.SHORT_DATE_FORMAT);
if (this.Page.User.Identity.IsAuthenticated == true)
{
//if (Roles.IsUserInRole(this.Page.User.Identity.Name, "1.466") == true ||
// Roles.IsUserInRole(this.Page.User.Identity.Name, "HR") == true ||
// Roles.IsUserInRole(this.Page.User.Identity.Name, "CRM") == true ||
// Roles.IsUserInRole(this.Page.User.Identity.Name, "Accounts") == true ||
// Roles.IsUserInRole(this.Page.User.Identity.Name, "Engineers") == true||
// Roles.IsUserInRole(this.Page.User.Identity.Name, "IS") == true)
if (this.Page.User.Identity.Name.Equals("17.466") == true ||
this.Page.User.Identity.Name.Equals("17.042") == true ||
this.Page.User.Identity.Name.Equals("17.1127") == true ||
this.Page.User.Identity.Name.Equals("17.605") == true ||
this.Page.User.Identity.Name.Equals("17.599") == true ||
this.Page.User.Identity.Name.Equals("17.1000") == true ||
this.Page.User.Identity.Name.Equals("17.979") == true ||
this.Page.User.Identity.Name.Equals("17.687") == true ||
this.Page.User.Identity.Name.Equals("17.788") == true ||
this.Page.User.Identity.Name.Equals("17.1116") == true ||
this.Page.User.Identity.Name.Equals("17.799") == true ||
this.Page.User.Identity.Name.Equals("17.780") == true)
{
String fe_session = SqlExpressionBuilder.PrepareFilterExpression(HRSessionEntity.FLD_NAME_EvaluationSessionStatusID, MasterDataConstants.MDEvaluationSessionStatus.OPEN.ToString(), SQLMatchType.Equal);
IList <HRSessionEntity> lstHRSessionEntity = FCCHRSession.GetFacadeCreate().GetIL(null, null, String.Empty, fe_session, DatabaseOperationType.LoadWithFilterExpression);
if (lstHRSessionEntity != null && lstHRSessionEntity.Count > 0)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeSupervisorMap_DetailedEntity.FLD_NAME_SupervisorEmployeeID, MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("HREmployeeSupervisorMap." + HREmployeeSupervisorMap_DetailedEntity.FLD_NAME_SessionCategoryID, lstHRSessionEntity[0].SessionID.ToString(), SQLMatchType.Equal);
String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
IList <HREmployeeSupervisorMap_DetailedEntity> lst = FCCHREmployeeSupervisorMap_Detailed.GetFacadeCreate().GetIL(100000, 1, String.Empty, fe);
if (lst != null && lst.Count > 0)
{
ddlEmployeeID.Items.Clear();
foreach (HREmployeeSupervisorMap_DetailedEntity ent in lst)
{
ListItem lstItem = new ListItem();
lstItem.Text = ent.EmployeeCode + " - " + ent.EmployeeFullName + "(" + ent.SessionCategoryName.ToString() + ")";
lstItem.Value = ent.EmployeeID.ToString();
ddlEmployeeID.Items.Add(lstItem);
}
}
ddlEmployeeID.Enabled = true;
}
}
else
{
ddlEmployeeID.SelectedValue = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString();
ddlEmployeeID.Enabled = false;
}
}
}
private void PrepareInitialView()
{
BuildDropDownList();
BindPRMItemBrandMapList();
txtContactFullName.Text = String.Empty;
txtCompanyName.Text = String.Empty;
txtDesignation.Text = String.Empty;
txtMobileNo.Text = String.Empty;
txtMobileNo2.Text = String.Empty;
txtLandPhone.Text = String.Empty;
txtLandPhoneOffice.Text = String.Empty;
txtFaxNumber.Text = String.Empty;
txtPresentAddress.Text = String.Empty;
txtPresentAddressOffice.Text = String.Empty;
txtEmail.Text = String.Empty;
txtEmail2.Text = String.Empty;
txtDOB.Text = String.Empty;
txtNoOfChildren.Text = String.Empty;
txtAreaNeededFrom.Text = String.Empty;
txtAreaNeededTo.Text = String.Empty;
txtParkingNeeded.Text = String.Empty;
txtToiletNeeded.Text = String.Empty;
txtUnitNeeded.Text = String.Empty;
txtRemarks.Text = String.Empty;
txtLeadConversionDate.Text = System.DateTime.Now.ToString(UIConstants.SHORT_DATE_FORMAT);
Int64 currentEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
if (currentEmployeeID > 0)
{
if (ddlLeadGeneratedByEmployeeID.Items.Count > 0 && ddlLeadGeneratedByEmployeeID != null)
{
ddlLeadGeneratedByEmployeeID.SelectedValue = currentEmployeeID.ToString();
}
if (ddlLeadManagedByOneEmployeeID.Items.Count > 0 && ddlLeadManagedByOneEmployeeID != null)
{
ddlLeadManagedByOneEmployeeID.SelectedValue = currentEmployeeID.ToString();
}
if (ddlLeadManagedByTwoEmployeeID.Items.Count > 0 && ddlLeadManagedByTwoEmployeeID != null)
{
ddlLeadManagedByTwoEmployeeID.SelectedValue = currentEmployeeID.ToString();
}
}
if (ddlAreaUnitID.Items.Count > 0 && ddlAreaUnitID != null)
{
ddlAreaUnitID.SelectedValue = "1";
}
if (PageAPType == MasterDataConstants.CRMMDBuyerType.EXISTING_BUYER)
{
pnlEditor.Visible = false;
}
btnSubmit.Text = "Save and Add New";
btnAddNew.Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PrepareValidator();
PrepareInitialView();
PrepareEditView();
hfOverviewEmployeeID.Value = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString();
}
}
private ACBankAccountTransferEntity BuildACBankAccountTransferEntity()
{
ACBankAccountTransferEntity aCBankAccountTransferEntity = CurrentACBankAccountTransferEntity;
if (ddlFromBankAccountID.Items.Count > 0)
{
if (ddlFromBankAccountID.SelectedValue == "0")
{
}
else
{
aCBankAccountTransferEntity.FromBankAccountID = Int64.Parse(ddlFromBankAccountID.SelectedValue);
}
}
if (ddlToBankAccountID.Items.Count > 0)
{
if (ddlToBankAccountID.SelectedValue == "0")
{
}
else
{
aCBankAccountTransferEntity.ToBankAccountID = Int64.Parse(ddlToBankAccountID.SelectedValue);
}
}
if (txtTransferDate.Text.Trim().IsNotNullOrEmpty())
{
aCBankAccountTransferEntity.TransferDate = MiscUtil.ParseToDateTime(txtTransferDate.Text);
}
if (!txtAmount.Text.Trim().IsNullOrEmpty())
{
aCBankAccountTransferEntity.Amount = Decimal.Parse(txtAmount.Text.Trim());
}
if (!txtBankCharge.Text.Trim().IsNullOrEmpty())
{
aCBankAccountTransferEntity.BankCharge = Decimal.Parse(txtBankCharge.Text.Trim());
}
else
{
aCBankAccountTransferEntity.BankCharge = null;
}
aCBankAccountTransferEntity.BankAccountTransferApprovalStatusID = MasterDataConstants.ACMDBankAccountTransferApprovalStatus.INITIATED;
aCBankAccountTransferEntity.Memo = txtMemo.Text.Trim();
aCBankAccountTransferEntity.Remarks = txtRemarks.Text.Trim();
aCBankAccountTransferEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
return(aCBankAccountTransferEntity);
}
private HRSessionEntity BuildHRSessionEntity()
{
HRSessionEntity hRSessionEntity = CurrentHRSessionEntity;
if (ddlSessionCategoryID.Items.Count > 0)
{
if (ddlSessionCategoryID.SelectedValue == "0")
{
}
else
{
hRSessionEntity.SessionCategoryID = Int64.Parse(ddlSessionCategoryID.SelectedValue);
}
}
hRSessionEntity.SessionName = txtSessionName.Text.Trim();
if (txtStartDate.Text.Trim().IsNotNullOrEmpty())
{
hRSessionEntity.StartDate = MiscUtil.ParseToDateTime(txtStartDate.Text);
}
if (txtEndDate.Text.Trim().IsNotNullOrEmpty())
{
hRSessionEntity.EndDate = MiscUtil.ParseToDateTime(txtEndDate.Text);
}
if (txtDeadlineDate.Text.Trim().IsNotNullOrEmpty())
{
hRSessionEntity.DeadlineDate = MiscUtil.ParseToDateTime(txtDeadlineDate.Text);
}
if (ddlEvaluationSessionStatusID.Items.Count > 0)
{
if (ddlEvaluationSessionStatusID.SelectedValue == "0")
{
}
else
{
hRSessionEntity.EvaluationSessionStatusID = Int64.Parse(ddlEvaluationSessionStatusID.SelectedValue);
}
}
hRSessionEntity.Remarks = txtRemarks.Text.Trim();
hRSessionEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
hRSessionEntity.CreateDate = System.DateTime.Now;
hRSessionEntity.IP = MiscUtil.GetLocalIP();
return(hRSessionEntity);
}
private void BuildDropDownList()
{
MiscUtil.PopulateBDTaskTemplate(ddlTaskTemplateID, true);
MiscUtil.PopulateHREmployee(ddlAssignedToEmployeeID, false);
MiscUtil.PopulateBDProject(ddlProjectID, true);
if (ddlAssignedToEmployeeID != null && ddlAssignedToEmployeeID.Items.Count > 0)
{
Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
if (employeeID > 0)
{
ddlAssignedToEmployeeID.SelectedValue = employeeID.ToString();
}
}
}
private HREmployeeNoticeEntity BuildHREmployeeNoticeEntity()
{
HREmployeeNoticeEntity hREmployeeNoticeEntity = CurrentHREmployeeNoticeEntity;
if (ddlSendToEmployeeID.Items.Count > 0)
{
if (ddlSendToEmployeeID.SelectedValue == "0")
{
}
else
{
hREmployeeNoticeEntity.SendToEmployeeID = Int64.Parse(ddlSendToEmployeeID.SelectedValue);
}
}
if (!txtMemo.Text.Trim().IsNullOrEmpty())
{
hREmployeeNoticeEntity.Memo = txtMemo.Text.Trim();
}
else
{
hREmployeeNoticeEntity.Memo = null;
}
hREmployeeNoticeEntity.Text = txtText.Content.Trim();
hREmployeeNoticeEntity.Remarks = txtRemarks.Text.Trim();
if (txtNoticeDate.Text.Trim().IsNotNullOrEmpty())
{
hREmployeeNoticeEntity.NoticeDate = MiscUtil.ParseToDateTime(txtNoticeDate.Text);
}
hREmployeeNoticeEntity.PreparedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
hREmployeeNoticeEntity.PreparedByEmployeeSalaryLevel = null;
if (ddlTemplateID.Items.Count > 0)
{
if (ddlTemplateID.SelectedValue == "0")
{
}
else
{
hREmployeeNoticeEntity.TemplateID = Int64.Parse(ddlTemplateID.SelectedValue);
}
}
hREmployeeNoticeEntity.ViewCount = 0;
return(hREmployeeNoticeEntity);
}
private void PrepareInitialView()
{
BuildDropDownList();
BindLabel();
SubmitButtonEnable();
Int64 employeeID = _CurrentEmployeeEvaluatedID;
if (employeeID > 0)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(ResourceEmployee_CustomEntity.FLD_NAME_EmployeeID, employeeID.ToString(), SQLMatchType.Equal);
IList <ResourceEmployee_CustomEntity> lst = FCCResourceEmployee_Custom.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe);
if (lst != null && lst.Count > 0)
{
lblEmployeeName.Text = lst[0].MemberFullName.ToString();
lblEmployeeCode.Text = lst[0].EmployeeCode;
lblDepartment.Text = lst[0].DepartmentName;
lblDesignation.Text = lst[0].DesignationName;
lblConfirmDate.Text = lst[0].ConfirmDate.ToStringDefault();
lblJoinDate.Text = lst[0].JoinDate.ToStringDefault();
lblSessionEvaluatedBy.Text = CurrentMember.FirstName + " " + CurrentMember.MiddleName + " " + CurrentMember.LastName;
if (lst[0].EmployeeID == MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember))
{
lblSessionEvaluatedBy.Text += " (Self)";
}
else
{
lblSessionEvaluatedBy.Text += " (Supervisor)";
}
}
}
String fe_session = SqlExpressionBuilder.PrepareFilterExpression(HRSessionEntity.FLD_NAME_SessionID, _CurrentSessionID.ToString(), SQLMatchType.Equal);
HRSessionEntity hRSessionEntity = FCCHRSession.GetFacadeCreate().GetByID(_CurrentSessionID);
if (hRSessionEntity != null && hRSessionEntity.SessionID > 0)
{
lblSessionName.Text = hRSessionEntity.SessionName;
lblSessionStartDate.Text = hRSessionEntity.StartDate.ToStringDefault();
lblSessionEndDate.Text = hRSessionEntity.EndDate.ToStringDefault();
lblSessionEvaluationType.Text = "N/A";
}
}
private void PrepareInitialView()
{
BuildDropDownList();
txtContactFullName.Text = String.Empty;
txtMobileNo.Text = String.Empty;
txtLandPhone.Text = String.Empty;
txtPresentAddress.Text = String.Empty;
txtEmail.Text = String.Empty;
txtLandArea1.Text = String.Empty;
txtLandArea2.Text = String.Empty;
txtPlotNumber.Text = String.Empty;
txtPlotAddress.Text = String.Empty;
txtPlotMapUrl.Content = String.Empty;
txtArea.Text = String.Empty;
txtDimension.Text = String.Empty;
txtSpecialFeatures.Text = String.Empty;
txtStructure.Text = String.Empty;
txtRAJUKDetails.Text = String.Empty;
txtLeadConversionDate.Text = System.DateTime.Now.ToString(UIConstants.SHORT_DATE_FORMAT);
Int64 currentEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
if (currentEmployeeID > 0)
{
if (ddlLeadGeneratedByEmployeeID.Items.Count > 0 && ddlLeadGeneratedByEmployeeID != null)
{
ddlLeadGeneratedByEmployeeID.SelectedValue = currentEmployeeID.ToString();
}
if (ddlLeadManagedByOneEmployeeID.Items.Count > 0 && ddlLeadManagedByOneEmployeeID != null)
{
ddlLeadManagedByOneEmployeeID.SelectedValue = currentEmployeeID.ToString();
}
if (ddlLeadManagedByTwoEmployeeID.Items.Count > 0 && ddlLeadManagedByTwoEmployeeID != null)
{
ddlLeadManagedByTwoEmployeeID.SelectedValue = currentEmployeeID.ToString();
}
if (ddlReferredByEmployeeID.Items.Count > 0 && ddlReferredByEmployeeID != null)
{
ddlReferredByEmployeeID.SelectedValue = currentEmployeeID.ToString();
}
}
btnSubmit.Text = "Save and Add New";
btnAddNew.Visible = false;
}
protected void btnShowReport_Click(object sender, EventArgs e)
{
String reportContant = ReportConstants.WEEKLY_DTL_INDIVIDUAL_REPORT;
String employeeID = String.Empty;
if (ddlEmployeeID != null && ddlEmployeeID.SelectedValue != "0")
{
employeeID = ddlEmployeeID.SelectedValue;
}
else
{
employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString();
}
String NavigationUrl = UrlHelper.BuildSecureUrl("~/Reports/ReportViewer.aspx", string.Empty, "do", reportContant, UrlConstants.OVERVIEW_ISSUE_FROM_DATE, txtStartDate.Text.Trim().ToString(), UrlConstants.OVERVIEW_ISSUE_TO_DATE, txtEndDate.Text.Trim().ToString(), UrlConstants.OVERVIEW_EMPLOYEE_ID, employeeID).ToString();
Helper.Response.Redirect(NavigationUrl);
}
private BDProcessAssignedResourceEntity BuildBDProcessAssignedResourceEntity()
{
BDProcessAssignedResourceEntity bDProcessAssignedResourceEntity = CurrentBDProcessAssignedResourceEntity;
if (ddlProcessCategoryID.Items.Count > 0)
{
if (ddlProcessCategoryID.SelectedValue == "0")
{
}
else
{
bDProcessAssignedResourceEntity.ProcessCategoryID = Int64.Parse(ddlProcessCategoryID.SelectedValue);
}
}
bDProcessAssignedResourceEntity.Title = txtTitle.Text.Trim();
bDProcessAssignedResourceEntity.Purposes = txtPurposes.Text.Trim();
bDProcessAssignedResourceEntity.Remarks = txtRemarks.Text.Trim();
if (txtStartDate.Text.Trim().IsNotNullOrEmpty())
{
bDProcessAssignedResourceEntity.StartDate = MiscUtil.ParseToDateTime(txtStartDate.Text);
}
else
{
bDProcessAssignedResourceEntity.StartDate = null;
}
bDProcessAssignedResourceEntity.CreateDate = System.DateTime.Now;
bDProcessAssignedResourceEntity.CreateByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
if (ddlProcessAssignedResourceApprovalStatusID.Items.Count > 0)
{
if (ddlProcessAssignedResourceApprovalStatusID.SelectedValue == "0")
{
}
else
{
bDProcessAssignedResourceEntity.ProcessAssignedResourceApprovalStatusID = Int64.Parse(ddlProcessAssignedResourceApprovalStatusID.SelectedValue);
}
}
return(bDProcessAssignedResourceEntity);
}
private CMNERPCommentEntity BuildCMNERPCommentEntity()
{
CMNERPCommentEntity cMNERPCommentEntity = CurrentCMNERPCommentEntity;
cMNERPCommentEntity.ProcessCategoryID = PageProcessType;
cMNERPCommentEntity.ReferenceID = PageReferenceID;
cMNERPCommentEntity.Comment = txtComment.Text.Trim();
cMNERPCommentEntity.CommentDate = System.DateTime.Now;
Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
if (employeeID > 0)
{
cMNERPCommentEntity.EmployeeID = employeeID;
}
cMNERPCommentEntity.IP = MiscUtil.GetLocalIP();
return(cMNERPCommentEntity);
}
private void PrepareInitialView()
{
BuildDropDownList();
txtTRFNo.Text = MasterDataConstants.AutoAssigned.DEFAULT_AUTO_ASSIGNED;
txtRequestDate.Text = System.DateTime.Now.ToString(UIConstants.SHORT_DATE_FORMAT);
txtRemarks.Text = String.Empty;
if (ddlRequestedByEmployeeID.Items.Count > 0)
{
Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
if (employeeID > 0)
{
ddlRequestedByEmployeeID.SelectedValue = employeeID.ToString();
}
}
btnSubmit.Text = "Add";
btnAddNew.Visible = false;
}
private void PrepareInitialView()
{
BuildDropDownList();
txtTitle.Text = String.Empty;
txtDescription.Text = String.Empty;
txtCompletionPercentage.Text = "0";
txtDuration.Text = String.Empty;
txtExpectedStartDate.Text = System.DateTime.Now.ToString("MM/dd/yyyy hh:mm");
txtExpectedEndDate.Text = System.DateTime.Now.ToString("MM/dd/yyyy hh:mm");
txtActualStartDate.Text = String.Empty;
txtActualEndDate.Text = String.Empty;
txtNotifyBeforeMin.Text = String.Empty;
txtRemarks.Text = String.Empty;
if (ddlSupervisorEmployeeID != null && ddlSupervisorEmployeeID.Items.Count > 0)
{
Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
if (employeeID > 0)
{
ddlSupervisorEmployeeID.SelectedValue = employeeID.ToString();
}
}
if (Action == "Edit" ||
Action == "EditDetails")
{
pnlComments.Visible = true;
}
else
{
pnlComments.Visible = false;
}
pnlEditMode.Visible = false;
btnSubmit.Text = "Save";
btnAddNew.Visible = false;
}
private CRMSurveyMasterEntity BuildCRMSurveyMasterEntity()
{
CRMSurveyMasterEntity cRMSurveyMasterEntity = CurrentCRMSurveyMasterEntity;
cRMSurveyMasterEntity.Title = txtTitle.Text.Trim();
if (txtStartDate.Text.Trim().IsNotNullOrEmpty())
{
cRMSurveyMasterEntity.StartDate = MiscUtil.ParseToDateTime(txtStartDate.Text);
}
if (txtEndDate.Text.Trim().IsNotNullOrEmpty())
{
cRMSurveyMasterEntity.EndDate = MiscUtil.ParseToDateTime(txtEndDate.Text);
}
cRMSurveyMasterEntity.CreateDate = System.DateTime.Now;
cRMSurveyMasterEntity.CreateByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
return(cRMSurveyMasterEntity);
}
private void SavePRMMaterialReceiveEntity()
{
if (IsValid)
{
try
{
PRMMaterialReceiveEntity pRMMaterialReceiveEntity = BuildPRMMaterialReceiveEntity();
#region Requisition
String RequisitionNo = String.Empty;
if (txtRequisition.Text.IsNotNullOrEmpty())
{
RequisitionNo = "BL-" + txtRequisition.Text.ToString();
}
Int64 resultRequisition = -1;
Int64 resultRequisitionItem = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(REQRequisitionEntity.FLD_NAME_RequisitionNo, RequisitionNo, SQLMatchType.Equal);
IList <REQRequisitionEntity> lstRequisition = FCCREQRequisition.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
REQRequisitionItemEntity rEQRequisitionItemEntity = null;
if (lstRequisition != null && lstRequisition.Count > 0)
{
rEQRequisitionItemEntity = BuildREQRequisitionItemEntity(lstRequisition[0].RequisitionID);
pRMMaterialReceiveEntity.RequisitionID = lstRequisition[0].RequisitionID;
}
else
{
REQRequisitionEntity rEQRequisitionEntity = BuildREQRequisitionEntity();
resultRequisition = FCCREQRequisition.GetFacadeCreate().Add(rEQRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No);
pRMMaterialReceiveEntity.RequisitionID = resultRequisition;
if (resultRequisition > 0)
{
rEQRequisitionItemEntity = BuildREQRequisitionItemEntity(resultRequisition);
}
}
if (rEQRequisitionItemEntity != null)
{
resultRequisitionItem = FCCREQRequisitionItem.GetFacadeCreate().Add(rEQRequisitionItemEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
#endregion
#region MRR
Int64 resultOne = -1;
if (pRMMaterialReceiveEntity.IsNew)
{
resultOne = FCCPRMMaterialReceive.GetFacadeCreate().Add(pRMMaterialReceiveEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveEntity.FLD_NAME_MaterialReceiveID, pRMMaterialReceiveEntity.MaterialReceiveID.ToString(), SQLMatchType.Equal);
resultOne = FCCPRMMaterialReceive.GetFacadeCreate().Update(pRMMaterialReceiveEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
#endregion
if (resultOne > 0 && resultRequisitionItem > 0)
{
#region Material Receive Item Map
Int64 resultTwo = -1;
PRMMaterialReceiveItemMapEntity pRMMaterialReceiveItemMapEntity = BuildPRMMaterialReceiveItemMapEntity(resultOne, resultRequisitionItem);
resultTwo = FCCPRMMaterialReceiveItemMap.GetFacadeCreate().Add(pRMMaterialReceiveItemMapEntity, DatabaseOperationType.Add, TransactionRequired.No);
#endregion
try
{
#region Inventory
Int64 _employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
Int64 _projectID = Int64.Parse(ddlProjectID.SelectedValue);
INVStoreEntity storeEntity = INVManager.GetDefaultStore(_projectID);
Int64 storeID = storeEntity.StoreID;
INVStoreUnitEntity storeUnitEntity = INVManager.GetDefaultStoreUnit(storeID);
Int64 storeUnitID = storeUnitEntity.StoreUnitID;
String fe_requisitionItem = SqlExpressionBuilder.PrepareFilterExpression("REQRequisitionItem." + REQRequisitionItemEntity.FLD_NAME_RequisitionItemID, resultRequisitionItem.ToString(), SQLMatchType.Equal);
IList <REQRequisitionItem_DetailedEntity> lst = FCCREQRequisitionItem_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_requisitionItem);
Int64 _itemID = 0;
Decimal _rate = 0;
Int64 brandID = MasterDataConstants.ItemDefaults.DEFAULT_BRAD;
Int64 regionID = MasterDataConstants.ItemDefaults.DEFAULT_REGION;
Int64 countryID = MasterDataConstants.ItemDefaults.DEFAULT_COUNTRY;
if (lst != null && lst.Count > 0)
{
_itemID = lst[0].ItemID;
brandID = (Int64)lst[0].BrandID;
regionID = (Int64)lst[0].RegionID;
countryID = (Int64)lst[0].CountryID;
_rate = lst[0].Rate;
}
Boolean invResult = INVManager.AddItemsToStoreUnit(_itemID, brandID, regionID, countryID, "", Int64.Parse(txtReceiveQty.Text.ToString()), MiscUtil.GetLocalIP(), _employeeID, _rate, txtRequisition.Text, ddlWorkOrderID.SelectedItem.Text, resultOne.ToString(), "", Int64.Parse(ddlProjectID.SelectedValue), storeID, storeUnitID);
#endregion
}
catch (Exception ex)
{
}
_MaterialReceiveID = resultOne;
PrepareInitialViewSave();
btnAddNew.Visible = true;
if (pRMMaterialReceiveEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Material Receive Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Material Receive Information has been updated successfully.", false);
}
}
else
{
if (pRMMaterialReceiveEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Material Receive Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Material Receive Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
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 btnForward_Click(object sender, EventArgs e)
{
if (chbxAutoForwardTo.Checked)
{
APApprovalProcessEntity aPApprovalProcessEntity = APRobot.GetApprovalProcessByTypeAndReference(MasterDataConstants.APType.BILL, CMBillID);
IList <APMemberFeedbackEntity> feedbackList = APRobot.GetAllMemberFeedbacks(aPApprovalProcessEntity.APApprovalProcessID);
IList <APMemberFeedbackEntity> ordered_list = feedbackList.OrderBy(x => x.SequenceNo).ToList();
APPanelForwardMemberEntity aPPanelForwardMemberEntity = APRobot.GetAPPanelForwardMemberByID(Int64.Parse(ddlForwardTo.SelectedValue));
var existsInfo = (from s in ordered_list
where s.EmployeeID.ToString() == aPPanelForwardMemberEntity.EmployeeID.ToString()
select s);
if (existsInfo != null && existsInfo.Count() > 0)
{
MiscUtil.ShowMessage(lblMessage, "Member Already Exists in the Approval Panel", true);
return;
}
APMemberFeedbackEntity currentEmployeeInfo = (from r in ordered_list
where r.EmployeeID.ToString() == MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember).ToString()
select r).FirstOrDefault();
if (currentEmployeeInfo != null)
{
ordered_list = (from m in ordered_list
where m.SequenceNo > currentEmployeeInfo.SequenceNo
select m).ToList();
APMemberFeedbackEntity aPMemberFeedbackEntity = new APMemberFeedbackEntity();
aPMemberFeedbackEntity.APApprovalProcessID = aPApprovalProcessEntity.APApprovalProcessID;
aPMemberFeedbackEntity.DepartmentID = aPPanelForwardMemberEntity.DepartmentID;
aPMemberFeedbackEntity.EmployeeID = aPPanelForwardMemberEntity.EmployeeID;
aPMemberFeedbackEntity.SequenceNo = currentEmployeeInfo.SequenceNo + 1;
aPMemberFeedbackEntity.APFeedbackID = MasterDataConstants.APFeedback.NOT_YET_REQUESTED;
aPMemberFeedbackEntity.FeedbackRequestDate = DateTime.Now;
aPMemberFeedbackEntity.FeedbackLastResponseDate = null;
aPMemberFeedbackEntity.FeedbackSubmitDate = null;
aPMemberFeedbackEntity.IsProxyEmployeeEnabled = false;
aPMemberFeedbackEntity.ProxyEmployeeID = null;
Int64 aPMemberFeedbackID = FCCAPMemberFeedback.GetFacadeCreate().Add(aPMemberFeedbackEntity, DatabaseOperationType.Add, TransactionRequired.No);
foreach (APMemberFeedbackEntity ent in ordered_list)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(APMemberFeedbackEntity.FLD_NAME_APMemberFeedbackID, ent.APMemberFeedbackID.ToString(), SQLMatchType.Equal);
ent.SequenceNo += 1;
FCCAPMemberFeedback.GetFacadeCreate().Update(ent, fe, DatabaseOperationType.Update, TransactionRequired.No);
}
APRobot.UpdateApprovalProcessFeedback(APMemberFeedbackID, MasterDataConstants.APFeedback.APPROVED, MasterDataConstants.APType.BILL, CMBillID);
String remarks = txtRemarks.Text.Trim();
if (remarks.IsNullOrEmpty())
{
remarks = "Approved";
}
remarks = AddProxyMemberInfo(remarks);
APRobot.AddAPMemberFeedbackRemarks(APMemberFeedbackID, remarks);
EnableDisableApprovalButtons();
MiscUtil.ShowMessage(lblMessage, "You have Approved Successfully", UIConstants.MessageType.GREEN);
PrepareInitialView();
BindList();
RedirectPageToPendingList();
}
}
//Previous Code
else
{
if (ddlRejectTo.Items.Count > 0)
{
APRobot.UpdateMemberFeedbackFeedback(APMemberFeedbackID, MasterDataConstants.APFeedback.FORWARDED);
APRobot.UpdateMemberFeedbackLastResponseDate(APMemberFeedbackID, DateTime.Now);
String remarks = txtRemarks.Text.Trim();
if (remarks.IsNullOrEmpty())
{
remarks = "Forwarded";
}
remarks = AddProxyMemberInfo(remarks);
Int64 aPMemberFeedbackRemarksID = APRobot.AddAPMemberFeedbackRemarks(APMemberFeedbackID, remarks);
Int64 aPPanelForwardMemberID = Int64.Parse(ddlForwardTo.SelectedValue);
APPanelForwardMemberEntity aPPanelForwardMemberEntity = APRobot.GetAPPanelForwardMemberByID(aPPanelForwardMemberID);
APForwardInfoEntity aPForwardInfoEntity = new APForwardInfoEntity();
aPForwardInfoEntity.APMemberFeedbackID = APMemberFeedbackID;
aPForwardInfoEntity.APApprovalProcessID = APApprovalProcessID;
aPForwardInfoEntity.APMemberFeedbackRemarksID = aPMemberFeedbackRemarksID;
aPForwardInfoEntity.DepartmentID = aPPanelForwardMemberEntity.DepartmentID;
aPForwardInfoEntity.EmployeeID = aPPanelForwardMemberEntity.EmployeeID;
aPForwardInfoEntity.CommentRequestDate = DateTime.Now;
aPForwardInfoEntity.CommentSubmitDate = null;
aPForwardInfoEntity.APMemberComment = txtForwardRemarks.Text.Trim();
aPForwardInfoEntity.APForwardMemberComment = String.Empty;
FCCAPForwardInfo.GetFacadeCreate().Add(aPForwardInfoEntity, DatabaseOperationType.Add, TransactionRequired.No);
MiscUtil.ShowMessage(lblMessage, "You have forwarded the thread successfully", UIConstants.MessageType.GREEN);
PrepareInitialView();
BindList();
#region Forwarded Mail
String MailBody = String.Empty;
String Subject = String.Empty;
StringBuilder sb = new StringBuilder();
sb.Append("Dear Sir,");
sb.Append("<br/>");
sb.Append("This is a auto generated mail from the ERP.");
sb.Append("<br/>");
sb.Append("A Bill Request is Forwarded Request is waiting for your approval");
sb.Append("<br/>");
sb.Append("<br/>");
sb.Append("-");
sb.Append("<br/>");
sb.Append("Thanks");
sb.Append("<br/>");
sb.Append("ERP System");
MailBody = sb.ToString();
Subject = "ERP, Bill, Forwarded";
MailBody = @"Please note that a Bill is Forwarded.-Thanks ERP System";
HREmployeeEntity _hREmployeeEntity = FCCHREmployee.GetFacadeCreate().GetByID(aPForwardInfoEntity.EmployeeID);
if (_hREmployeeEntity != null)
{
String[] sendToMail = new String[] { _hREmployeeEntity.PrimaryEmail };
MiscUtil.SendMail(sendToMail, Subject, MailBody);
}
#endregion
//RedirectPageToForwardList();
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to forward", UIConstants.MessageType.RED);
}
}
}
private CRMBuyerBasicInfoEntity BuildCRMBuyerBasicInfoEntity()
{
CRMBuyerBasicInfoEntity cRMBuyerBasicInfoEntity = CurrentCRMBuyerBasicInfoEntity;
if (ddlBuyerTypeID.Items.Count > 0)
{
if (ddlBuyerTypeID.SelectedValue == "0")
{
}
else
{
cRMBuyerBasicInfoEntity.BuyerTypeID = Int64.Parse(ddlBuyerTypeID.SelectedValue);
}
}
cRMBuyerBasicInfoEntity.ContactFullName = txtContactFullName.Text.Trim();
cRMBuyerBasicInfoEntity.CompanyName = txtCompanyName.Text.Trim();
cRMBuyerBasicInfoEntity.Designation = txtDesignation.Text.Trim();
#region Image
String ImageUrlpath;
if (fuImageUrl.HasFile == true && cRMBuyerBasicInfoEntity.ImageUrl.IsNotNullOrEmpty())
{
if (File.Exists(Server.MapPath(cRMBuyerBasicInfoEntity.ImageUrl)))
{
File.Delete(Server.MapPath(cRMBuyerBasicInfoEntity.ImageUrl));
}
ImageUrlpath = FileUploadConstants.CRM.Buyer + Guid.NewGuid() + fuImageUrl.FileName;
fuImageUrl.SaveAs(Server.MapPath(ImageUrlpath));
cRMBuyerBasicInfoEntity.ImageUrl = ImageUrlpath;
}
if (cRMBuyerBasicInfoEntity.ImageUrl.IsNotNullOrEmpty() && fuImageUrl.HasFile == false)
{
cRMBuyerBasicInfoEntity.ImageUrl = cRMBuyerBasicInfoEntity.ImageUrl;
}
if (fuImageUrl.HasFile == false && cRMBuyerBasicInfoEntity.ImageUrl.IsNullOrEmpty())
{
cRMBuyerBasicInfoEntity.ImageUrl = null;
}
if (fuImageUrl.HasFile == true && cRMBuyerBasicInfoEntity.ImageUrl.IsNullOrEmpty())
{
ImageUrlpath = FileUploadConstants.CRM.Buyer + Guid.NewGuid() + fuImageUrl.FileName;
fuImageUrl.SaveAs(Server.MapPath(ImageUrlpath));
cRMBuyerBasicInfoEntity.ImageUrl = ImageUrlpath;
}
#endregion Image
if (ddlInterestedProjectCategoryID.Items.Count > 0)
{
if (ddlInterestedProjectCategoryID.SelectedValue == "0")
{
}
else
{
cRMBuyerBasicInfoEntity.InterestedProjectCategoryID = Int64.Parse(ddlInterestedProjectCategoryID.SelectedValue);
}
}
cRMBuyerBasicInfoEntity.MobileNo = txtMobileNo.Text.Trim();
cRMBuyerBasicInfoEntity.MobileNo2 = txtMobileNo2.Text.Trim();
cRMBuyerBasicInfoEntity.LandPhone = txtLandPhone.Text.Trim();
cRMBuyerBasicInfoEntity.LandPhoneOffice = txtLandPhoneOffice.Text.Trim();
cRMBuyerBasicInfoEntity.FaxNumber = txtFaxNumber.Text.Trim();
cRMBuyerBasicInfoEntity.PresentAddress = txtPresentAddress.Text.Trim();
cRMBuyerBasicInfoEntity.PresentAddressOffice = txtPresentAddressOffice.Text.Trim();
cRMBuyerBasicInfoEntity.Email = txtEmail.Text.Trim();
cRMBuyerBasicInfoEntity.Email2 = txtEmail2.Text.Trim();
if (txtDOB.Text.Trim().IsNotNullOrEmpty())
{
cRMBuyerBasicInfoEntity.DOB = MiscUtil.ParseToDateTime(txtDOB.Text);
}
else
{
cRMBuyerBasicInfoEntity.DOB = null;
}
if (!txtNoOfChildren.Text.Trim().IsNullOrEmpty())
{
cRMBuyerBasicInfoEntity.NoOfChildren = Decimal.Parse(txtNoOfChildren.Text.Trim());
}
else
{
cRMBuyerBasicInfoEntity.NoOfChildren = null;
}
if (ddlInterestedLandLocationID.Items.Count > 0)
{
if (ddlInterestedLandLocationID.SelectedValue == "0")
{
cRMBuyerBasicInfoEntity.InterestedLandLocationID = null;
}
else
{
cRMBuyerBasicInfoEntity.InterestedLandLocationID = Int64.Parse(ddlInterestedLandLocationID.SelectedValue);
}
}
if (ddlCityID.Items.Count > 0)
{
if (ddlCityID.SelectedValue == "0")
{
cRMBuyerBasicInfoEntity.CityID = null;
}
else
{
cRMBuyerBasicInfoEntity.CityID = Int64.Parse(ddlCityID.SelectedValue);
}
}
if (!txtAreaNeededFrom.Text.Trim().IsNullOrEmpty())
{
cRMBuyerBasicInfoEntity.AreaNeededFrom = Decimal.Parse(txtAreaNeededFrom.Text.Trim());
}
else
{
cRMBuyerBasicInfoEntity.AreaNeededFrom = null;
}
if (!txtAreaNeededTo.Text.Trim().IsNullOrEmpty())
{
cRMBuyerBasicInfoEntity.AreaNeededTo = Decimal.Parse(txtAreaNeededTo.Text.Trim());
}
else
{
cRMBuyerBasicInfoEntity.AreaNeededTo = null;
}
if (!txtParkingNeeded.Text.Trim().IsNullOrEmpty())
{
cRMBuyerBasicInfoEntity.ParkingNeeded = Decimal.Parse(txtParkingNeeded.Text.Trim());
}
else
{
cRMBuyerBasicInfoEntity.ParkingNeeded = null;
}
if (ddlAreaUnitID.Items.Count > 0)
{
if (ddlAreaUnitID.SelectedValue == "0")
{
cRMBuyerBasicInfoEntity.AreaUnitID = null;
}
else
{
cRMBuyerBasicInfoEntity.AreaUnitID = Int64.Parse(ddlAreaUnitID.SelectedValue);
}
}
if (!txtToiletNeeded.Text.Trim().IsNullOrEmpty())
{
cRMBuyerBasicInfoEntity.ToiletNeeded = Decimal.Parse(txtToiletNeeded.Text.Trim());
}
else
{
cRMBuyerBasicInfoEntity.ToiletNeeded = null;
}
if (!txtUnitNeeded.Text.Trim().IsNullOrEmpty())
{
cRMBuyerBasicInfoEntity.UnitNeeded = Decimal.Parse(txtUnitNeeded.Text.Trim());
}
else
{
cRMBuyerBasicInfoEntity.UnitNeeded = null;
}
if (ddlAdvertiseWayID.Items.Count > 0)
{
if (ddlAdvertiseWayID.SelectedValue == "0")
{
cRMBuyerBasicInfoEntity.AdvertiseWayID = null;
}
else
{
cRMBuyerBasicInfoEntity.AdvertiseWayID = Int64.Parse(ddlAdvertiseWayID.SelectedValue);
}
}
if (ddlLeadGeneratedByEmployeeID.Items.Count > 0)
{
if (ddlLeadGeneratedByEmployeeID.SelectedValue == "0")
{
cRMBuyerBasicInfoEntity.LeadGeneratedByEmployeeID = null;
}
else
{
cRMBuyerBasicInfoEntity.LeadGeneratedByEmployeeID = Int64.Parse(ddlLeadGeneratedByEmployeeID.SelectedValue);
}
}
if (ddlLeadManagedByOneEmployeeID.Items.Count > 0)
{
if (ddlLeadManagedByOneEmployeeID.SelectedValue == "0")
{
cRMBuyerBasicInfoEntity.LeadManagedByOneEmployeeID = null;
}
else
{
cRMBuyerBasicInfoEntity.LeadManagedByOneEmployeeID = Int64.Parse(ddlLeadManagedByOneEmployeeID.SelectedValue);
}
}
if (ddlLeadManagedByTwoEmployeeID.Items.Count > 0)
{
if (ddlLeadManagedByTwoEmployeeID.SelectedValue == "0")
{
cRMBuyerBasicInfoEntity.LeadManagedByTwoEmployeeID = null;
}
else
{
cRMBuyerBasicInfoEntity.LeadManagedByTwoEmployeeID = Int64.Parse(ddlLeadManagedByTwoEmployeeID.SelectedValue);
}
}
if (txtLeadConversionDate.Text.Trim().IsNotNullOrEmpty())
{
cRMBuyerBasicInfoEntity.LeadConversionDate = MiscUtil.ParseToDateTime(txtLeadConversionDate.Text);
}
else
{
cRMBuyerBasicInfoEntity.LeadConversionDate = null;
}
if (ddlProspectForProject.Items.Count > 0)
{
if (ddlProspectForProject.SelectedValue == "0")
{
cRMBuyerBasicInfoEntity.ProspectForProject = null;
}
else
{
cRMBuyerBasicInfoEntity.ProspectForProject = Int64.Parse(ddlProspectForProject.SelectedValue);
}
}
cRMBuyerBasicInfoEntity.Remarks = txtRemarks.Text.Trim();
Int64 currentEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
if (currentEmployeeID > 0)
{
cRMBuyerBasicInfoEntity.CreatedByEmployeeID = currentEmployeeID;
}
cRMBuyerBasicInfoEntity.IP = MiscUtil.GetLocalIP();
cRMBuyerBasicInfoEntity.CreateDate = System.DateTime.Now;
return(cRMBuyerBasicInfoEntity);
}
protected void odsOTIssue_Detailed_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe = String.Empty;
switch (PageAPType)
{
case MasterDataConstants.IssuePageType.ADHOC_ISSUE:
fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueIdentityCategoryID, MasterDataConstants.IssueIdentityCategory.ADHOC_ISSUE.ToString(), SQLMatchType.Equal);
lblIssueList.Text = "Adhoc Issue List";
break;
case MasterDataConstants.IssuePageType.PROJECT_ADHOC_ISSUE:
fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueIdentityCategoryID, MasterDataConstants.IssueIdentityCategory.PROJECT_ADHOC_ISSUE.ToString(), SQLMatchType.Equal);
lblIssueList.Text = "Project Issue List";
break;
case MasterDataConstants.IssuePageType.MY_ISSUE_LIST:
fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_CreatedByMemberID, CurrentMember.MemberID.ToString(), SQLMatchType.Equal);
Int64 employeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
if (employeeID > 0)
{
String fe_assignToEmployee = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_AssignedToEmployeeID, employeeID.ToString(), SQLMatchType.Equal);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.OR, fe_assignToEmployee);
String fe_resource1 = SqlExpressionBuilder.PrepareFilterExpression(ResourceEntity.FLD_NAME_ResourceCategoryID, MasterDataConstants.ResourceCategory.EMPLOYEE.ToString(), SQLMatchType.Equal);
String fe_resource2 = SqlExpressionBuilder.PrepareFilterExpression(ResourceEntity.FLD_NAME_ReferenceID, employeeID.ToString(), SQLMatchType.Equal);
String fe_resource = SqlExpressionBuilder.PrepareFilterExpression(fe_resource1, SQLJoinType.AND, fe_resource2);
IList <ResourceEntity> lstResource = FCCResource.GetFacadeCreate().GetIL(null, null, String.Empty, fe_resource, DatabaseOperationType.LoadWithFilterExpression);
if (lstResource != null && lstResource.Count > 0)
{
String fe_Assigned_Issue = SqlExpressionBuilder.PrepareFilterExpression(OTIssueAssignedResourceEntity.FLD_NAME_ResourceID, lstResource[0].ResourceID.ToString(), SQLMatchType.Equal);
IList <OTIssueAssignedResourceEntity> lstIssueAssignedResource = FCCOTIssueAssignedResource.GetFacadeCreate().GetIL(null, null, String.Empty, fe_Assigned_Issue, DatabaseOperationType.LoadWithFilterExpression);
if (lstIssueAssignedResource != null && lstIssueAssignedResource.Count > 0)
{
String compositeIssueID = String.Empty;
foreach (OTIssueAssignedResourceEntity ent in lstIssueAssignedResource)
{
compositeIssueID += ent.IssueID + ",";
}
if (compositeIssueID.IsNotNullOrEmpty())
{
compositeIssueID = compositeIssueID.Substring(0, compositeIssueID.Length - 1);
String fe_issue = "OTIssue.IssueID in(" + compositeIssueID + ")";
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.OR, fe_issue);
}
}
}
}
lblIssueList.Text = "My Issue List";
break;
default:
fe = SqlExpressionBuilder.PrepareFilterExpression("OTIssue." + OTIssueEntity.FLD_NAME_IssueIdentityCategoryID, MasterDataConstants.IssueIdentityCategory.PROJECT_ADHOC_ISSUE.ToString(), SQLMatchType.Equal);
break;
}
if (chbxFilter.Checked)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("OTIssue.Title", txtSearchText.Text.ToString(), SQLMatchType.LikeWithBothMath);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("MDIssuePriority.Name", txtSearchText.Text.ToString(), SQLMatchType.LikeWithSuffixMath);
String fe3 = SqlExpressionBuilder.PrepareFilterExpression("MDIssueStatus.Name", txtSearchText.Text.ToString(), SQLMatchType.LikeWithSuffixMath);
Int64 issueID;
Int64.TryParse(txtSearchText.Text.Trim().ToString(), out issueID);
String fe6 = SqlExpressionBuilder.PrepareFilterExpression("OTIssue.IssueID", issueID.ToString(), SQLMatchType.Equal);
String fe4 = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.OR, fe2);
String fe5 = SqlExpressionBuilder.PrepareFilterExpression(fe3, SQLJoinType.OR, fe4);
String fe7 = SqlExpressionBuilder.PrepareFilterExpression(fe5, SQLJoinType.OR, fe6);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe7);
}
e.InputParameters["filterExpression"] = fe;
}
private CRMSurveyEntity BuildCRMSurveyEntity()
{
CRMSurveyEntity cRMSurveyEntity = CurrentCRMSurveyEntity;
cRMSurveyEntity.SurveyMasterID = OverviewSurveryMasterID;
if (ddlSurveyOwnerID.Items.Count > 0)
{
if (ddlSurveyOwnerID.SelectedValue == "0")
{
}
else
{
cRMSurveyEntity.SurveyOwnerID = Int64.Parse(ddlSurveyOwnerID.SelectedValue);
}
}
if (ddlAreaID.Items.Count > 0)
{
if (ddlAreaID.SelectedValue == "0")
{
}
else
{
cRMSurveyEntity.AreaID = Int64.Parse(ddlAreaID.SelectedValue);
}
}
cRMSurveyEntity.Description = txtDescription.Text.Trim();
cRMSurveyEntity.PlotAddress = txtPlotAddress.Text.Trim();
if (!txtApproximatePlotSize.Text.Trim().IsNullOrEmpty())
{
cRMSurveyEntity.ApproximatePlotSize = Decimal.Parse(txtApproximatePlotSize.Text.Trim());
}
if (ddlAreaUnitID.Items.Count > 0)
{
if (ddlAreaUnitID.SelectedValue == "0")
{
}
else
{
cRMSurveyEntity.AreaUnitID = Int64.Parse(ddlAreaUnitID.SelectedValue);
}
}
if (!txtApproximateFloorSizeSft.Text.Trim().IsNullOrEmpty())
{
cRMSurveyEntity.ApproximateFloorSizeSft = Decimal.Parse(txtApproximateFloorSizeSft.Text.Trim());
}
if (!txtFloors.Text.Trim().IsNullOrEmpty())
{
cRMSurveyEntity.Floors = Decimal.Parse(txtFloors.Text.Trim());
}
if (!txtApproximateTotalSpaceSft.Text.Trim().IsNullOrEmpty())
{
cRMSurveyEntity.ApproximateTotalSpaceSft = Decimal.Parse(txtApproximateTotalSpaceSft.Text.Trim());
}
cRMSurveyEntity.Basements = txtBasements.Text.Trim();
cRMSurveyEntity.NoOfCarParking = txtNoOfCarParking.Text.Trim();
cRMSurveyEntity.ACSystem = txtACSystem.Text.Trim();
cRMSurveyEntity.GeneratorBackup = txtGeneratorBackup.Text.Trim();
cRMSurveyEntity.LiftsCapacity = txtLiftsCapacity.Text.Trim();
cRMSurveyEntity.ToiletsPerFloor = txtToiletsPerFloor.Text.Trim();
cRMSurveyEntity.AvailableFloorSft = txtAvailableFloorSft.Text.Trim();
cRMSurveyEntity.AvailableForOccupancy = txtAvailableForOccupancy.Text.Trim();
cRMSurveyEntity.RentalRateBDTPerSft = txtRentalRateBDTPerSft.Text.Trim();
cRMSurveyEntity.SellingRateBDTPerSft = txtSellingRateBDTPerSft.Text.Trim();
cRMSurveyEntity.HandoverTime = txtHandoverTime.Text.Trim();
if (ddlSurveyBuildingStatusID.Items.Count > 0)
{
if (ddlSurveyBuildingStatusID.SelectedValue == "0")
{
}
else
{
cRMSurveyEntity.SurveyBuildingStatusID = Int64.Parse(ddlSurveyBuildingStatusID.SelectedValue);
}
}
if (ddlSurveySourceInformationID.Items.Count > 0)
{
if (ddlSurveySourceInformationID.SelectedValue == "0")
{
}
else
{
cRMSurveyEntity.SurveySourceInformationID = Int64.Parse(ddlSurveySourceInformationID.SelectedValue);
}
}
cRMSurveyEntity.SourcePersonInformation = txtSourcePersonInformation.Text.Trim();
cRMSurveyEntity.ContactInfo = txtContactInfo.Text.Trim();
cRMSurveyEntity.Remarks = txtRemarks.Text.Trim();
cRMSurveyEntity.AdditionalRemarks = txtAdditionalRemarks.Text.Trim();
cRMSurveyEntity.OthersRemarks = txtOthersRemarks.Text.Trim();
cRMSurveyEntity.CreateDate = System.DateTime.Now;
if (txtSurveyDate.Text.Trim().IsNotNullOrEmpty())
{
cRMSurveyEntity.SurveyDate = MiscUtil.ParseToDateTime(txtSurveyDate.Text);
}
cRMSurveyEntity.IP = MiscUtil.GetLocalIP();
cRMSurveyEntity.SurveyByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
cRMSurveyEntity.CreateByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
return(cRMSurveyEntity);
}
protected void btnPnlSaveAdditionalQty_Click(object sender, EventArgs e)
{
PRMBOQDetailEntity pRMBOQDetailEntity = FCCPRMBOQDetail.GetFacadeCreate().GetByID(_CurrentBOQDetailIDPopup);
if (pRMBOQDetailEntity != null && pRMBOQDetailEntity.BOQDetailID > 0)
{
Decimal additionalQty = 0;
Decimal.TryParse(txtQty.Text.Trim().ToString(), out additionalQty);
PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity = new PRMAvailableBOQQtyForRequisitionEntity();
pRMAvailableBOQQtyForRequisitionEntity.IsBOQ = true;
pRMAvailableBOQQtyForRequisitionEntity.PreBOQOrBOQDetailID = _CurrentBOQDetailIDPopup;
pRMAvailableBOQQtyForRequisitionEntity.ItemID = pRMBOQDetailEntity.ItemID;
pRMAvailableBOQQtyForRequisitionEntity.Qty = additionalQty;
pRMAvailableBOQQtyForRequisitionEntity.CreateDate = DateTime.Now;
pRMAvailableBOQQtyForRequisitionEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
PRMBOQEntity pRMBOQEntity = FCCPRMBOQ.GetFacadeCreate().GetByID(pRMBOQDetailEntity.BOQID);
pRMAvailableBOQQtyForRequisitionEntity.ProjectID = pRMBOQEntity.ProjectID;
Int64 result = -1;
result = FCCPRMAvailableBOQQtyForRequisition.GetFacadeCreate().Add(pRMAvailableBOQQtyForRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No);
if (result > 0)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQDetailEntity.FLD_NAME_BOQDetailID, _CurrentBOQDetailIDPopup.ToString(), SQLMatchType.Equal);
pRMBOQDetailEntity.TotalQty = pRMBOQDetailEntity.TotalQty + additionalQty;
FCCPRMBOQDetail.GetFacadeCreate().Update(pRMBOQDetailEntity, fe, DatabaseOperationType.Update, TransactionRequired.No);
IList <ListViewDataItem> list = lvPRMBOQDetail.Items;
if (list != null && list.Count > 0)
{
Int32 tempDataItemIndex = 0;
foreach (ListViewDataItem lvdi in list)
{
DataKey currentDataKey = lvPRMBOQDetail.DataKeys[tempDataItemIndex++];
Int64 intBOQDetailID = (Int64)currentDataKey["BOQDetailID"];
if (_CurrentBOQDetailIDPopup == intBOQDetailID)
{
TextBox txtTotalQtyLV = (TextBox)lvdi.FindControl("txtTotalQtyLV");
txtTotalQtyLV.Text = pRMBOQDetailEntity.TotalQty.ToString();
}
}
}
BindPRMBOQDetailList();
#region BOQ Floor Detail
String fe_projectFloor = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQFloorDetailEntity.FLD_NAME_BOQDetailID, _CurrentBOQDetailIDPopup.ToString(), SQLMatchType.Equal);
IList <PRMBOQFloorDetailEntity> lstPRMBOQFloorDetail = FCCPRMBOQFloorDetail.GetFacadeCreate().GetIL(null, null, String.Empty, fe_projectFloor, DatabaseOperationType.LoadWithFilterExpression);
if (lstPRMBOQFloorDetail != null && lstPRMBOQFloorDetail.Count > 0)
{
Int64 totalfloorCount = lstPRMBOQFloorDetail.Count;
Decimal avgQty = pRMBOQDetailEntity.TotalQty / totalfloorCount;
foreach (PRMBOQFloorDetailEntity ent in lstPRMBOQFloorDetail)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQFloorDetailEntity.FLD_NAME_BOQFloorDetailID, ent.BOQFloorDetailID.ToString(), SQLMatchType.Equal);
ent.Qty = avgQty;
FCCPRMBOQFloorDetail.GetFacadeCreate().Update(ent, fe1, DatabaseOperationType.Update, TransactionRequired.No);
}
}
#endregion
this.ModalPopupExtender1.Hide();
}
}
}
protected void btnAddToProject_Click(object sender, EventArgs e)
{
if (ddlProjectID.Items.Count > 0 && ddlProjectID.SelectedValue != "0")
{
Int64 itemID = 0;
if (ViewState["LastUpdatedItemID"] != null)
{
itemID = (Int64)ViewState["LastUpdatedItemID"];
}
if (itemID > 0)
{
String fe_itemDefault = SqlExpressionBuilder.PrepareFilterExpression(MDItemDefaultEntity.FLD_NAME_ItemID, itemID.ToString(), SQLMatchType.Equal);
IList <MDItemDefaultEntity> lstmDItemDefaultEntity = FCCMDItemDefault.GetFacadeCreate().GetIL(null, null, String.Empty, fe_itemDefault, DatabaseOperationType.LoadWithFilterExpression);
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQEntity.FLD_NAME_ProjectID, ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal);
IList <PRMPreBOQEntity> preBOQList = FCCPRMPreBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
if (preBOQList != null && preBOQList.Count > 0)
{
Int64 preBOQID = preBOQList[0].PreBOQID;
Decimal totalQty = 0;
Decimal.TryParse(txtQty.Text.Trim().ToString(), out totalQty);
Decimal currentPrice = MiscUtil.GetCurrentPrice(itemID, lstmDItemDefaultEntity[0].BrandID, lstmDItemDefaultEntity[0].SupplierID, lstmDItemDefaultEntity[0].RegionID, lstmDItemDefaultEntity[0].CountryID);
switch (preBOQList[0].IsLocked)
{
case true:
#region Add Item to BOQ
try
{
String fe_boq = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQEntity.FLD_NAME_ProjectID, ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal);
IList <PRMBOQEntity> lstPRMBOQ = FCCPRMBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe_boq, DatabaseOperationType.LoadWithFilterExpression);
if (lstPRMBOQ != null && lstPRMBOQ.Count > 0)
{
PRMBOQDetailEntity pRMBOQDeatEntity = new PRMBOQDetailEntity();
pRMBOQDeatEntity.BOQID = lstPRMBOQ[0].BOQID;
pRMBOQDeatEntity.ItemID = itemID;
pRMBOQDeatEntity.BrandID = lstmDItemDefaultEntity[0].BrandID;
pRMBOQDeatEntity.RegionID = lstmDItemDefaultEntity[0].RegionID;
pRMBOQDeatEntity.CountryID = lstmDItemDefaultEntity[0].CountryID;
pRMBOQDeatEntity.SupplierID = lstmDItemDefaultEntity[0].SupplierID;
pRMBOQDeatEntity.Remarks = "Directly Added From Item";
pRMBOQDeatEntity.IsRemoved = false;
pRMBOQDeatEntity.Rate = currentPrice;
pRMBOQDeatEntity.EntryDate = System.DateTime.Now;
pRMBOQDeatEntity.TotalQty = totalQty;
Int64 result_boq = -1;
result_boq = FCCPRMBOQDetail.GetFacadeCreate().Add(pRMBOQDeatEntity, DatabaseOperationType.Add, TransactionRequired.No);
if (result_boq > 0)
{
PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity = new PRMAvailableBOQQtyForRequisitionEntity();
pRMAvailableBOQQtyForRequisitionEntity.IsBOQ = true;
pRMAvailableBOQQtyForRequisitionEntity.PreBOQOrBOQDetailID = result_boq;
pRMAvailableBOQQtyForRequisitionEntity.ItemID = itemID;
pRMAvailableBOQQtyForRequisitionEntity.Qty = totalQty;
pRMAvailableBOQQtyForRequisitionEntity.CreateDate = DateTime.Now;
pRMAvailableBOQQtyForRequisitionEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
pRMAvailableBOQQtyForRequisitionEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue);
Int64 result_available = -1;
result_available = FCCPRMAvailableBOQQtyForRequisition.GetFacadeCreate().Add(pRMAvailableBOQQtyForRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No);
MiscUtil.ShowMessage(lblMessage, "Qty Added Successfully to Project Cost.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, "Some Error Occured.", true);
}
#endregion
break;
case false:
#region Add Item to Pre-BOQ
try
{
String fe_preBOQ = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQEntity.FLD_NAME_ProjectID, ddlProjectID.SelectedValue.ToString(), SQLMatchType.Equal);
IList <PRMPreBOQEntity> lstPRMPreBOQ = FCCPRMPreBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe_preBOQ, DatabaseOperationType.LoadWithFilterExpression);
if (lstPRMPreBOQ != null && lstPRMPreBOQ.Count > 0)
{
PRMPreBOQDetailEntity pRMPreBOQDeatEntity = new PRMPreBOQDetailEntity();
pRMPreBOQDeatEntity.PreBOQID = lstPRMPreBOQ[0].PreBOQID;
pRMPreBOQDeatEntity.ItemID = itemID;
pRMPreBOQDeatEntity.BrandID = lstmDItemDefaultEntity[0].BrandID;
pRMPreBOQDeatEntity.RegionID = lstmDItemDefaultEntity[0].RegionID;
pRMPreBOQDeatEntity.CountryID = lstmDItemDefaultEntity[0].CountryID;
pRMPreBOQDeatEntity.SupplierID = lstmDItemDefaultEntity[0].SupplierID;
pRMPreBOQDeatEntity.TotalQty = totalQty;
pRMPreBOQDeatEntity.Remarks = "Directly Added From Item";
pRMPreBOQDeatEntity.IsRemoved = false;
pRMPreBOQDeatEntity.Rate = currentPrice;
pRMPreBOQDeatEntity.EntryDate = System.DateTime.Now;
Int64 result_preboq = -1;
result_preboq = FCCPRMPreBOQDetail.GetFacadeCreate().Add(pRMPreBOQDeatEntity, DatabaseOperationType.Add, TransactionRequired.No);
if (result_preboq > 0)
{
PRMAvailableBOQQtyForRequisitionEntity pRMAvailableBOQQtyForRequisitionEntity = new PRMAvailableBOQQtyForRequisitionEntity();
pRMAvailableBOQQtyForRequisitionEntity.IsBOQ = false;
pRMAvailableBOQQtyForRequisitionEntity.PreBOQOrBOQDetailID = result_preboq;
pRMAvailableBOQQtyForRequisitionEntity.ItemID = itemID;
pRMAvailableBOQQtyForRequisitionEntity.Qty = totalQty;
pRMAvailableBOQQtyForRequisitionEntity.CreateDate = DateTime.Now;
pRMAvailableBOQQtyForRequisitionEntity.CreatedByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
pRMAvailableBOQQtyForRequisitionEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue);
Int64 result_available = -1;
result_available = FCCPRMAvailableBOQQtyForRequisition.GetFacadeCreate().Add(pRMAvailableBOQQtyForRequisitionEntity, DatabaseOperationType.Add, TransactionRequired.No);
MiscUtil.ShowMessage(lblMessage, "Qty Added Successfully to BOQ.", false);
}
}
}
catch (Exception)
{
MiscUtil.ShowMessage(lblMessage, "Some Error Occured.", true);
}
#endregion
break;
default:
break;
}
}
}
}
}
