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 void InsertData(DataTable info, SessionDataBLL obj)
{
using (var context = new BSSDBEntities())
{
var dt1 = context.TblJobCardHdrs.ToList();
foreach (DataRow Dr in info.Rows)
{
string JobCardNo = Dr["Job Card No."].ToString().Trim();
if (JobCardNo != null && JobCardNo != string.Empty)
{
//LogService("JobCardNo: " + JobCardNo);
//LogService("************************: " + DateTime.Now.ToString());
string DateAndTime1 = Convert.ToString(Dr["Date & Time"]);
//LogService("DateAndTime1: " + DateAndTime1);
//LogService("************************: " + DateTime.Now.ToString());
DateTime DateAndTime = Convert.ToDateTime(DateAndTime1);
//LogService("DateAndTime: " + DateAndTime);
//LogService("************************: " + DateTime.Now.ToString());
//DateTime DateAndTime = Convert.ToDateTime(Dr["Date & Time"]);
string CustomerName = Convert.ToString(Dr["Customer Name"]);
long PhoneNo = Convert.ToInt64(Dr["Phone & Mobile No."]);
string CustomerCategory = Convert.ToString(Dr["Customer Catg."]);
string PSFStatus = Convert.ToString(Dr["PSF Status"]);
string RegistrationNo = Convert.ToString(Dr["Registration"]);
string Model = Convert.ToString(Dr["Model"]);
string SA = Convert.ToString(Dr["S.A"]);
string Technician = Convert.ToString(Dr["Technician"]);
string Service = Convert.ToString(Dr["Service"]);
string PromisedDate = Convert.ToString(Dr["Promised Dt."]);
//LogService("PromisedDate: " + PromisedDate);
//LogService("************************: " + DateTime.Now.ToString());
string RevPromisedDate = Convert.ToString(Dr["Rev. Promised Dt."]);// Dr["Rev. Promised Dt."].ToString();
//LogService("RevPromisedDate: " + RevPromisedDate);
//LogService("************************: " + DateTime.Now.ToString());
//DateTime RevDATE = Convert.ToDateTime(Dr["Rev. Promised Dt."]);
string ReadyDateTime = Convert.ToString(Dr["Ready Date & Time"]);
//LogService("ReadyDateTime: " + ReadyDateTime);
//LogService("************************: " + DateTime.Now.ToString());
var Check = context.TblJobCardHdrs.Where(x => x.JobCardNo == JobCardNo && x.DealerID == obj.DealerID).FirstOrDefault();
if (Check == null)
{
TblJobCardHdr dt = new TblJobCardHdr
{
JobCardNo = JobCardNo,
DateAndTime = DateAndTime,
CustomerName = CustomerName,
PhoneNo = PhoneNo,
CustomerCategory = CustomerCategory,
PSFStatus = PSFStatus,
RegistrationNo = RegistrationNo,
Model = Model,
SA = SA,
Technician = Technician,
Service = Service,
PromisedDate = PromisedDate,
RevPromisedDate = RevPromisedDate,
ReadyDateTime = ReadyDateTime,
AccountID = obj.AccountId,
DealerID = obj.DealerID,
CreatedBy = obj.UserId,
CreationDate = DateTime.Now
};
context.Entry(dt).State = EntityState.Added;
context.SaveChanges();
InsertIntoTblDtl(JobCardNo, obj);
}
else
{
continue;
}
}
}
}
}
