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);
}
}
