private void ScatterData()
{
ServiceEmployee _service = new ServiceEmployee();
try
{
TBL_MP_Master_Employee_Qualification model = _service.GetEmployeeQualificationDBRecordByID(this.EmployeeQualificationID);
if (model != null)
{
txtQualification.Text = model.Qualification;
txtNameOfInstitute.Text = model.NameOfInstitute;
txtGradeClass.Text = model.Grade;
TBL_MP_Master_Employee emp = _service.GetEmployeeDbRecordByID(model.FK_EmployeeId);
this.Text = string.Format("{0} ({1}) - Update Qualification", emp.EmployeeName, emp.EmployeeCode);
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditEmployeeQualification::ScatterData", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ScatterData()
{
ServiceEmployee _service = new ServiceEmployee();
try
{
TBL_MP_Master_Employee_Relative model = _service.GetEmployeeRelativeDBRecordByID(this.EmployeeRelationshipID);
if (model != null)
{
txtRelativeName.Text = model.RelativeName;
txtRemark.Text = model.Remarks;
if (model.RelativeDOB != null)
{
dtDateOfBirth.Value = (DateTime)model.RelativeDOB;
}
else
{
dtDateOfBirth.Checked = false;
}
cboSelectRelation.SelectedItem = ((List <SelectListItem>)cboSelectRelation.DataSource).Where(x => x.ID == model.FK_UL_RelationID).FirstOrDefault();
}
TBL_MP_Master_Employee emp = _service.GetEmployeeDbRecordByID(SelectedEmployeeID);
this.Text = string.Format("{0} ({1}) - Add Relationship", emp.EmployeeName, emp.EmployeeCode);
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditEmployeeRelation::ScatterData", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmAddEditEmployeeQualification_Load(object sender, EventArgs e)
{
try
{
ServiceEmployee _service = new ServiceEmployee();
if (this.EmployeeQualificationID == 0)
{
txtQualification.Text = txtNameOfInstitute.Text = txtGradeClass.Text = string.Empty;
if (this.SelectedEmployeeID != 0)
{
TBL_MP_Master_Employee emp = _service.GetEmployeeDbRecordByID(SelectedEmployeeID);
this.Text = string.Format("{0} ({1}) - Add Qualification", emp.EmployeeName, emp.EmployeeCode);
}
}
else
{
ScatterData();
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditEmployeeQualification::frmAddEditEmployeeQualification_Load", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public string GetEmployeeNameByUserName(string uName)
{
string empName = string.Empty;
try
{
TBL_User_Master user = _dbContext.TBL_User_Master.Where(x => x.LoginId == uName).FirstOrDefault();
if (user != null)
{
TBL_MP_Master_Employee emp = _dbContext.TBL_MP_Master_Employee.Where(x => x.PK_EmployeeId == user.FK_EmployeeID).FirstOrDefault();
if (emp != null)
{
empName = emp.EmployeeName;
}
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ServiceUser::GetEmployeeNameByUserName", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(empName);
}
public void ScatterData()
{
ServiceEmployee _service = new ServiceEmployee();
try
{
TBL_MP_Master_Employee_MedicalDetail obj = (new ServiceEmployee()).GetEmployeeMedicalInfoDbRecord(this.EmployeeMedicalID);
if (obj != null)
{
//populate all textboxes,datepickers from obj
txtMedicalName.Text = obj.MedicalName;
cboRelation.SelectedItem = ((List <SelectListItem>)cboRelation.DataSource).Where(x => x.ID == obj.FK_UL_RelationID).FirstOrDefault();
txtCardNo.Text = obj.CardNo;
txtCardType.Text = obj.CardType;
txtCompanyName.Text = obj.CompanyName;
txtRemark.Text = obj.Remark;
chkIsActive.Checked = obj.IsActive;
dtIssueDate.Value = obj.IssueDate;
dtExpieryDate.Value = obj.ExpiryDate;
}
TBL_MP_Master_Employee emp = _service.GetEmployeeDbRecordByID(obj.fk_EmployeeId);
this.Text = string.Format("{0} ({1}) - Update Medical Info", emp.EmployeeName, emp.EmployeeCode);
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditMedicalInfo::ScatterData", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmAddEditEmployeeRelation_Load(object sender, EventArgs e)
{
try
{
ServiceEmployee _service = new ServiceEmployee();
PopulateRelationshipDropdown();
if (EmployeeRelationshipID == 0)
{
txtRelativeName.Text = txtRemark.Text = string.Empty;
dtDateOfBirth.Checked = false;
if (this.SelectedEmployeeID != 0)
{
TBL_MP_Master_Employee emp = _service.GetEmployeeDbRecordByID(SelectedEmployeeID);
this.Text = string.Format("{0} ({1}) - Add Relationship", emp.EmployeeName, emp.EmployeeCode);
}
}
else
{
ScatterData();
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditEmployeeRelation::frmAddEditEmployeeRelation_Load", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmAddEditMedicalInfo_Load(object sender, EventArgs e)
{
try
{
ServiceEmployee _service = new ServiceEmployee();
PopulateRelationshipDropdown();
if (EmployeeMedicalID == 0)
{
txtMedicalName.Text = txtCardNo.Text = txtCardType.Text = txtCompanyName.Text = txtRemark.Text = String.Empty;
dtExpieryDate.Checked = false;
chkIsActive.Checked = true;
if (this.selectedEmployeeMedicalID != 0)
{
TBL_MP_Master_Employee emp = _service.GetEmployeeDbRecordByID(selectedEmployeeMedicalID);
this.Text = string.Format("{0} ({1}) - Add Medical Info", emp.EmployeeName, emp.EmployeeCode);
}
}
else
{
ScatterData();
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditMedicalInfo::frmAddEditMedicalInfo_Load", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ScatterData()
{
ServiceEmployee _service = new ServiceEmployee();
try
{
TBL_MP_Master_Employee_LastEmployerDetail model = _service.GetLastEmployerInfoDBRecordByID(this.SelectID);
if (model != null)
{
txtName.Text = model.LastEmployerName;
txtAddress.Text = model.Address;
txtContactNo.Text = model.ContactNo.ToString();
chkIsActive.Checked = model.isActive;
}
TBL_MP_Master_Employee emp = _service.GetEmployeeDbRecordByID(SelectedEmployeeID);
this.Text = string.Format("{0} ({1}) - Update X-Employer's Info.", emp.EmployeeName, emp.EmployeeCode);
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditLastEmployerInfo::ScatterData", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmAddEditLastEmployerInfo_Load(object sender, EventArgs e)
{
try
{
ServiceEmployee _service = new ServiceEmployee();
if (this.SelectID == 0)
{
txtName.Text = txtAddress.Text = txtContactNo.Text = string.Empty;
chkIsActive.Checked = false;
if (this.SelectedEmployeeID != 0)
{
TBL_MP_Master_Employee emp = _service.GetEmployeeDbRecordByID(SelectedEmployeeID);
this.Text = string.Format("{0} ({1}) - Add Last Employer Info", emp.EmployeeName, emp.EmployeeCode);
}
}
else
{
ScatterData();
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditLastEmployerInfo::frmAddEditLastEmployerInfo_Load", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSelectProject_Click(object sender, EventArgs e)
{
try
{
frmGridMultiSelect frm = new frmGridMultiSelect(APP_ENTITIES.ACTIVE_PROJECT);
frm.SingleSelect = true;
if (frm.ShowDialog() == DialogResult.OK)
{
this.Cursor = Cursors.WaitCursor;
int selectedProjectID = frm.SelectedItems[0].ID;
List <int> _employeeIDs = (new ServiceAttendance()).GetEmployeeIDsWhoHaveAttendendaceForProject(selectedProjectID);
foreach (int empID in _employeeIDs)
{
OnSiteAttendanceModel model = new OnSiteAttendanceModel();
TBL_MP_Master_Employee emp = (new ServiceEmployee()).GetEmployeeDbRecordByID(empID);
if (emp != null)
{
model.EmployeeID = emp.PK_EmployeeId;
model.EmployeeCode = emp.EmployeeCode;
model.EmployeeName = emp.EmployeeName;
}
model.AttendanceDate = dtSiteAttendanceDate.Value;
model.AttendanceInTime = new DateTime(model.AttendanceDate.Year, model.AttendanceDate.Month, model.AttendanceDate.Day, 8, 45, 0);
model.AttendanceOutTime = new DateTime(model.AttendanceDate.Year, model.AttendanceDate.Month, model.AttendanceDate.Day, 17, 15, 0);
model.AttendanceType = ATTENDANCE_TYPE.PRESENT;
model.ProjectID = selectedProjectID;
model.ProjectName = (new ServiceProject()).GetProjectDBInfoByID(selectedProjectID).ProjectName;
model.Remarks = "Present";
if (listOnSiteATTENDANCE == null)
{
listOnSiteATTENDANCE = new BindingList <OnSiteAttendanceModel>();
}
listOnSiteATTENDANCE.Add(model);
}
listOnSiteATTENDANCE = AppCommon.ConvertToBindingList <OnSiteAttendanceModel>(listOnSiteATTENDANCE.OrderBy(x => x.EmployeeName).ToList());
gridOnSiteAttendance.DataSource = listOnSiteATTENDANCE;
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "PageManualAttendance::btnSelectProject_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Cursor = Cursors.Default;
}
private void ScatterData()
{
ServiceEmployee _service = new ServiceEmployee();
try
{
TBL_MP_Master_Employee model = _service.GetEmployeeDbRecordByID(this.EmployeeID);
if (model != null)
{
txtEmployeeCode.Text = model.EmployeeCode;
txtEmployeeName.Text = model.EmployeeName;
txtEmail.Text = model.EmailAddress;
txtMobileNo.Text = model.PhoneNo1;
cboDepartment.SelectedItem = ((List <SelectListItem>)cboDepartment.DataSource).Where(x => x.ID == model.FK_DepartmentId).FirstOrDefault();
cboDesignation.SelectedItem = ((List <SelectListItem>)cboDesignation.DataSource).Where(x => x.ID == model.FK_DesignationId).FirstOrDefault();
cboEmploymentType.SelectedItem = ((List <SelectListItem>)cboEmploymentType.DataSource).Where(x => x.ID == model.FK_EmploymentTypeID).FirstOrDefault();
chkIsActive.Checked = (bool)model.isActive;
chkHasResigned.Checked = (bool)model.IsResigned;
// txtUserName.Text = model.FK_LoginID;
//txtPassword.Text = model.FK_LoginPassword;
//txtUserName.Text = model.TBL_User_Master.
cboEmployeeBoss.SelectedItem = ((List <SelectListItem>)cboEmployeeBoss.DataSource).Where(x => x.ID == model.FK_BossID).FirstOrDefault();
TBL_MP_Master_Employee emp = _service.GetEmployeeDbRecordByID(EmployeeID);
this.Text = string.Format("{0} ({1}) - Add Relationship", emp.EmployeeName, emp.EmployeeCode);
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditEmployee::ScatterData", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnAddNewOnSiteAttendance_Click(object sender, EventArgs e)
{
try
{
frmGridMultiSelect frm = new frmGridMultiSelect(APP_ENTITIES.EMPLOYEES);
frm.SingleSelect = false;
if (frm.ShowDialog() == DialogResult.OK)
{
this.Cursor = Cursors.WaitCursor;
foreach (MultiSelectListItem item in frm.SelectedItems)
{
OnSiteAttendanceModel model = new OnSiteAttendanceModel();
TBL_MP_Master_Employee emp = (new ServiceEmployee()).GetEmployeeDbRecordByID(item.ID);
if (emp != null)
{
model.EmployeeID = emp.PK_EmployeeId;
model.EmployeeCode = emp.EmployeeCode;
model.EmployeeName = emp.EmployeeName;
}
model.AttendanceDate = dtSiteAttendanceDate.Value;
model.AttendanceInTime = new DateTime(model.AttendanceDate.Year, model.AttendanceDate.Month, model.AttendanceDate.Day, 8, 45, 0);
model.AttendanceOutTime = new DateTime(model.AttendanceDate.Year, model.AttendanceDate.Month, model.AttendanceDate.Day, 17, 15, 0);
model.AttendanceType = ATTENDANCE_TYPE.PRESENT;
model.Remarks = "";
List <TBL_MP_HR_ManualAttendance_Master> dbRecords = (new ServiceAttendance()).GetAttendanceRecordOfEmployeeOnDate(emp.PK_EmployeeId, model.AttendanceDate);
if (dbRecords.Count > 0)
{
TBL_MP_HR_ManualAttendance_Master attendanceRecord = dbRecords[0];
model.AttendanceType = (ATTENDANCE_TYPE)attendanceRecord.AttendanceType;
model.AttendanceInTime = attendanceRecord.AttendInTime;
model.AttendanceOutTime = attendanceRecord.AttendOutTime;
model.AtWarehouse = attendanceRecord.AtWarehouse;
if (attendanceRecord.FK_LeaveApplicationID != null)
{
model.LeaveApplicationID = (int)attendanceRecord.FK_LeaveApplicationID;
}
if (attendanceRecord.FK_CostCenterId != null)
{
model.ProjectID = (int)attendanceRecord.FK_CostCenterId;
model.ProjectName = attendanceRecord.TBL_MP_PMC_ProjectMaster.ProjectName;
}
model.Remarks = attendanceRecord.AttendanceRemarks;
}
if (listOnSiteATTENDANCE == null)
{
listOnSiteATTENDANCE = new BindingList <OnSiteAttendanceModel>();
}
listOnSiteATTENDANCE.Add(model);
}
gridOnSiteAttendance.DataSource = listOnSiteATTENDANCE;
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "PageManualAttendance::btnAddNewManualAttendance_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Cursor = Cursors.Default;
}
private void btnLogin_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
try
{
if (this.ValidateChildren() == true)
{
this.LoginSuccess = (new ServiceUsers()).IsVaidUser(txtUserName.Text.Trim(), txtPassword.Text.Trim());
if (LoginSuccess)
{
this.Cursor = Cursors.WaitCursor;
#region POPULATE USER SPECIFIC INFORMATION
Program.CURR_USER = new USER_SESSION();
Program.CURR_USER.UserName = txtUserName.Text;
Program.CURR_USER.Password = txtPassword.Text;
Program.CURR_USER.FinanicalYearText = cboFinYear.Text;
Program.CURR_USER.FinYearID = int.Parse(cboFinYear.SelectedValue.ToString());
Program.CURR_USER.CompanyID = int.Parse(cboCompany.SelectedValue.ToString());
Program.CURR_USER.BranchID = int.Parse(cboBranch.SelectedValue.ToString());
TBL_MP_Master_Employee emp = (new ServiceUsers()).GetEmployeeDBModelByUserName(txtUserName.Text);
if (emp == null)
{
MessageBox.Show("Unable to locate Employee Info. for the user", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Program.CURR_USER.UserFullName = emp.EmployeeName;
Program.CURR_USER.EmployeeID = emp.PK_EmployeeId;
Program.CURR_USER.EmailAddress = emp.EmailAddress;
if (emp.FK_DepartmentId != null)
{
Program.CURR_USER.DepartmentID = (int)emp.FK_DepartmentId;
List <SelectListItem> lstDept = (new ServiceMASTERS()).GetAllDepartments();
if (lstDept != null)
{
Program.CURR_USER.DepartmentName = lstDept.Where(x => x.ID == (int)Program.CURR_USER.DepartmentID).FirstOrDefault().Description;
}
}
TBL_User_Master dbUser = (new ServiceUsers()).GetUserDBModelByUserName(txtUserName.Text);
if (dbUser != null)
{
Program.CURR_USER.UserID = dbUser.PK_UserID;
if (dbUser.FK_RoleId != null)
{
Program.CURR_USER.RoleID = (int)dbUser.FK_RoleId;
ServiceRoles roleService = new ServiceRoles();
TBL_MP_Master_Role dbRole = roleService.GetRoleDBRecordByID(Program.CURR_USER.RoleID);
if (dbRole != null)
{
Program.CURR_USER.RoleName = dbRole.RoleName.ToUpper();
}
Program.CONTROL_ACCESS.UpdateControlAccessListForRole(Program.CURR_USER.RoleID, Program.CURR_USER.EmployeeID);
}
if (dbUser.Theme != null)
{
Program.CURRENT_THEME = MANAGER.GlobalPaletteMode = (PaletteModeManager)dbUser.Theme;
Program.ColorSelected = MANAGER.GlobalPalette.ColorTable.ButtonSelectedHighlight;
}
}
#endregion
this.Cursor = Cursors.Default;
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
else
{
MessageBox.Show("Invalid User Name or Password!!");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "frmLogin::btnLogin_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.Cursor = Cursors.Default;
}
private void btnSave_Click(object sender, EventArgs e)
{
TBL_MP_Master_Employee model = null;
ServiceEmployee serviceEmployee = new ServiceEmployee();
try
{
if (!this.ValidateChildren())
{
return;
}
if (this.EmployeeID == 0)
{
model = new TBL_MP_Master_Employee();
}
else
{
model = serviceEmployee.GetEmployeeDbRecordByID(this.EmployeeID);
}
#region GATHER DATA INTO MODEL FROM VIEW
model.EmployeeCode = txtEmployeeCode.Text;
model.EmployeeName = txtEmployeeName.Text;
model.EmailAddress = txtEmail.Text;
model.PhoneNo1 = txtMobileNo.Text;
model.FK_DepartmentId = ((SelectListItem)cboDepartment.SelectedItem).ID;
model.FK_DesignationId = ((SelectListItem)cboDesignation.SelectedItem).ID;
model.FK_EmploymentTypeID = ((SelectListItem)cboEmploymentType.SelectedItem).ID;
model.isActive = chkIsActive.Checked;
model.IsResigned = chkHasResigned.Checked;
model.FK_BossID = ((SelectListItem)cboEmployeeBoss.SelectedItem).ID;
#endregion
if (this.EmployeeID == 0)
{
//CREATE EMPLOYEE
model.FK_CompanyID = Program.CURR_USER.CompanyID;
model.FK_YearID = Program.CURR_USER.FinYearID;
model.FK_BranchID = Program.CURR_USER.BranchID;
model.CreatedBy = Program.CURR_USER.EmployeeID;
model.CreatedDateTime = AppCommon.GetServerDateTime();
this.EmployeeID = serviceEmployee.AddNewEmployee(model);
}
else
{
model.ModifiedBy = Program.CURR_USER.EmployeeID;
model.ModifiedDateTime = AppCommon.GetServerDateTime();
serviceEmployee.UpdateEmployee(model);
}
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "frmAddEditEmployee::btnSave_Click", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ReceipentSelectionLink_Clicked(object sender, EventArgs e)
{
try
{
SELECTED_ENTITY = (APP_ENTITIES)((KryptonLinkLabel)sender).Tag;
frmGridMultiSelect frm = new frmGridMultiSelect(SELECTED_ENTITY, SOURCE_ENTITY, SOURCE_ENTITY_ID);
if (frm.ShowDialog() == DialogResult.OK)
{
BindingList <MultiSelectListItem> selectedIDs = frm.SelectedItems;
if (selectedIDs != null)
{
string strAddresses = string.Empty;
if (txtMailTo.Text.Trim() != string.Empty)
{
if (!txtMailTo.Text.Trim().EndsWith(";"))
{
txtMailTo.Text += ";";
}
}
switch (SELECTED_ENTITY)
{
case APP_ENTITIES.EMPLOYEES:
foreach (MultiSelectListItem item in selectedIDs)
{
TBL_MP_Master_Employee emp = _UNIT.AppDBContext.TBL_MP_Master_Employee.Where(x => x.PK_EmployeeId == item.ID).FirstOrDefault();
if (emp != null)
{
if (emp.EmailAddress.Trim() != string.Empty)
{
if (!txtMailTo.Text.Contains(emp.EmailAddress))
{
txtMailTo.Text += emp.EmailAddress + ";";
}
}
}
}
break;
case APP_ENTITIES.CONTACTS:
foreach (MultiSelectListItem item in selectedIDs)
{
Tbl_MP_Master_PartyContact_Detail contact = _UNIT.AppDBContext.Tbl_MP_Master_PartyContact_Detail.Where(x => x.PK_PartyContactDetails == item.ID).FirstOrDefault();
if (contact != null)
{
if (contact.EmailID.Trim() != string.Empty)
{
if (!txtMailTo.Text.Contains(contact.EmailID))
{
txtMailTo.Text += contact.EmailID + ";";
}
}
}
}
break;
case APP_ENTITIES.PARTIES:
foreach (MultiSelectListItem item in selectedIDs)
{
Tbl_MP_Master_Party party = _UNIT.AppDBContext.Tbl_MP_Master_Party.Where(x => x.PK_PartyId == item.ID).FirstOrDefault();
if (party != null)
{
if (party.EmailID.Trim() != string.Empty)
{
if (!txtMailTo.Text.Contains(party.EmailID))
{
txtMailTo.Text += party.EmailID + ";";
}
}
}
}
break;
case APP_ENTITIES.ASSOCIATES_AND_CONTACTS:
foreach (MultiSelectListItem item in selectedIDs)
{
switch (item.EntityType)
{
case APP_ENTITIES.EMPLOYEES:
TBL_MP_Master_Employee emp = _UNIT.AppDBContext.TBL_MP_Master_Employee.Where(x => x.PK_EmployeeId == item.ID).FirstOrDefault();
if (emp != null)
{
if (emp.EmailAddress.Trim() != string.Empty)
{
if (!txtMailTo.Text.Contains(emp.EmailAddress))
{
txtMailTo.Text += emp.EmailAddress + ";";
}
}
}
break;
case APP_ENTITIES.PARTIES:
Tbl_MP_Master_Party party = _UNIT.AppDBContext.Tbl_MP_Master_Party.Where(x => x.PK_PartyId == item.ID).FirstOrDefault();
if (party != null)
{
if (party.EmailID.Trim() != string.Empty)
{
if (!txtMailTo.Text.Contains(party.EmailID))
{
txtMailTo.Text += party.EmailID + ";";
}
}
}
break;
case APP_ENTITIES.CONTACTS:
Tbl_MP_Master_PartyContact_Detail contact = _UNIT.AppDBContext.Tbl_MP_Master_PartyContact_Detail.Where(x => x.PK_PartyContactDetails == item.ID).FirstOrDefault();
if (contact != null)
{
if (contact.EmailID.Trim() != string.Empty)
{
if (!txtMailTo.Text.Contains(contact.EmailID))
{
txtMailTo.Text += contact.EmailID + ";";
}
}
}
break;
}
}
break;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "frmSendMail::ReceipentSelectionLink_Clicked");
}
}
public void PoulateSalesQuotationMasterInfo()
{
try
{
TBL_MP_CRM_SalesQuotation dbModel = (new ServiceSalesQuotation()).GetSalesQuotationMasterDBInfo(this.SelectedQuotationID);
if (dbModel != null)
{
txtSalesQuotationNo.Text = dbModel.Quotation_No;
txtSalesQuotationDate.Text = dbModel.Quotation_Date.ToString("dd MMM yyyy");
txtSalesEnquiryNo.Text = dbModel.TBL_MP_CRM_SalesEnquiry.SalesEnquiry_No;
txtSalesEnquiryDate.Text = dbModel.TBL_MP_CRM_SalesEnquiry.SalesEnquiry_Date.ToString("dd MMM yyyy");
txtClientName.Text = dbModel.Tbl_MP_Master_Party.PartyName;
txtRemarks.Text = dbModel.Remarks;
// GETTING SALES QUOTATION STATUS
SelectListItem selStatus = (new ServiceSalesQuotation()).GetAllActiveQuotationStatusesList().Where(x => x.ID == dbModel.FK_Userlist_Quotation_Status_ID).FirstOrDefault();
if (selStatus != null)
{
lblQuotationStatus.Text = String.Format("STATUS : {0}", selStatus.Description);
}
ServiceEmployee _empService = new ServiceEmployee();
TBL_MP_Master_Employee obj = _empService.GetEmployeeDbRecordByID(dbModel.FK_RepresentativeID);
if (obj != null)
{
txtSalesRepresentativeName.Text = obj.EmployeeName;
lblSalesRepresentativeCode.Text = string.Format("Code: {0}", obj.EmployeeCode);
}
obj = _empService.GetEmployeeDbRecordByID(dbModel.FK_BOQRepresentativeID);
if (obj != null)
{
txtBOQRepresentativeName.Text = obj.EmployeeName;
lblBoqRepresentativeCode.Text = string.Format("Code: {0}", obj.EmployeeCode);
}
headerBottom.Values.Heading = string.Format("Created: {0} dt. {1}", ServiceEmployee.GetEmployeeNameByID(dbModel.FK_PreparedBy), dbModel.CreatedDatetime);
if (dbModel.LastModifiedBy != null)
{
headerBottom.Values.Description = string.Format("Modified: {0} dt. {1}", ServiceEmployee.GetEmployeeNameByID((int)dbModel.LastModifiedBy), dbModel.LastModifiedDate);
}
else
{
headerBottom.Values.Description = string.Empty;
}
lblQuotationApprovalInfo.Text = "Unapproved Quotation";
lblQuotationApprovalInfo.StateCommon.Back.Color1 = (dbModel.FK_ApprovedBy == null) ? Color.Red : Color.Green;
WhosWhoModel premission = Program.CONTROL_ACCESS.ListControlAccess.Where(x => x.FormID == DB_FORM_IDs.SALES_QUOTATION).FirstOrDefault();
if (premission != null)
{
if (premission.CanApprove)
{
if (dbModel.FK_ApprovedBy == null)
{
btnApprove.Visible = true;
}
else
{
lblQuotationApprovalInfo.Text = string.Format("Approved: {0}", ServiceEmployee.GetEmployeeNameByID((int)dbModel.FK_ApprovedBy));
btnApprove.Visible = false;
}
}
else
{
btnApprove.Visible = false;
}
}
}
ServiceSalesQuotationBOQ _service = new ServiceSalesQuotationBOQ();
SalesQuotationBOQSummary model = _service.GetQuotationBOQSummaryForQuotationID(this.SelectedQuotationID);
if (model != null)
{
PopulateBOQSummary(model);
}
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
MessageBox.Show(errMessage, "ControlSalesQuotaionGeneralDetails::PoulateSalesQuotationMasterInfo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
