public static List <ModelAndFuelTypeStatus> MonthAndFuelTypeStatus(FilterData Obj) { using (var Context = new BSSDBEntities()) { List <ModelAndFuelTypeStatus> ModelAndFuelTypeStatus = null; var ReqData = Context.sp_ModelAndFuelTypeStatus(Obj.DealerID, Obj.AccountId, Obj.Month, Obj.Year).ToList(); if (ReqData.Count != 0) { ModelAndFuelTypeStatus = ReqData.Select(x => new ModelAndFuelTypeStatus { GrandTotal = x.GrandTotal == null ? 0 : x.GrandTotal, Model = x.Model }).ToList(); ModelAndFuelTypeStatus.Add(new BODYSHPBLL.ImplBLL.ModelAndFuelTypeStatus { Model = "Total", GrandTotal = ReqData.Sum(x => x.GrandTotal) }); return(ModelAndFuelTypeStatus); } else { return(ModelAndFuelTypeStatus); } } }
public static string AddEmail(EmailListModel Obj) { using (var DbContext = new BSSDBEntities()) { var ReqData = DbContext.TblEmailMasters.Where(x => x.PersonName == Obj.PersonName && x.AccountId == Obj.AccountId && x.DealerId == Obj.DealerId).FirstOrDefault(); if (ReqData == null) { TblEmailMaster TM = new TblEmailMaster { IsDeleted = false, PersonName = Obj.PersonName, Email_ID = Obj.Email_ID, AccountId = Obj.AccountId, DealerId = Obj.DealerId, CreationDate = DateTime.Now, CreatedBy = Obj.CreatedBy }; DbContext.Entry(TM).State = System.Data.Entity.EntityState.Added; DbContext.SaveChanges(); return("Updated Successfully"); } else { return("Already Exixts!"); } } }
public static string AddInsuranceCmp(InsuranceCmpList Obj) { using (var DbContext = new BSSDBEntities()) { var ReqData = DbContext.Tbl_InsuranceCmpMaster.Where(x => x.CompanyName == Obj.CompanyName && x.CompanyCode == Obj.CompanyCode && x.DealerId == Obj.DealerId && x.AccountId == Obj.AccountId && x.IsDeleted == false).FirstOrDefault(); if (ReqData == null) { Tbl_InsuranceCmpMaster TIC = new Tbl_InsuranceCmpMaster { CompanyName = Obj.CompanyName, CompanyCode = Obj.CompanyCode, IsDeleted = false, CreatedBy = Obj.CreatedBy, AccountId = Obj.AccountId, DealerId = Obj.DealerId, CreationDate = DateTime.Now }; DbContext.Entry(TIC).State = System.Data.Entity.EntityState.Added; DbContext.SaveChanges(); return("Added successfully !"); } else { return("Already exist !"); } } }
public static List <MonthWiseReport> GetMonthWiseReport(MonthWiseInput obj) { List <MonthWiseReport> Result = null; using (var dbContext = new BSSDBEntities()) { var ReqData = dbContext.SP_ConsolidatedReport(obj.DealerID, obj.AccountID, obj.Days).ToList(); Result = ReqData.Select(x => new MonthWiseReport { ContractorName = x.ContractorName, DateAndTime = x.DateAndTime.Value.ToString("dd/MM/yyyy"), JobCardNo = x.JobCardNo, Model = x.Model, CustomerName = x.CustomerName, ModifiedDate = x.ModifiedDate, No_of_Panel = x.No_of_Panel, Panel_Replaced = x.Panel_Replaced, PhoneNo = x.PhoneNo, PromisedDate = x.PromisedDate, RegistrationNo = x.RegistrationNo, Service = x.Service, StatusName = x.StatusName, CompanyName = x.CompanyName, NoOfGlass = x.NoOfGlass, PaymentMode = x.PaymentMode, PhotoUrl = x.PhotoUrl }).ToList(); } return(Result); }
public static bool UpdateContractor(ContractorModel Obj) { using (var dbContext = new BSSDBEntities()) { var Check = dbContext.tblContractorMasters.Where(x => x.ContractorCode == Obj.ContractorCode && x.DealerID == Obj.DealerID && x.AccountID == Obj.AccountID).FirstOrDefault(); if (Check != null) { Check.ContractorName = Obj.ContractorName; Check.ContractorCode = Obj.ContractorCode; Check.CreatedBy = Obj.CreatedBy; Check.AccountID = Obj.AccountID; Check.IsDeleted = false; Check.Address = Obj.Address; Check.Phone = Obj.Phone; Check.CreationDate = DateTime.Now; Check.DealerID = Obj.DealerID; dbContext.Entry(Check).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); return(true); } else { return(false); } } }
public static string UpdateInsuranceCmp(InsuranceCmpList Obj) { using (var DbContext = new BSSDBEntities()) { var ReqData = DbContext.Tbl_InsuranceCmpMaster.Where(x => x.InsuranceCompanyId == Obj.InsuranceCompanyId).FirstOrDefault(); if (ReqData != null) { ReqData.CompanyName = Obj.CompanyName; ReqData.CompanyCode = Obj.CompanyCode; ReqData.IsDeleted = Obj.IsDeleted; ReqData.ModifiedBy = Obj.CreatedBy; ReqData.AccountId = Obj.AccountId; ReqData.DealerId = Obj.DealerId; ReqData.ModifiedDate = DateTime.Now; DbContext.Entry(ReqData).State = System.Data.Entity.EntityState.Modified; DbContext.SaveChanges(); return("Updated successfully !"); } else { return("Does not exist !"); } } }
public static bool AddContractor(ContractorModel Obj) { using (var dbContext = new BSSDBEntities()) { var Check = dbContext.tblContractorMasters.Where(x => x.ContractorCode == Obj.ContractorCode && x.DealerID == Obj.DealerID && x.AccountID == Obj.AccountID).FirstOrDefault(); if (Check == null) { tblContractorMaster Cm = new tblContractorMaster() { ContractorName = Obj.ContractorName, ContractorCode = Obj.ContractorCode, CreatedBy = Obj.CreatedBy, AccountID = Obj.AccountID, IsDeleted = false, Address = Obj.Address, Phone = Obj.Phone, CreationDate = DateTime.Now, DealerID = Obj.DealerID }; dbContext.Entry(Cm).State = System.Data.Entity.EntityState.Added; dbContext.SaveChanges(); return(true); } else { return(false); } } }
public static void InsertIntoTblDtl(string JobCardNo, SessionDataBLL obj) { using (var context = new BSSDBEntities()) { var JobCardId = context.TblJobCardHdrs.Where(x => x.JobCardNo == JobCardNo && x.DealerID == obj.DealerID).Select(x => x.JobCardId).FirstOrDefault(); var Check = context.TblJobCardDtls.Where(x => x.JobCardId == JobCardId).FirstOrDefault(); if (Check == null) { TblJobCardDtl tb = new TblJobCardDtl { JobCardId = JobCardId, StatusID = 17, IsDeleted = false, CreatedBy = obj.UserId, CreationDate = DateTime.Now, //ModifiedBy=obj.UserId, //ModifiedDate=DateTime.Now }; context.Entry(tb).State = EntityState.Added; context.SaveChanges(); } } }
public static SessionDataBLL CheckLogin(LoginBLL obj) { using (var dbContext = new BSSDBEntities()) { var Check = dbContext.TblUsers.Where(x => x.UserName == obj.UserName && x.Password == obj.Password && x.IsActive == true).FirstOrDefault(); if (Check != null) { var DesignationID = dbContext.TblEmployees.Where(x => x.EmpId == Check.EmpId).Select(x => x.DesignationID).FirstOrDefault(); var Details = dbContext.TblEmployees.Where(x => x.EmpId == Check.EmpId).FirstOrDefault(); SessionDataBLL SessionData = new SessionDataBLL { UserId = Check.UserID, UserName = Check.UserName, AccountId = Details.AccountID.Value, EmployeeId = Check.EmpId.Value, DesignationID = Convert.ToInt64(DesignationID), DealerID = Details.DealerID.Value, }; return(SessionData); } else { return(null); } } }
public static List <JobcardDetails> GetDetailForJobcard(string JobcardNo) { //List<SpGetCompleteDetails_Result> ListData = null; using (var dbContext = new BSSDBEntities()) { var ReqData = dbContext.sp_GetDetailForJobcard(JobcardNo).ToList(); if (ReqData.Count != 0) { List <JobcardDetails> ListData = ReqData.Select(x => new JobcardDetails() { JobCardId = x.JobCardId, JobCardNo = x.JobCardNo, CustomerCategory = x.CustomerCategory, CustomerName = x.CustomerName, DateAndTime = x.DateAndTime, Model = x.Model, PhoneNo = x.PhoneNo, PromisedDate = x.PromisedDate, SA = x.SA, Service = x.Service, RegistrationNo = x.RegistrationNo, PSFStatus = x.PSFStatus, Technician = x.Technician, DealerID = x.DealerID, CreatedBy = x.CreatedBy, No_Of_Panel = x.No_Of_Panel, PanelReplaced = x.PanelReplaced, StatusID = x.StatusID, ContractorName = x.ContractorName, PaymentMode = x.PaymentMode, PhotoUrl = x.PhotoUrl, NoOfGlass = x.NoOfGlass, ContractorCode = x.ContractorCode, AccountID = x.AccountID, ContractorId = x.ContractorId, CreationDate = x.CreationDate, InsuranceCompanyId = x.InsuranceCompanyId, ModifiedDate = x.ModifiedDate, MogifiedBy = x.MogifiedBy, PhotoId = x.PhotoId, ReadyDateTime = x.ReadyDateTime, RevPromisedDate = x.RevPromisedDate, StatusAddedDate = x.StatusAddedDate, StatusCode = x.StatusCode, StatusModifiedDate = x.StatusModifiedDate, StatusName = x.StatusName, CompanyName = x.CompanyName }).ToList(); return(ListData); } else { return(null); } } }
public static List <spGetStatusDetails_Result> Get(long Sno) { List <spGetStatusDetails_Result> Obj = null;; using (var dbContext = new BSSDBEntities()) { var ReqData = dbContext.spGetStatusDetails(Sno); Obj = ReqData.ToList(); } return(Obj); }
public static List <SpContractorWiseDtl_Result> GetContractorWiseDtl(ContractorModel obj) { List <SpContractorWiseDtl_Result> StatusResult = null; using (var dbContext = new BSSDBEntities()) { var ReqData = dbContext.SpContractorWiseDtl(obj.Contractor_Id, obj.DealerID, obj.AccountID); StatusResult = ReqData.ToList(); } return(StatusResult); }
public static List <SpStatusWiseDtl_Result> GetData(StatusWiseBLL obj) { List <SpStatusWiseDtl_Result> StatusResult = null; using (var dbContext = new BSSDBEntities()) { var ReqData = dbContext.SpStatusWiseDtl(obj.StatusID, obj.DealerID, obj.AccountId); StatusResult = ReqData.ToList(); } return(StatusResult); }
public static List <SpGetDateWiseDetails_Result> GetData(DateWiseReportBLL obj) { List <SpGetDateWiseDetails_Result> StatusResult = null; using (var dbContext = new BSSDBEntities()) { var ReqData = dbContext.SpGetDateWiseDetails(obj.StartDate, obj.EndDate, obj.DealerID, obj.AccountId); StatusResult = ReqData.ToList(); } return(StatusResult); }
public static List <SpGetStatusReadyDeliver_Result> GetStatusName(SessionDataBLL Obj) { List <SpGetStatusReadyDeliver_Result> spData = null; using (var dbContext = new BSSDBEntities()) { var ReqData = dbContext.SpGetStatusReadyDeliver(Obj.DealerID, Obj.AccountId); spData = ReqData.ToList(); } return(spData); }
public static List <spGetBrandList_Result> BrandList() { List <spGetBrandList_Result> BrandListData = null; using (var dbContext = new BSSDBEntities()) { var ReqData = dbContext.spGetBrandList(); BrandListData = ReqData.ToList(); } return(BrandListData); }
public static List <SpGetStatus_Result> GetData(SessionDataBLL Obj) { List <SpGetStatus_Result> StatusResult = null; using (var dbContext = new BSSDBEntities()) { var ReqData = dbContext.SpGetStatus(Obj.DealerID, Obj.AccountId); StatusResult = ReqData.ToList(); } return(StatusResult); }
public static List <spGetStatusDetails_Result> Detail(long Sno) { List <spGetStatusDetails_Result> JobCardDetail = null; using (var dbContext = new BSSDBEntities()) { var ReqData = dbContext.spGetStatusDetails(Sno); JobCardDetail = ReqData.ToList(); } return(JobCardDetail); }
public static List <spGetStatusPopUpDetails_Result> StatusPopup(long Sno) { List <spGetStatusPopUpDetails_Result> StatusPopupData = null; using (var dbContext = new BSSDBEntities()) { var ReqData = dbContext.spGetStatusPopUpDetails(Sno); StatusPopupData = ReqData.ToList(); } return(StatusPopupData); }
public static void Delete(long StatusID) { using (var dbContext = new BSSDBEntities()) { var Check = dbContext.TblStatus.Where(x => x.StatusID == StatusID).FirstOrDefault(); if (Check != null) { Check.IsDeleted = true; dbContext.Entry(Check).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } } }
public static void Update(string BrandName, long BrandId) { using (var dbContext = new BSSDBEntities()) { var Check = dbContext.tblBrands.Where(x => x.BrandId == BrandId).FirstOrDefault(); if (Check != null) { Check.BrandName = BrandName; dbContext.Entry(Check).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } } }
public static string UpDate(EmailListModel Obj) { using (var DbContext = new BSSDBEntities()) { var ReqData = DbContext.TblEmailMasters.Where(x => x.Id == Obj.Id).FirstOrDefault(); ReqData.IsDeleted = Obj.IsDeleted; ReqData.PersonName = Obj.PersonName; ReqData.Email_ID = Obj.Email_ID; ReqData.ModifiedDate = DateTime.Now; ReqData.ModifiedBy = Obj.ModifiedBy; DbContext.Entry(ReqData).State = System.Data.Entity.EntityState.Modified; DbContext.SaveChanges(); return("Updated Successfully"); } }
public static List <EmailListModel> GetData(SessionDataBLL Obj) { using (var DbContext = new BSSDBEntities()) { var ReqData = DbContext.SP_GetEmailList(Obj.DealerID, Obj.AccountId).ToList(); List <EmailListModel> EmailList = ReqData.Select(x => new EmailListModel { Id = x.Id, PersonName = x.PersonName, Email_ID = x.Email_ID, IsDeleted = x.IsDeleted, AccountId = x.AccountId, DealerId = x.DealerId, }).ToList(); return(EmailList); } }
public static void Update(StatusWiseBLL obj) { using (var dbContext = new BSSDBEntities()) { var Check = dbContext.TblStatus.Where(x => x.StatusID == obj.StatusID && x.AccountId == obj.AccountId && x.DealerId == obj.DealerID).FirstOrDefault(); if (Check != null) { Check.StatusName = obj.StatusName; Check.ShortName = obj.ShortName; Check.StatusCode = obj.StatusCode; Check.ModifiedDate = DateTime.Now; dbContext.Entry(Check).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } } }
public static string GenerateHtml(SessionDataBLL Obj) { using (var dbContext = new BSSDBEntities()) { var ReqData = dbContext.SP_StatusWiseCompleteReport(Obj.DealerID, Obj.AccountId).ToList(); string Html = "<!DOCTYPE html><html><head><style>table, th, td {border: 1px solid black;border-collapse: collapse;}</style></head><body><br /> <label>Please find attachment for group wise report. Status wise report is Shown below :-</label><br /><br /><table><thead><tr><th>Status Name:</th><th>No. Of JobCards</th></tr></thead>"; Html = Html + "<tbody>"; foreach (var data in ReqData) { Html = Html + "<tr><td>" + data.StatusName + "</td><td>" + data.NoOfJobCards + "</td></tr>"; } Html = Html + "</tbody></table><br /><br />"; Html = Html + "<label>Regards,</label><br /><label>BodyShop Application</label><br /><br />"; Html = Html + "<label>This is an auto generated mail, Do not reply</label><br /></body></html>"; return(Html); } }
public static List <InsuranceCmpList> GetInsuranceCmpList(SessionDataBLL Obj) { using (var DbContext = new BSSDBEntities()) { List <InsuranceCmpList> InsuranceCmpList = null; var ReqData = DbContext.SP_GetInsuranceCmpList(Obj.DealerID, Obj.AccountId).ToList(); InsuranceCmpList = ReqData.Select(x => new InsuranceCmpList { InsuranceCompanyId = x.InsuranceCompanyId, CompanyName = x.CompanyName, CompanyCode = x.CompanyCode, IsDeleted = x.IsDeleted, AccountId = x.AccountId, DealerId = x.DealerId }).ToList(); return(InsuranceCmpList); } }
public static void AddQuery(AddQueryBLL obj) { string JobCardNo = obj.JobCardNo; using (var dbcontext = new BSSDBEntities()) { var Check = dbcontext.TblJobCardHdrs.Where(x => x.JobCardNo == JobCardNo).FirstOrDefault(); if (Check == null) { TblJobCardHdr TR = new TblJobCardHdr { JobCardNo = obj.JobCardNo, DateAndTime = DateTime.Now, CustomerName = obj.CustomerName, PhoneNo = obj.PhoneNo, CustomerCategory = obj.CustomerCategory, PSFStatus = obj.PSFStatus, RegistrationNo = obj.RegistrationNo, Model = obj.Model, SA = obj.SA, Technician = obj.Technician, Service = obj.Service, PromisedDate = obj.PromisedDate }; dbcontext.Entry(TR).State = EntityState.Added; dbcontext.SaveChanges(); var JobCardId = dbcontext.TblJobCardHdrs.Where(x => x.JobCardNo == JobCardNo).Select(s => s.JobCardId).FirstOrDefault(); TblJobCardDtl tb = new TblJobCardDtl { JobCardId = JobCardId, No_Of_Panel = obj.NoOfPanel, PanelReplaced = obj.PanelReplaced, //Status=obj.Status }; dbcontext.Entry(tb).State = EntityState.Added; dbcontext.SaveChanges(); } } }
public static string UpdateStatus(UpdateStatusBLL obj, string PhotoUrl) { long JobCardId = Convert.ToInt64(obj.JobCardId); using (var dbContext = new BSSDBEntities()) { var UpdateData = dbContext.TblJobCardDtls.Where(x => x.JobCardId == JobCardId).FirstOrDefault(); var UpdateHdrData = dbContext.TblJobCardHdrs.Where(x => x.JobCardId == JobCardId).FirstOrDefault(); if (UpdateData != null) { TblJobCardDtl bp = new TblJobCardDtl { JobCardId = obj.JobCardId, No_Of_Panel = obj.NumberOfPanel, PanelReplaced = obj.PanelReplaced, StatusID = obj.StatusID, ContractorId = obj.Contractor_Id, NoOfGlass = obj.Glass, CreatedBy = UpdateData.CreatedBy, CreationDate = UpdateData.CreationDate, ModifiedBy = obj.ModifiedBy, ModifiedDate = DateTime.Now }; dbContext.Entry(bp).State = EntityState.Added; dbContext.SaveChanges(); UpdateHdrData.InsuranceCompanyId = obj.InsCompId; UpdateHdrData.PaymentMode = obj.PaymentMode; dbContext.Entry(UpdateHdrData).State = EntityState.Modified; dbContext.SaveChanges(); //Updating photo details UpdateStatusDAL.UpdatePhotoDtl(obj.JobCardId, PhotoUrl); return("success"); } else { return("Error"); } } }
public static void Post(string BrandName, long UserId) { using (var dbContext = new BSSDBEntities()) { var Check = dbContext.tblBrands.Where(x => x.BrandName == BrandName).FirstOrDefault(); if (Check == null) { tblBrand tb = new tblBrand { BrandName = BrandName, IsDeleted = false, CreatedBy = UserId, CreationDate = DateTime.Now }; dbContext.Entry(tb).State = System.Data.Entity.EntityState.Added; dbContext.SaveChanges(); } } }
public static DashBoardBLL GetData(SessionDataBLL Obj) { using (var dbContext = new BSSDBEntities()) { var Total = dbContext.SpTotalCount(Obj.DealerID, Obj.AccountId).FirstOrDefault(); var Delivered = dbContext.SpDeliveredCount(Obj.DealerID, Obj.AccountId).FirstOrDefault(); var Pending = dbContext.SpPendingCount(Obj.DealerID, Obj.AccountId).FirstOrDefault(); var Ready = dbContext.SpReadyCount(Obj.DealerID, Obj.AccountId).FirstOrDefault(); DashBoardBLL obj = new DashBoardBLL() { Total = Convert.ToInt64(Total), Delivered = Convert.ToInt64(Delivered), Pending = Convert.ToInt64(Pending), Ready = Convert.ToInt64(Ready) }; return(obj); } }