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_VendorCreationLog GetVendorCreationLog(SAP_VendorCreation main, string activity, string taskId)
{
var log = GetVendorCreationLog(requestId: main.RequestId, activity: activity, taskId: taskId);
if (log == null)
{
log = new SAP_VendorCreationLog {
Id = 0
}
}
;
log.CreatedDate = DateTime.Now;
log.AccountNoIBAN = main.AccountNoIBAN;
log.ActiveActivity = main.ActiveActivity;
log.ActiveUserId = main.ActiveUserId;
log.ActiveUserName = main.ActiveUserName;
log.Activity = main.Activity;
log.Address = main.Address;
log.BankAddress = main.BankAddress;
log.BenificaryName = main.BenificaryName;
log.BusinessName = main.BusinessName;
log.City = main.City;
log.Classification = main.Classification;
log.CompanyType = main.CompanyType;
log.ContactPerson = main.ContactPerson;
log.Country = main.Country;
log.CreatedDate = main.CreatedDate;
log.Email = main.Email;
log.EmailSent = main.EmailSent;
log.EmailSentDate = main.EmailSentDate;
log.FaxNo = main.FaxNo;
log.IncidentNo = main.IncidentNo;
log.InitiatedDate = main.InitiatedDate;
log.InitiatorId = main.InitiatorId;
log.InitiatorName = main.InitiatorName;
log.IssuedBy = main.IssuedBy;
log.IssuedOn = main.IssuedOn;
log.NatureOfWork = main.NatureOfWork;
log.NTNNo = main.NTNNo;
log.PaymentCurrency = main.PaymentCurrency;
log.PaymentMethod = main.PaymentMethod;
log.PaymentTerms = main.PaymentTerms;
log.PeriodUpto = main.PeriodUpto;
log.PhoneNo = main.PhoneNo;
log.PostalCode = main.PostalCode;
log.Qualification = main.Qualification;
log.QuestionnaireCompleted = main.QuestionnaireCompleted;
log.RegNA = main.RegNA;
log.RequestId = main.RequestId;
log.RequestType = main.RequestType;
log.Reason = main.Reason;
log.ReturnEmails = main.ReturnEmails;
log.RoutingNo = main.RoutingNo;
log.SAPVendorId = main.SAPVendorId;
log.State = main.State;
log.Status = main.Status;
log.SwiftCode = main.SwiftCode;
log.TaskId = main.TaskId;
log.TaxRegNo = main.TaxRegNo;
log.ToEmails = main.ToEmails;
log.UpdatedDate = main.UpdatedDate;
log.UserId = main.UserId;
log.UserName = main.UserName;
log.WithholdingTax = main.WithholdingTax;
log.Remarks = main.Remarks;
return(log);
}
#endregion
}
public SAP_VendorCreation GetVendorCreation(string requestId)
{
return(SAP_VendorCreation.Where(d => d.RequestId == requestId).FirstOrDefault());
}
