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