public List <FollowupModel> GetAllFollowups(APP_ENTITIES entity, int refID) { List <FollowupModel> lst = new List <FollowupModel>(); try { string strRefType = string.Empty; switch (entity) { case APP_ENTITIES.SALES_QUOTATION: strRefType = "Sales Quotation"; break; } string strSQL = string.Format("EXEC MXD_FOLLOWUPS '{0}',{1}", strRefType, refID); lst = _dbContext.Database.SqlQuery <FollowupModel>(strSQL).ToList(); } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceFollowUps::GetAllFollowups", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(lst); }
public ctrlAttachments(APP_ENTITIES _entitry) { _UNIT = new ServiceUOW(); InitializeComponent(); this.ENTITY = _entitry; Gnostice.Documents.Framework.ActivateLicense("1DD5-DBE6-E25F-15E6-7BFC-5062-64E8-58CE-71B6-CBA3-9ADF-F55A"); }
public frmGridMultiSelect(APP_ENTITIES entity, int sourceEntityID) { _UOM = new ServiceUOW(); InitializeComponent(); _ENTITY = entity; SOURCE_ENTITY_ID = sourceEntityID; }
public List <SelectListItem> GetPastScheduleCallsFor(APP_ENTITIES entity, int entityID) { List <SelectListItem> lstCalls = new List <SelectListItem>(); try { int STATUS = CALL_STATUS_CLOSE_ID; List <TBL_MP_CRM_ScheduleCallLog> callLogs = ( from xx in _dbContext.TBL_MP_CRM_ScheduleCallLog where xx.EntityType == (int)entity && xx.EntityID == entityID && xx.ScheduleStatus == STATUS orderby xx.CreatedDatetime descending select xx ).ToList(); List <SelectListItem> actions = (new ServiceMASTERS(_dbContext)).GetAllScheduleCallActions(); foreach (TBL_MP_CRM_ScheduleCallLog log in callLogs) { SelectListItem item = new SelectListItem() { ID = log.ScheduleID }; item.Description = string.Format("{0} - {1}\n{2}\nInbetween {3} - {4}", actions.Where(x => x.ID == log.ActionID).FirstOrDefault().Description, log.Subject, log.CustomerName, log.StartAt.Value.ToString("ddMMMyy hh:mmtt"), log.EndsAt.Value.ToString("ddMMMyy hh:mmtt")); lstCalls.Add(item); } } catch (Exception ex) { MessageBox.Show(ex.Message, "GetActiveScheduleCallsFor", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(lstCalls); }
public ctrlDocumentViewer(APP_ENTITIES entity, int entityID) { _UOM = new ServiceUOW(); InitializeComponent(); this.EntityType = entity; this.EntityID = entityID; btnDownload.Enabled = btnEmail.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.False; }
public ctrlDocumentViewer(string fileName, APP_ENTITIES entity, int entityID, int attachmentID) { _UOM = new ServiceUOW(); InitializeComponent(); this.FileName = fileName; this.AttachmentID = attachmentID; this.EntityType = entity; this.EntityID = entityID; btnDownload.Enabled = btnEmail.Enabled = ComponentFactory.Krypton.Toolkit.ButtonEnabled.False; }
public List <SelectListItem> GetActiveScheduleCallsFor(APP_ENTITIES entity, int entityID) { List <SelectListItem> lstCalls = new List <SelectListItem>(); try { int Status = _dbContext.APP_DEFAULTS.Where(x => x.ID == (int)APP_DEFAULT_VALUES.ScheduleCallStatusInProgress).FirstOrDefault().DEFAULT_VALUE; List <TBL_MP_CRM_ScheduleCallLog> callLogs = ( from xx in _dbContext.TBL_MP_CRM_ScheduleCallLog where xx.EntityType == (int)entity && xx.EntityID == entityID && xx.ScheduleStatus == Status && xx.IsDeleted == false orderby xx.CreatedDatetime descending select xx ).ToList(); callLogs = callLogs.OrderByDescending(x => x.Priority).ToList(); List <SelectListItem> actions = (new ServiceMASTERS(_dbContext)).GetAllScheduleCallActions(); List <SelectListItem> priorities = (new ServiceMASTERS(_dbContext)).GetAllScheduleCallPriorities(); foreach (TBL_MP_CRM_ScheduleCallLog log in callLogs) { SelectListItem item = new SelectListItem() { ID = log.ScheduleID }; string strDescription = string.Empty; if (log.ActionID != null) { strDescription = string.Format("{0}", actions.Where(x => x.ID == log.ActionID).FirstOrDefault().Description); } if (log.Priority != null) { strDescription = string.Format(" ({0})", priorities.Where(x => x.ID == log.Priority).FirstOrDefault().Description); } strDescription += string.Format("\n{0}\n{1}", log.Subject.ToUpper(), log.CustomerName); strDescription += string.Format("\nInbetween {0} - {1}", log.StartAt.Value.ToString("ddMMMyy hh:mmtt"), log.EndsAt.Value.ToString("ddMMMyy hh:mmtt")); strDescription += string.Format("\n\nCreated: {0}", log.CreatedDatetime.Value.ToString("ddMMMyy hh:mmtt")); if (log.ModifiedDatetime != null) { strDescription += string.Format("\nModified: {0}", log.ModifiedDatetime.Value.ToString("ddMMMyy hh:mmtt")); } item.Description = strDescription; lstCalls.Add(item); } } catch (Exception ex) { MessageBox.Show(ex.InnerException.Message, "ServiceScheduleCallLog::GetActiveScheduleCallsFor", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(lstCalls); }
public frmEntityInfo(APP_ENTITIES enumEntity, int entityID) { ENTITY = enumEntity; this.ENTITY_ID = entityID; InitializeComponent(); this.Cursor = Cursors.WaitCursor; switch (ENTITY) { case APP_ENTITIES.INVENTORY_ITEM: PopulateInventoryItemInfo(); break; } this.Cursor = Cursors.Default; }
public frmDelete(APP_ENTITIES entity, int ID) { InitializeComponent(); this.ENTITY = entity; this.ENTITY_ID = ID; }
public ctrlSuspectInfo(APP_ENTITIES currEntity) { InitializeComponent(); this.ENTITY = currEntity; }
public List <TBL_MP_CRM_SM_DocumentHistory> GetDocumentHistory(int attachmentID, APP_ENTITIES entity) { return(_dbContext.TBL_MP_CRM_SM_DocumentHistory .Where(x => x.AttachmentID == attachmentID) .Where(x => x.EntityType == (int)entity) .OrderByDescending(x => x.CreateDatetime) .ToList()); }
public ctrlAssociates(APP_ENTITIES EntityToAssociate) { _UOM = new ServiceUOW(); InitializeComponent(); this.ENTITY = EntityToAssociate; }
public ctrlScheduleCallLog(APP_ENTITIES entity) { InitializeComponent(); this.SOURCE_ENTITY = entity; }
public int GenerateNotificationFor(APP_ENTITIES entity, int selectedID, int empID, string titleText, string bodyText) { int newNotificationID = 0; try { string notificationURL = string.Empty; string notificationTitle = string.Empty; string notificatrionBody = string.Empty; int notificationType = 0; switch (entity) { case APP_ENTITIES.SALES_LEAD: TBL_MP_CRM_SM_SalesLead lead = _dbContext.TBL_MP_CRM_SM_SalesLead.Where(x => x.PK_SalesLeadID == selectedID).FirstOrDefault(); if (lead != null) { notificationTitle = titleText; notificatrionBody = bodyText; notificationURL = string.Format("../CRM/FrmMP_CRM_SM_SalesLead_AddEdit.aspx?LID={0}", selectedID); notificationType = (int)NOTIFICATION_CATEGORIES.NOTIFICATION_CRM; } break; case APP_ENTITIES.SALES_ENQUIRY: TBL_MP_CRM_SM_SalesLead enquiry = _dbContext.TBL_MP_CRM_SM_SalesLead.Where(x => x.PK_SalesLeadID == selectedID).FirstOrDefault(); if (enquiry != null) { notificationTitle = titleText; notificatrionBody = bodyText; notificationURL = string.Format("../CRM/FrmMP_CRM_SM_SalesLead_AddEdit.aspx?LID={0}", selectedID); notificationType = (int)NOTIFICATION_CATEGORIES.NOTIFICATION_CRM; } break; case APP_ENTITIES.SALES_QUOTATION: TBL_MP_CRM_SM_SalesLead quotation = _dbContext.TBL_MP_CRM_SM_SalesLead.Where(x => x.PK_SalesLeadID == selectedID).FirstOrDefault(); if (quotation != null) { notificationTitle = titleText; notificatrionBody = bodyText; notificationType = (int)NOTIFICATION_CATEGORIES.NOTIFICATION_CRM; } break; case APP_ENTITIES.SALES_ORDER: TBL_MP_CRM_SM_SalesLead order = _dbContext.TBL_MP_CRM_SM_SalesLead.Where(x => x.PK_SalesLeadID == selectedID).FirstOrDefault(); if (order != null) { notificationTitle = titleText; notificatrionBody = bodyText; notificationType = (int)NOTIFICATION_CATEGORIES.NOTIFICATION_CRM; } break; } //insert this notification in notification table TBL_MP_COMMON_Notification model = new TBL_MP_COMMON_Notification(); model.NotificationTitle = notificationTitle; model.NotificationBody = notificatrionBody; model.FK_EMPLOYEEID = empID; model.URL = notificationURL; model.FK_NotificationType = notificationType; _dbContext.TBL_MP_COMMON_Notification.Add(model); _dbContext.SaveChanges(); newNotificationID = model.PK_NotificationID; } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(newNotificationID); }
public frmGridMultiSelect(APP_ENTITIES entity) { _UOM = new ServiceUOW(); InitializeComponent(); _ENTITY = entity; }
public ctrlTermsAndCondition(APP_ENTITIES currEntity) { InitializeComponent(); this.ENTITY = currEntity; }
public ctrlScheduler(APP_ENTITIES currentEntity) { InitializeComponent(); this.ENTITY = currentEntity; }