public SAP_Vendor.Data.SAP_VendorCreation AddVendorCreation(string initiatorId, string initiatorName)
{
try
{
SAP_VendorCreation objMain = SAP_VendorCreation.Where(d => d.InitiatorId == initiatorId && d.Status == 60).FirstOrDefault();
if (objMain != null)
{
return(objMain);
}
else
{
string requestId = Guid.NewGuid().ToString();
objMain = new SAP_VendorCreation();
objMain.RequestType = "New";
objMain.InitiatorId = initiatorId;
objMain.InitiatorName = initiatorName;
objMain.Status = 60;
objMain.IncidentNo = 0;
objMain.RequestId = requestId;
this.Entry <SAP_VendorCreation>(objMain).State = EntityState.Added;
var count = this.SaveChanges();
return(objMain);
}
}
catch (Exception ex)
{
throw ex;
}
}
public SAP_VendorCreation ClearVendorCreation(string requestId, string initiatorId, string initiatorName)
{
try
{
SAP_VendorCreation objMain = SAP_VendorCreation.Where(d => d.RequestId == requestId && d.Status == 60).FirstOrDefault();
if (objMain != null)
{
this.Entry(objMain).State = EntityState.Detached;
objMain = new SAP_VendorCreation();
objMain.RequestType = "New";
objMain.RequestId = requestId;
objMain.InitiatorId = initiatorId;
objMain.InitiatorName = initiatorName;
objMain.Status = 60;
objMain.IncidentNo = 0;
this.SAP_VendorCreation.Attach(objMain);
this.Entry(objMain).State = EntityState.Modified;
this.SAP_VendorAttachment.Where(d => d.RequestId == requestId).ToList().RemoveAll(d => d.RequestId == requestId);
this.SaveChanges();
return(objMain);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public SAP_VendorCreation GetVendorCreation(string requestId)
{
return(SAP_VendorCreation.Where(d => d.RequestId == requestId).FirstOrDefault());
}