private void InsertOrUpdateCompanyServices(int certId, EcomCert_Service companyService)
{
// Company Services
EcomCert_Service certCompanyServices = _db.EcomCert_Service
.Find(certId);
using (MSDBContext db = new MSDBContext())
{
// Add new record
if (certCompanyServices == null)
{
certCompanyServices = new EcomCert_Service();
certCompanyServices = companyService;
certCompanyServices.CertID = certId;
certCompanyServices.CreatedDate = DateTime.Now;
db.EcomCert_Service.Add(certCompanyServices);
}
// Update existing
else
{
certCompanyServices = companyService;
certCompanyServices.CertID = certId;
certCompanyServices.ModifiedDate = DateTime.Now;
db.EcomCert_Service.Attach(certCompanyServices);
db.Entry(certCompanyServices).State = EntityState.Modified;
}
db.SaveChanges();
}
}
private void InsertOrUpdateCompanyDetail(int certId, EcomCert_CompDetail companyDetail)
{
// Company Details
EcomCert_CompDetail certCompanyDetail = _db.EcomCert_CompDetail
.Find(certId);
// save modified entity using new Context
using (MSDBContext db = new MSDBContext())
{
if (certCompanyDetail == null)
{
certCompanyDetail = companyDetail;
certCompanyDetail.CertID = certId;
certCompanyDetail.CreateDate = DateTime.Now;
db.EcomCert_CompDetail.Add(certCompanyDetail);
}
else
{
certCompanyDetail = companyDetail;
certCompanyDetail.CertID = certId;
certCompanyDetail.ModifiedDate = DateTime.Now;
db.EcomCert_CompDetail.Attach(certCompanyDetail);
db.Entry(certCompanyDetail).State = EntityState.Modified;
}
// SaveChanges
db.SaveChanges();
}
}
private void InsertOrUpdateCertifidMemberApplicationStatus(int certId, string status)
{
// EcomCert_Status
EcomCert_Status certStatus = _db.EcomCert_Status
.AsNoTracking()
.FirstOrDefault(x => x.CertID == certId);
using (MSDBContext db = new MSDBContext())
{
if (certStatus == null)
{
certStatus = new EcomCert_Status();
certStatus.CertID = certId;
certStatus.StatusID = status == "save" ? 1 : 2;
db.EcomCert_Status.Add(certStatus);
}
else
{
certStatus.StatusID = status == "save" ? 1 : 2;
db.EcomCert_Status.Attach(certStatus);
db.Entry(certStatus).State = EntityState.Modified;
}
db.SaveChanges();
}
}
private void InsertOrUpdateCompanyIT(int certId, EcomCert_IT companyIT)
{
if (companyIT == null)
{
return;
}
EcomCert_IT ecomCompanyIT = _db.EcomCert_IT
.AsNoTracking()
.FirstOrDefault(x => x.CertID == certId);
using (MSDBContext db = new MSDBContext())
{
if (ecomCompanyIT == null)
{
ecomCompanyIT = companyIT;
ecomCompanyIT.CertID = certId;
ecomCompanyIT.CreatedDate = DateTime.Now;
db.EcomCert_IT.Add(companyIT);
}
else
{
ecomCompanyIT = companyIT;
ecomCompanyIT.CertID = certId;
ecomCompanyIT.ModifiedDate = DateTime.Now;
db.EcomCert_IT.Attach(ecomCompanyIT);
db.Entry(ecomCompanyIT).State = EntityState.Modified;
}
db.SaveChanges();
}
}
public UserRepository(MSDBContext mSDBContext) : base(mSDBContext)
{
this._dbContext = mSDBContext;
}
public UserController(MSDBContext context, ITracer tracer)
{
_context = context;
_tracer = tracer;
}
public RepasitoryBase(MSDBContext dbContext)
{
_dbContext = dbContext;
}
public CompanyRepository(MSDBContext mSDBContext)
{
this._dbContext = mSDBContext;
}
