public static List <PendingRequestModel> getPendingRequest(string EmployeeCode) { using (var context = new SalesReturndbEntities()) { List <PendingRequestModel> dataList = null; var PendingRequestList = context.SP_GetPendingRequest(EmployeeCode).ToList(); if (PendingRequestList != null) { dataList = PendingRequestList.Select(x => new PendingRequestModel() { BatchNo = x.BatchNo, DealerAddress = x.DealerAddress, DealerCode = x.DealerCode, DealerName = x.DealerName, DepotName = x.DepotName, DepotAddress = x.DepotAddress, DepotCode = x.DepotCode, FutureStatus = x.FutureStatus, RequestHeaderId = x.RequestHeaderId, FutureStatus_Id = x.FutureStatus_Id, CurrentStatus_Id = x.CurrentStatus_Id, SKUCode = x.SKUCode, SKUName = x.SKUName, CreatedBy_EMP_CODE = x.CreatedBy, CreatedBy = context.SP_LFGDetails(x.CreatedBy).FirstOrDefault().Emp_First_name, CreatedDate = x.CreatedDate, TotalSRV = context.tblRequestDtls.Where(o => o.RequestHeaderId == x.RequestHeaderId && o.IsActive == true).Sum(p => p.SRVValue).Value, RequestTypeOption = x.SKUCode,// for access data behalf on skucode }).ToList(); return(dataList); } return(dataList); } }
public static string ApproveRequest(RecommendRequestObj data) { try { using (var context = new SalesReturndbEntities()) { string RequestType = "approve"; var RequestDetail = context.tblRequestDtls.Where(x => x.RequestHeaderId == data.Request_Id && x.IsActive == true).ToList(); var approvalHeader = context.TblApproverHeaders.Where(x => x.Request_Id == data.Request_Id && x.IsActive == true).FirstOrDefault(); var ReqHdr = context.TblRequestHeaders.Where(x => x.RequestHeaderId == data.Request_Id && x.IsActive == true).FirstOrDefault(); RequestDetailObj_Render data1 = CommonDAL.GetRequestDetails(data.Request_Id, data.CurrentStatus_Id, data.FutureStatus_Id); var UserDetail = context.SP_LFGDetails(approvalHeader.CreatedBy).FirstOrDefault(); var DepotDTl = context.sp_GetDealerDtlBy_DealerRepositoryId(ReqHdr.DealerId).FirstOrDefault(); string assignTo = string.Empty; var DepotPersonDtl = context.TblEmployeeMasters.Where(x => x.DepotName == DepotDTl.Depot).FirstOrDefault(); if (data.FutureStatus_Id == 10019) { assignTo = DepotPersonDtl.Depotcode; } ApproverDAL.UpdateRequestStatus(false, Convert.ToInt32(data.Request_Id), data.EmployeeCode, assignTo, data.Active_Role, data.Requested_Role, data.CurrentStatus_Id, data.FutureStatus_Id, data.Remarks); SendMail(approvalHeader, data, RequestType, assignTo); return("Success : " + ReqHdr.RequestTypeOption + "-" + data.Request_Id + " Requested has been approved successfully."); } } catch (Exception ex) { throw ex; } }
public static List <ApprovalMatrixModal> getApprovalMatrixData() { using (var context = new SalesReturndbEntities()) { List <ApprovalMatrixModal> objList = null; var dataList = context.TblApprovalMatrices.Where(x => x.IsActive == true).ToList(); if (dataList != null) { objList = dataList.Select(x => new ApprovalMatrixModal() { Country = x.Country, BUType = x.BUType, Division = x.Division, RequestType = x.RequestType, SRV_Value = x.SRV_Value, InvoiceAge = x.InvoiceAge, ComplaintHandler = x.ComplaintHandler, ComplaintManager = x.ComplaintManager, LogisticsManager = x.LogisticsManager, LogisticsHead = x.LogisticsHead, SegmentHeadHRV = x.SegmentHeadHRV, SegmentInvoiceAge = x.SegmentInvoiceAge, Matrix_Id = x.Matrix_Id, VPName = x.VP, President = x.President, }).ToList(); return(objList); } return(objList); } }
public static List <SP_GetBatchNo_Result> GetBatchNO(string SkuCode) { try { using (var context = new SalesReturndbEntities()) { List <SP_GetBatchNo_Result> objList = context.SP_GetBatchNo(SkuCode).ToList(); objList.Add(new SP_GetBatchNo_Result { Product_ID = null, SKUCode = "Other", SKUDescription = "Other", Batch_No = "Other" }); return(objList); } } catch (Exception ex) { throw ex; } }
public static List <EmployeeMasterModel> getEmployeeList() { using (var context = new SalesReturndbEntities()) { var dataList = context.TblEmployeeMasters.Where(x => x.IsActive == true).ToList(); List <EmployeeMasterModel> objList = new List <EmployeeMasterModel>(); if (dataList != null) { objList = dataList.Select(x => new EmployeeMasterModel() { CommercialCode = x.CommercialCode, CommercialHead = x.CommercialHead, ComplaintHandler = x.ComplaintHandler, ComplaintManager = x.ComplaintManager, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, CSO = x.CSO, Depotcode = x.Depotcode, DepotName = x.DepotName, Id = x.Id, IsActive = x.IsActive, ISC = x.ISC, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate, LogisticsHead = x.LogisticsHead, }).ToList(); return(objList); } return(objList); } }
public static List <CCStackHolder> GetCCStackHolderDetail() { using (var context = new SalesReturndbEntities()) { var dataList = context.spGetCCStackHolderDetail().Where(x => x.IsDeleted == false).ToList(); List <CCStackHolder> objList = new List <CCStackHolder>(); if (dataList != null) { objList = dataList.Select(x => new CCStackHolder() { Catalyst = x.Catalyst, ComplaintHandler = x.ComplaintHandler, ComplaintManager = x.ComplaintManager, CreatedBy = x.CreatedBy, IsDeleted = x.IsDeleted, ComplaintStakeHolders_ID = x.ComplaintStakeHolders_ID, CreationDate = x.CreationDate, LocalTechnical = x.LocalTechnical, Manager = x.Manager, SBU_Name = x.SBU_Name, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate, }).ToList(); return(objList); } return(objList); } }
public static string DeleteList(int id, string employeeCode) { using (var context = new SalesReturndbEntities()) { using (TransactionScope transaction = new TransactionScope()) { var Check = context.TblEmployeeMasters.Where(x => x.IsActive == true && x.Id == id).FirstOrDefault(); if (Check != null) { //update Check.IsActive = false; Check.ModifiedBy = employeeCode; Check.ModifiedDate = DateTime.Now; context.Entry(Check).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); transaction.Complete(); transaction.Dispose(); } } return("Success : succssfully deleted."); } }
public static List <PendingRequestModel> GetOpenRequest(string empCode) { List <PendingRequestModel> List = new List <PendingRequestModel>(); using (var context = new SalesReturndbEntities()) { var data = context.SP_GetOpenRequest(empCode).ToList(); if (data.Count != 0) { List = data.Select(x => new PendingRequestModel() { BatchNo = x.BatchNo, DealerAddress = x.DealerAddress, DealerCode = x.DealerCode, DealerName = x.DealerName, DepotName = x.DealerName, DepotAddress = x.DepotAddress, DepotCode = x.DepotCode, RequestHeaderId = x.RequestHeaderId, CurrentStatus = x.CurrentStatus, CurrentStatus_Id = x.CurrentStatus_Id, SKUCode = x.SKUCode, SKUName = x.SKUName, CreatedBy_EMP_CODE = x.CreatedBy, CreatedBy = context.SP_LFGDetails(x.CreatedBy).FirstOrDefault().Emp_First_name, CreatedDate = x.CreatedDate, TotalSRV = context.tblRequestDtls.Where(o => o.RequestHeaderId == x.RequestHeaderId && o.IsActive == true).Sum(p => p.SRVValue), }).ToList(); } return(List); } }
public static string UpdateFlowList(List <FlowMatrixModel> obj) { using (var context = new SalesReturndbEntities()) { foreach (var ob in obj) { try { var InsrtData = context.TblFlowMatrices.Where(x => x.IsActive == true && x.Id == ob.Id).FirstOrDefault(); InsrtData.Id = ob.Id; InsrtData.ISC = ob.ISC; InsrtData.LogisticsHead = ob.LogisticsHead; InsrtData.President = ob.President; InsrtData.RH = ob.RH; InsrtData.SegmentHead = ob.SegmentHead; InsrtData.VP = ob.VP; InsrtData.ComplaintHandler = ob.ComplaintHandler; InsrtData.ComplaintManager = ob.ComplaintManager; InsrtData.ModifiedBy = ob.ModifiedBy; context.Entry(InsrtData).State = EntityState.Modified; context.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); } } return("Success"); } }
public static MailAddressCollection GetCC(RecommendRequestObj obj) { try { using (var context = new SalesReturndbEntities()) { MailAddressCollection ccEmail = new MailAddressCollection(); RequestDetailObj_Render data1 = CommonDAL.GetRequestDetails(obj.Request_Id, obj.CurrentStatus_Id, obj.FutureStatus_Id); var RegionalHead = context.SP_LFGDetails(data1.EmployeeCode).FirstOrDefault(); if (RegionalHead != null) { if (!(RegionalHead.Regional_Head.ToUpper().Trim().Equals("NA") || RegionalHead.Regional_Head.Trim().Equals(string.Empty))) { var RegionalHeadData = context.SP_LFGDetails(RegionalHead.Regional_Head).FirstOrDefault(); ccEmail.Add(RegionalHeadData.email_id); } if (!(RegionalHead.segmentHead.ToUpper().Trim().Equals("NA") || RegionalHead.segmentHead.Trim().Equals(string.Empty))) { var SegmentHeadData = context.SP_LFGDetails(RegionalHead.segmentHead).FirstOrDefault(); ccEmail.Add(SegmentHeadData.email_id); } ccEmail.Add(RegionalHead.email_id);//Email Id of Requestor } var DepotMaster = context.SP_GetDepotList().Where(x => x.DepotId == data1.DepotId).FirstOrDefault(); var AssintoEmp = context.TblEmployeeMasters.Where(x => x.IsActive == true && x.DepotName == DepotMaster.DepotName).FirstOrDefault(); var ComplaintHandler = context.SP_LFGDetails(AssintoEmp.ComplaintHandler).FirstOrDefault(); var CompalintManager = context.SP_LFGDetails(AssintoEmp.ComplaintManager).FirstOrDefault(); ccEmail.Add(ComplaintHandler.email_id); ccEmail.Add(CompalintManager.email_id); var LogistickHead = context.SP_LFGDetails(AssintoEmp.LogisticsHead).FirstOrDefault(); ccEmail.Add(LogistickHead.email_id); if (RegionalHead != null) { if (!(RegionalHead.VPHead.ToUpper().Trim().Equals("NA") || RegionalHead.VPHead.Trim().Equals(string.Empty))) { var vphead = context.sp_GetuserDetailsFromLFG(RegionalHead.VPHead).FirstOrDefault(); ccEmail.Add(vphead.email_id); } if (!(RegionalHead.President_Code.ToUpper().Trim().Equals("NA") || RegionalHead.President_Code.Trim().Equals(string.Empty))) { var President_Code = context.sp_GetuserDetailsFromLFG(RegionalHead.President_Code).FirstOrDefault(); ccEmail.Add(President_Code.email_id); } } var depot = context.SP_LFGDetails(AssintoEmp.Depotcode).FirstOrDefault(); ccEmail.Add(depot.email_id); var cso = context.SP_LFGDetails(AssintoEmp.CSO).FirstOrDefault(); ccEmail.Add(cso.email_id); return(ccEmail); } } catch (Exception ex) { throw ex; } }
public static int GetApprovedRequestCount(string empCode) { using (var context = new SalesReturndbEntities()) { int Count = context.SP_GetApprovedRequest(empCode).Count(); return(Count); } }
public static List <spGetMasterReportData_Result> GetMasterReport(DateTime datefrom, DateTime dateTo) { using (var context = new SalesReturndbEntities()) { var dataobj = context.spGetMasterReportData(datefrom, dateTo).ToList(); return(dataobj); } }
public static int GetPendingSRVBillingClosureRequestCount(string empCode) { using (var context = new SalesReturndbEntities()) { int Count = context.SP_GetPendingRequestForDepot(empCode).Count(); return(Count); } }
public static int GetSalesTotalRequestCount(string empCode) { using (var context = new SalesReturndbEntities()) { int Count = context.SP_GetTotalRequest(empCode).Where(x => x.SKUCode == "S").Count(); return(Count); } }
public static DateTime GetLastThreeMonthDate() { using (var context = new SalesReturndbEntities()) { var dat = DateTime.Now.AddMonths(-3); return(dat); } }
public static string UpdateAdminList(List <AdminMasterModal> data) { using (var context = new SalesReturndbEntities()) { using (TransactionScope transaction = new TransactionScope()) { foreach (var Obj in data) { //CommonDAL.CheckIfEmployeeExist(Obj.VPName); var duplicateCheck = context.TblAdminMasters.Where(x => x.Admin_Id == Obj.Admin_Id && x.IsActive == true).FirstOrDefault(); if (duplicateCheck != null) { var duplicateCheckValue = context.TblAdminMasters.Where(x => x.EmployeeCode == Obj.EmployeeCode && x.Admin_Id != Obj.Admin_Id && x.IsActive == true).FirstOrDefault(); if (duplicateCheckValue == null) { duplicateCheck.EmployeeCode = Obj.EmployeeCode; duplicateCheck.ModifiedBy = Obj.CreatedBy; duplicateCheck.ModifiedDate = DateTime.Now; context.Entry(duplicateCheck).State = EntityState.Modified; context.SaveChanges(); } } else { var duplicateCheckValue = context.TblAdminMasters.Where(x => x.EmployeeCode == Obj.EmployeeCode && x.IsActive == true).FirstOrDefault(); if (duplicateCheckValue == null) { TblAdminMaster marix = new TblAdminMaster() { EmployeeCode = Obj.EmployeeCode, IsActive = true, CreatedBy = Obj.CreatedBy, CreatedDate = DateTime.Now, }; context.Entry(marix).State = EntityState.Added; context.SaveChanges(); } } } transaction.Complete(); transaction.Dispose(); } return("Success : Admin list successfully updated."); } }
public static string CloseRequest(CloseRequestObjForStg_4 data) { using (var context = new SalesReturndbEntities()) { string AssignTo = string.Empty; string RetMsg = string.Empty; var RequestDetail = context.tblRequestDtls.Where(x => x.RequestHeaderId == data.Request_Id).ToList(); var approvalHeader = context.TblApproverHeaders.Where(x => x.Request_Id == data.Request_Id).FirstOrDefault(); var ReqHdr = context.TblRequestHeaders.Where(x => x.RequestHeaderId == data.Request_Id && x.IsActive == true).FirstOrDefault(); var UserDetail = context.SP_LFGDetails(approvalHeader.CreatedBy).FirstOrDefault(); var DlrDtl = context.sp_GetDealerDtlBy_DealerRepositoryId(data.Request.DealerId).FirstOrDefault(); if (data.FutureStatus_Id == 10027 || data.CurrentStatus_Id == 10028 || data.CurrentStatus_Id == 10029) { var EmpMaster = context.TblEmployeeMasters.Where(x => x.DepotName == DlrDtl.Depot && x.IsActive == true).FirstOrDefault(); AssignTo = data.FutureStatus_Id == 10027 ? EmpMaster.Depotcode : ""; if (data.Request.IsCommercialSettlement == true) { var EpCheck = context.sp_CheckEPNumber(data.Request.EPNo).FirstOrDefault(); if (EpCheck == null) { return("Error: EP Number does not exists"); } } ReqHdr.IsCommercialSettlement = data.Request.IsCommercialSettlement; ReqHdr.MaterialWillGoToDealer = data.Request.IsCommercialSettlement == true ? false : true; ReqHdr.ReasonForCommercialSettlement = data.Request.IsCommercialSettlement == true ? data.Request.ReasonForCommercialSettlement : ""; ReqHdr.DetailsForMaterialGoToDealer = data.Request.IsCommercialSettlement == false ? data.Request.DetailsForMaterialGoToDealer : ""; ReqHdr.EPNo = data.Request.IsCommercialSettlement == true ? data.Request.EPNo : ""; ReqHdr.ModifiedBy = data.EmployeeCode; ReqHdr.ModifiedDate = DateTime.Now; context.Entry(ReqHdr).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); RetMsg = data.FutureStatus_Id == 10027 ? "Request has been forwarded to Depot!" : "Request has been closed successfully!"; } else if (data.CurrentStatus_Id == 10030) { ReqHdr.DocketNumber = data.Request.DocketNumber; ReqHdr.DocketDate = data.Request.DocketDate; context.Entry(ReqHdr).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); RetMsg = "Request has been closed successfully!"; } else { RetMsg = "Request has been closed successfully!"; } ApproverDAL.UpdateRequestStatus(false, Convert.ToInt32(data.Request_Id), data.EmployeeCode, AssignTo, data.Active_Role, data.Requested_Role, data.CurrentStatus_Id, data.FutureStatus_Id, data.Remarks); return("Success : " + ReqHdr.RequestTypeOption + data.Request_Id + " " + RetMsg); } }
public static string SaveRequestType(List <RequestTypeModal> list) { using (var context = new SalesReturndbEntities()) { using (TransactionScope transaction = new TransactionScope()) { foreach (var obj in list) { var duplicateCheck = context.TblRequestTypes.Where(x => x.IsActive == true && x.RequestType_Id == obj.RequestType_Id).FirstOrDefault(); if (duplicateCheck != null) { var duplicateValueCheck = context.TblRequestTypes.Where(x => x.RequestType.Equals(obj.RequestType) && x.IsActive == true && x.RequestType_Id != obj.RequestType_Id).FirstOrDefault(); if (duplicateValueCheck == null) { //update duplicateCheck.RequestType = obj.RequestType; duplicateCheck.ModifiedBy = obj.EmployeeCode; duplicateCheck.ModifiedDate = DateTime.Now; context.Entry(duplicateCheck).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } } else { var duplicateValueCheck = context.TblRequestTypes.Where(x => x.RequestType.Equals(obj.RequestType) && x.IsActive == true).FirstOrDefault(); if (duplicateValueCheck == null) { //new entry TblRequestType RequestType = new TblRequestType() { RequestType = obj.RequestType, IsActive = true, CreatedBy = obj.EmployeeCode, CreatedDate = DateTime.Now, }; context.Entry(RequestType).State = System.Data.Entity.EntityState.Added; context.SaveChanges(); } } } transaction.Complete(); transaction.Dispose(); } return("Success : Request types succssfully saved"); } }
public static string RejectRequest(RecommendRequestObj data) { using (var context = new SalesReturndbEntities()) { string RequestProcessType = "reject"; string AssignTo = string.Empty; var RequestDetail = context.tblRequestDtls.Where(x => x.RequestHeaderId == data.Request_Id).ToList(); var approvalHeader = context.TblApproverHeaders.Where(x => x.Request_Id == data.Request_Id).FirstOrDefault(); var ReqHdr = context.TblRequestHeaders.Where(x => x.RequestHeaderId == data.Request_Id && x.IsActive == true).FirstOrDefault(); var IfDepotPerson = context.TblEmployeeMasters.Where(x => x.Depotcode == ReqHdr.EmployeeCode && x.IsActive == true).FirstOrDefault(); var UserDetail = context.SP_LFGDetails(approvalHeader.CreatedBy).FirstOrDefault(); var Reqfuturestatus = context.TblFutureStatus.Where(x => x.IsActive == true && x.Request_ID == ReqHdr.RequestHeaderId).OrderByDescending(y => y.FutStatus_ID).FirstOrDefault(); if (data.FutureStatus_Id == 10026 && IfDepotPerson == null) { if (UserDetail.Regional_Head.Trim().Equals("NA") || UserDetail.Regional_Head.Trim().Equals("N/A")) { return("Error: Approval Matrix not defined!!"); } else { AssignTo = UserDetail.Regional_Head; ApproverDAL.UpdateRequestStatus(false, Convert.ToInt32(data.Request_Id), data.EmployeeCode, AssignTo, data.Active_Role, data.Requested_Role, data.CurrentStatus_Id, data.FutureStatus_Id, data.Remarks); } } else if (data.FutureStatus_Id == 10026 && IfDepotPerson != null) { var DealerDtl = context.sp_GetDealerDtlBy_DealerRepositoryId(ReqHdr.DealerId).FirstOrDefault(); bool IsRMExist = DealerDtl != null ? (DealerDtl.RMCode.Equals(string.Empty) ? false : (DealerDtl.RMCode.Contains("NA") ? false : (DealerDtl.RMCode == null ? false : true))) : false; //if (IsRMExist) { if (UserDetail.Regional_Head != "NA" && UserDetail.Regional_Head != null && UserDetail.Regional_Head != "") { // AssignTo = DealerDtl.RMCode; AssignTo = UserDetail.Regional_Head; ApproverDAL.UpdateRequestStatus(false, Convert.ToInt32(data.Request_Id), data.EmployeeCode, AssignTo, data.Active_Role, data.Requested_Role, data.CurrentStatus_Id, data.FutureStatus_Id, data.Remarks); } else { return("Error: Approval Matrix not defined!!"); } } else { ApproverDAL.UpdateRequestStatus(false, Convert.ToInt32(data.Request_Id), data.EmployeeCode, AssignTo, data.Active_Role, data.Requested_Role, data.CurrentStatus_Id, data.FutureStatus_Id, data.Remarks); } SendMail(approvalHeader, data, RequestProcessType, ReqHdr.EmployeeCode); return("Success : " + ReqHdr.RequestTypeOption + data.Request_Id + " Requested has been rejected successfully."); } }
public static bool CheckIfEmployeeExist(string EmployeeCode) { using (var context = new SalesReturndbEntities()) { var check = context.SP_LFGDetails(EmployeeCode).FirstOrDefault(); if (check != null) { return(true); } else { return(false); } } }
public static TblEmployeeMaster CheckIfDepotPerson(string Emp_Code) { using (var DbContext = new SalesReturndbEntities()) { var source = DbContext.TblEmployeeMasters.Where(x => x.Depotcode == Emp_Code && x.IsActive == true).FirstOrDefault(); if (source != null) { return(source); } else { return(null); } } }
public static string ReconsiderRequest(RecommendRequestObj data) { using (var context = new SalesReturndbEntities()) { string RequestProcessType = "reconsider"; var RequestDetail = context.tblRequestDtls.Where(x => x.RequestHeaderId == data.Request_Id).ToList(); var approvalHeader = context.TblApproverHeaders.Where(x => x.Request_Id == data.Request_Id).FirstOrDefault(); //var UserDetail = context.SP_LFGDetails(approvalHeader.CreatedBy).FirstOrDefault(); var Reqfuturestatus = context.TblFutureStatus.Where(x => x.IsActive == true && x.Request_ID == approvalHeader.Request_Id).OrderByDescending(y => y.FutStatus_ID).FirstOrDefault(); ApproverDAL.UpdateRequestStatus(false, Convert.ToInt32(data.Request_Id), data.EmployeeCode, approvalHeader.CreatedBy, data.Active_Role, data.Requested_Role, data.CurrentStatus_Id, data.FutureStatus_Id, data.Remarks); SendMail(approvalHeader, data, RequestProcessType, approvalHeader.CreatedBy); return("Success : S-" + data.Request_Id + " Requested has been reconsidered successfully."); } }
public static EmployeeDetailsInfo GetEmployeeRequestDetails(long RequestId) { using (var context = new SalesReturndbEntities()) { var item = context.SP_GetEmployeeDetailsForRequest(RequestId).FirstOrDefault(); EmployeeDetailsInfo list = new EmployeeDetailsInfo(); list.EMP_CODE = item.EMP_CODE; list.Emp_First_name = item.Emp_First_name; list.Added_Date = Convert.ToDateTime(item.CreatedDate); list.SBU_Name = item.Seg_Name; list.Dept_name = item.Dept_name; return(list); } }
public static List <CountryModal> GetCountry() { using (var context = new SalesReturndbEntities()) { var list = context.SP_GetCountry().ToList(); List <CountryModal> cityList = null; if (list != null) { cityList = list.Select(x => new CountryModal() { CountryName = x.Country }).ToList(); return(cityList); } return(cityList); } }
public static string GetHtml(string html, RecommendRequestObj obj) { using (var context = new SalesReturndbEntities()) { RequestDetailObj_Render data1 = CommonDAL.GetRequestDetails(obj.Request_Id, obj.CurrentStatus_Id, obj.FutureStatus_Id); string RequestNumber = data1.RequestTypeOption + "-" + data1.RequestHeader_Id; int SKUCount = data1.RequestDetail.Count; html = html.Replace("<CustomerCode>", data1.DealerCodeForMail); html = html.Replace("<CustomerName>", data1.DealerNameForMail); html = html.Replace("<RequestNumber>", RequestNumber); html = html.Replace("<DepotName>", data1.DepotNameForMail); var reason = context.TblReasonMasters.Where(x => x.ReasonMaster_Id == data1.ReasonForReturn_Id).FirstOrDefault(); html = html.Replace("<Reason>", reason.Reason); html = html.Replace("<CountofSKUs>", SKUCount.ToString()); //html = html.Replace("Requestor Name;", SKUCount.ToString()); decimal?SalesReturnVolume = 0; decimal?SRVValue = 0; decimal?ExpiredVoulme = 0; //ToString("0.00"); for (int i = 0; i < data1.RequestDetail.Count; i++) { if (data1.RequestDetail[i].Volume != null) { SalesReturnVolume += data1.RequestDetail[i].Volume; } if (data1.RequestDetail[i].SRVValue != null) { SRVValue = SRVValue + data1.RequestDetail[i].SRVValue; } if (Convert.ToInt32(data1.RequestDetail[i].selectedSKU.Shelf_Life) < 0) { ExpiredVoulme = ExpiredVoulme + data1.RequestDetail[i].Volume; } } html = html.Replace("<SalesReturnVolume>", Convert.ToDecimal(string.Format("{0:F2}", SalesReturnVolume)).ToString()); html = html.Replace("<VolumeExpired>", Convert.ToDecimal(string.Format("{0:F2}", ExpiredVoulme)).ToString()); html = html.Replace("<SalesReturnAmount>", Convert.ToDecimal(string.Format("{0:F2}", SRVValue)).ToString()); return(html); } }
public static List <ReasonMasterModal> GetReasonMaster() { using (var context = new SalesReturndbEntities()) { List <ReasonMasterModal> dataList = null; var objList = context.TblReasonMasters.Where(x => x.IsActive == true).ToList(); if (objList != null) { dataList = objList.Select(x => new ReasonMasterModal() { Reason = x.Reason, ReasonMaster_Id = x.ReasonMaster_Id }).ToList(); return(dataList); } return(dataList); } }
public static LoginModel GetEmployeeDetails(string id, string conn) { LoginModel user = null; using (var DbContext = new SalesReturndbEntities()) { var source = DbContext.SP_LFGDetails(id).FirstOrDefault(); var IfDepotPerson = DbContext.sp_CheckIfDepotPerson(id).FirstOrDefault(); if (source != null) { user = new LoginModel { EMP_CODE = source.EMP_CODE.ToString(), Emp_First_name = source.Emp_First_name.ToString(), Desg_Desc = source.Desg_Desc, Dept_name = source.Dept_name, IsDepotPerson = IfDepotPerson != null?true:false, DepotName = IfDepotPerson?.DepotName, DepotCode = IfDepotPerson?.DepotCode, Seg_Name = source.Seg_Name, DepotId = IfDepotPerson != null? IfDepotPerson.DepotId:0, email_id = source.email_id, Mobile_no = source.Mobile_no, SBU_Name = source.SBU_Name, Zone = source.Zone, RegionHead = source.Regional_Head, SegmentHead = source.Country_Head, Oth_key = id, Country = source.Country }; var checkAdmin = DbContext.TblAdminMasters.Where(x => x.EmployeeCode.Equals(id) && x.IsActive == true).FirstOrDefault(); if (id.Equals("0") || checkAdmin != null) { user.RoleName = "Admin"; } } } return(user); }
public static List <DivisionList> getDivisionForBU(string BU) { using (var context = new SalesReturndbEntities()) { var list = context.SP_Get_Division_For_BU(BU).ToList(); List <DivisionList> DivisionList = null; if (list != null) { DivisionList = list.Select(x => new DivisionList() { DivisionName = x.Dept_name }).ToList(); return(DivisionList); } return(DivisionList); } }
public static List <AdminMasterModal> getAdminList() { using (var context = new SalesReturndbEntities()) { var dataList = context.TblAdminMasters.Where(x => x.IsActive == true).ToList(); List <AdminMasterModal> objList = null; if (dataList != null) { objList = dataList.Select(x => new AdminMasterModal() { Admin_Id = x.Admin_Id, EmployeeCode = x.EmployeeCode }).ToList(); return(objList); } return(objList); } }
public static List <EmployeeCommanModal> GetSalesDirector(SearchModal Obj) { using (var context = new SalesReturndbEntities()) { var list = context.SP_GetEmployeeForBU_Division_Country(Obj.BUName, Obj.DivisionName, Obj.CountryName).ToList(); List <EmployeeCommanModal> empList = null; if (list != null) { empList = list.Select(x => new EmployeeCommanModal() { EmployeeCode = x.EMP_CODE, EmployeeName = x.Emp_First_name, }).ToList(); return(empList); } return(empList); } }