public vmNotificationMail GetNotificationMailObject(NotificationEntity model, string message) { vmNotificationMail obj = new vmNotificationMail(); try { using (var db = new ABS.Models.ERP_Entities()) { // if (model.NextWFUserID==null) obj.nextUser = db.CmnUsers.Where(x => x.UserID == model.NextWFUserID).FirstOrDefault().UserFullName; obj.companyName = db.CmnCompanies.Where(x => x.CompanyID == model.LoggedCompanyID).FirstOrDefault().CompanyName; obj.menuName = db.CmnMenus.Where(x => x.MenuID == model.MenuID).FirstOrDefault().MenuName; obj.customCode = model.TransactionID.ToString(); obj.customCode = db.CmnWorkFlowTransactions.Where(x => x.UserID == model.NextWFUserID && x.IsDeleted == false && x.StatusID == 1).FirstOrDefault().CustomCode; obj.message = message; obj.currentUser = db.CmnUsers.Where(x => x.UserID == model.CreatorID).FirstOrDefault().UserFullName; obj.comments = model.Comments; obj.nextUserEmailAddress = db.CmnUserAuthentications.Where(x => x.UserID == model.NextWFUserID).FirstOrDefault().LoginEmail; } } catch (Exception ex) { throw; } return(obj); }
public List <vmNotificationMail> GetNotificationMailObjectListDeclined(NotificationEntity model, string message) { List <vmNotificationMail> objList = new List <vmNotificationMail>(); try { using (var db = new ABS.Models.ERP_Entities()) { List <CmnWorkFlowTransactionTran> list = new List <CmnWorkFlowTransactionTran>(); list = db.CmnWorkFlowTransactionTrans.Where(x => x.TransactionID == model.TransactionID && x.IsActve == true && x.WFMID == model.WorkFlowID && x.IsDeleted == false).ToList(); foreach (CmnWorkFlowTransactionTran item in list) { vmNotificationMail obj = new vmNotificationMail(); obj.nextUser = db.CmnUsers.Where(x => x.UserID == item.TUserID).FirstOrDefault().UserFullName; obj.companyName = db.CmnCompanies.Where(x => x.CompanyID == item.CompanyID).FirstOrDefault().CompanyName; obj.menuName = db.CmnMenus.Where(x => x.MenuID == item.MenuID).FirstOrDefault().MenuName; obj.customCode = item.CustomCode.ToString(); obj.message = db.CmnWorkFlowTransactionTrans.Where(x => x.TransactionID == item.TransactionID && x.WFMID == item.WFMID && x.IsDeleted == false && x.Ccomment == "1").FirstOrDefault().Notification; obj.currentUser = db.CmnUsers.Where(x => x.UserID == item.UserID).FirstOrDefault().UserFullName; obj.comments = item.Notification; obj.nextUserEmailAddress = db.CmnUserAuthentications.Where(x => x.UserID == item.TUserID).FirstOrDefault().LoginEmail; obj.isApproved = false; objList.Add(obj); } } } catch (Exception ex) { } return(objList); }