public void GatherData() { model = new Tbl_MP_Master_PartyContact_Detail(); if (this.ContactID > 0) { model = _contactService.GetContactByContactID(this.ContactID); } model.ContactPersoneName = txtContactName.Text.Trim(); model.Address = txtAddress.Text; model.TelephoneNo = txtPhoneNo.Text; model.AltTelephoneNo = txtPhoneNoAlternate.Text; model.MobileNo = txtMobileNo.Text; model.AltMobileNo = txtMobileNoAlternate.Text; model.FaxNo = txtFAXNo.Text; model.EmailID = txtEmail.Text; if (cboDepartments.SelectedItem != null) { model.FK_Department = ((SelectListItem)cboDepartments.SelectedItem).ID; model.FK_Department_Text = ((SelectListItem)cboDepartments.SelectedItem).Description; } if (cboDesignations.SelectedItem != null) { model.FK_Designation = ((SelectListItem)cboDesignations.SelectedItem).ID; model.FK_Designation_Text = ((SelectListItem)cboDesignations.SelectedItem).Description; } }
public void ScatterData() { model = _contactService.GetContactByContactID(this.ContactID); if (model != null) { txtContactName.Text = model.ContactPersoneName; txtAddress.Text = model.Address; txtPhoneNo.Text = model.TelephoneNo; txtPhoneNoAlternate.Text = model.AltTelephoneNo; txtMobileNo.Text = model.MobileNo; txtMobileNoAlternate.Text = model.AltMobileNo; txtFAXNo.Text = model.FaxNo; txtEmail.Text = model.EmailID; if (model.FK_Department != null) { SelectListItem item = ((List <SelectListItem>)cboDepartments.DataSource).Where(x => x.ID == model.FK_Department).FirstOrDefault(); if (item != null) { cboDepartments.SelectedItem = item; } } if (model.FK_Designation != null) { SelectListItem item = ((List <SelectListItem>)cboDesignations.DataSource).Where(x => x.ID == model.FK_Designation).FirstOrDefault(); if (item != null) { cboDesignations.SelectedItem = item; } } } }
public int UpdateContact(Tbl_MP_Master_PartyContact_Detail model) { try { _dbContext.SaveChanges(); } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceContacts::UpdateContact", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(model.PK_PartyContactDetails); }
public bool UndeleteContact(int ContID, string reason) { bool result = false; try { Tbl_MP_Master_PartyContact_Detail editCont = _dbContext.Tbl_MP_Master_PartyContact_Detail.Where(x => x.PK_PartyContactDetails == ContID).FirstOrDefault(); editCont.DeleteDateTime = null; editCont.DeletedBy = null; editCont.IsActive = true; editCont.DeleteRemarks = reason; _dbContext.SaveChanges(); result = true; } catch (Exception ex) { MessageBox.Show(String.Format("{0}\n{1}", ex.Message, ex.InnerException.Message), "ServiceContacts::UndeleteContact", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(result); }
public bool DeletePartyContact(int partyConID, int deletedBy) { bool result = false; try { Tbl_MP_Master_PartyContact_Detail dbPartyCon = _dbContext.Tbl_MP_Master_PartyContact_Detail.Where(x => x.PK_PartyContactDetails == partyConID).FirstOrDefault(); dbPartyCon.DeleteDateTime = AppCommon.GetServerDateTime(); dbPartyCon.DeletedBy = deletedBy; dbPartyCon.IsActive = false; //dbPartyCon.DeleteRemarks = reason; _dbContext.SaveChanges(); result = true; } catch (Exception ex) { MessageBox.Show(String.Format("{0}\n{1}", ex.Message, ex.InnerException.Message), "ServiceContacts::DeletePartyContact", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(result); }
private void PopulateDescription() { try { switch (this.ENTITY) { case APP_ENTITIES.INVENTORY_ITEM: TBL_MP_Master_Item dbItem = (new ServiceInventoryItems()).GetItemDBRecord(this.ENTITY_ID); if (dbItem != null) { txtDescription.Text = string.Format("{0}\n{1}\nCODE: {2}", dbItem.Item_Name, dbItem.Long_Description, dbItem.ItemCode); } break; case APP_ENTITIES.PARTIES: Tbl_MP_Master_Party dbParty = (new ServiceParties()).GetPartyByPartyID(this.ENTITY_ID); if (dbParty != null) { txtDescription.Text = string.Format("{0} ({1})\n{2}", dbParty.PartyName, dbParty.PartyType, dbParty.PartyCode); } break; case APP_ENTITIES.INVENTORY_ITEM_ATTACHMENT: TBL_MP_Master_Item_Attachments dbItemAttachment = (new ServiceInventoryItems()).GetInventoryItemAttachmentDBRecord(this.ENTITY_ID); if (dbItemAttachment != null) { txtDescription.Text = string.Format("ATTACHMENT: {0}\nITEM:{1}\n{2}", dbItemAttachment.Title.ToUpper(), dbItemAttachment.TBL_MP_Master_Item.Item_Name, dbItemAttachment.TBL_MP_Master_Item.Long_Description); } break; case APP_ENTITIES.APPLICATION_MODULES: Tbl_MP_Master_Module dbModule = (new ServiceModules()).GetModuleDBRecordByID(this.ENTITY_ID); if (dbModule != null) { txtDescription.Text = string.Format("NAME: {0}\nDISPLAY: {1}", dbModule.ModuleName, dbModule.DisplayName); } break; case APP_ENTITIES.MODULES_FORMS: Tbl_MP_Master_Module_Forms dbForm = (new ServiceModules()).GetModuleFormDBRecordByID(this.ENTITY_ID); if (dbForm != null) { txtDescription.Text = string.Format("NAME: {0}\nDISPLAY: {1}", dbForm.FormName, dbForm.DisplayName); } break; case APP_ENTITIES.ROLES: TBL_MP_Master_Role dbRole = (new ServiceRoles()).GetRoleDBRecordByID(this.ENTITY_ID); if (dbRole != null) { txtDescription.Text = string.Format("ROLE NAME: {0}\nROLE NO.: {1}", dbRole.RoleName, dbRole.RoleNo); } break; case APP_ENTITIES.SALES_LEAD_ATTACHMENT: TBL_MP_CRM_SM_SalesLead_Attachment dbLeadAttachment = (new ServiceSalesLead()).GetSalesLeadAttachmentDBRecord(this.ENTITY_ID); if (dbLeadAttachment != null) { txtDescription.Text = string.Format("ATTACHMENT: {0}\nITEM:{1}\n{2}", dbLeadAttachment.Title.ToUpper(), dbLeadAttachment.TBL_MP_CRM_SM_SalesLead.LeadNo, dbLeadAttachment.TBL_MP_Master_UserList.Description1); } break; case APP_ENTITIES.SALES_ENQUIRY_ATTACHMENT: TBL_MP_CRM_SalesEnquiry_Attachments dbEnquiryAttachment = (new ServiceSalesEnquiry()).GetSalesEnquiryAttachmentDBRecord(this.ENTITY_ID); if (dbEnquiryAttachment != null) { txtDescription.Text = string.Format("ATTACHMENT: {0}\nITEM:{1}\n{2}", dbEnquiryAttachment.Title.ToUpper(), dbEnquiryAttachment.TBL_MP_CRM_SalesEnquiry.SalesEnquiry_No, dbEnquiryAttachment.TBL_MP_Master_UserList.Description1); } break; case APP_ENTITIES.SALES_QUOTATION_ATTACHMENT: TBL_MP_CRM_SalesQuotation_Attachments dbQuoteAttachment = (new ServiceSalesQuotation()).GetSalesQuotationAttachmentDBRecord(this.ENTITY_ID); if (dbQuoteAttachment != null) { txtDescription.Text = string.Format("ATTACHMENT: {0}\nITEM:{1}\n{2}", dbQuoteAttachment.Title.ToUpper(), dbQuoteAttachment.TBL_MP_CRM_SalesQuotation.Quotation_No, dbQuoteAttachment.TBL_MP_Master_UserList.Description1); } break; case APP_ENTITIES.SALES_ORDER_ATTACHMENT: TBL_MP_CRM_SalesOrder_Attachment dbOrderAttachment = (new ServiceSalesOrder()).GetSalesOrderAttachmentDBRecord(this.ENTITY_ID); if (dbOrderAttachment != null) { txtDescription.Text = string.Format("ATTACHMENT: {0}\nITEM:{1}\n{2}", dbOrderAttachment.Title.ToUpper(), dbOrderAttachment.TBL_MP_CRM_SalesOrder.SalesOrderNo, dbOrderAttachment.TBL_MP_Master_UserList.Description1); } break; case APP_ENTITIES.EMPLOYEES_ATTACHMENT: TBL_MP_Master_Employee_Attachment dbEmpAttachment = (new ServiceEmployee()).GetEmployeeAttachmentDBRecord(this.ENTITY_ID); if (dbEmpAttachment != null) { txtDescription.Text = string.Format("ATTACHMENT: {0}\nITEM:{1}\n{2}", dbEmpAttachment.Title.ToUpper(), dbEmpAttachment.TBL_MP_Master_Employee.EmployeeCode, dbEmpAttachment.TBL_MP_Master_UserList.Description1); } break; case APP_ENTITIES.CONTACTS: Tbl_MP_Master_PartyContact_Detail dbContact = (new ServiceContacts()).GetContactID(this.ENTITY_ID); if (dbContact != null) { txtDescription.Text = string.Format("Contact Person Name : {0}\nAddress:{1}\nMobile No:{2}\nAt.Telephone No:{3}\nEmail ID:{4}\n FAX NO:{5}", dbContact.ContactPersoneName, dbContact.Address, dbContact.MobileNo, dbContact.TelephoneNo, dbContact.EmailID, dbContact.FaxNo); } break; } } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "frmDelete::PopulateDescription", 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"); } }
private void GeneratePartiesForSalesLead() { ServiceSalesLead _leadService = new ServiceSalesLead(); ServiceParties _partyService = new ServiceParties(); ServiceContacts _contactService = new ServiceContacts(); List <TBL_MP_CRM_SM_SalesLead> dbLeads = _leadService.GetAllSalesLeadDBItems(); if (dbLeads == null) { return; } progressBar1.Value = 0; progressBar1.Minimum = 0; progressBar1.Maximum = dbLeads.Count; int progressVAl = 0; foreach (TBL_MP_CRM_SM_SalesLead lead in dbLeads) { lblTitle.Text = string.Format("{0} of {1}\n\n{2} {3}\n{4}", progressVAl + 1, progressBar1.Maximum, lead.LeadNo, lead.LeadDate.ToString("dd MMM yyyy"), lead.LeadName); Tbl_MP_Master_Party party = _partyService.GetPartyByPartyName(lead.LeadName); if (party != null) { lead.FK_PartyID = party.PK_PartyId; _leadService.UpdateSalesLeadMasterInfo(lead); lblTitle.Text += string.Format("\nExisting Party found. Customer update in SalesLead PartyID:{0}", lead.FK_PartyID); } else { party = new Tbl_MP_Master_Party() { PartyType = "C", FK_PartyType = 2, PartyName = lead.LeadName, FK_IndustryType = 8003, EmailID = lead.LeadEmailID, Website = lead.LeadWebsite, IsActive = true }; int partyID = _partyService.AddNewParty(party); Tbl_MP_Master_PartyContact_Detail contact = new Tbl_MP_Master_PartyContact_Detail() { FK_PartyID = partyID, ContactPersoneName = lead.ContactPersone, Address = lead.LeadAddress, EmailID = lead.LeadEmailID, TelephoneNo = lead.LeadPhoneNo, MobileNo = lead.LeadMobileNo, FaxNo = lead.LeadFAXNo, IsActive = true, }; _contactService.AddNewContact(contact); lblTitle.Text += "\n\nNew Party & Contact created."; } progressVAl++; progressBar1.Value = progressVAl; Application.DoEvents(); } }