public ActionResult Edit(ProcurementMethodOrganizationSettings procurementMethodOrganizationSettings, bool EnableProcurementMethod)
{
string email = Request.Headers["Email"];
var tenantId = catalog.GetTenantIDFromClientURL(email);
try
{
if (tenantId == null)
{
return(Json(new
{
success = false,
message = "TenantId is null",
data = new { }
}, JsonRequestBehavior.AllowGet));
}
DateTime dt = DateTime.Now;
var currentProcurementMethodID = db.ProcurementMethodOrganizationSettings.FirstOrDefault(p => p.ProcurementMethodID == procurementMethodOrganizationSettings.ProcurementMethodID);
if (currentProcurementMethodID == null)
{
LogHelper.Log(Log.Event.UPDATE_PROCUREMENTMETHOD, "ProcurementMethodID not found");
return(Json(new
{
success = false,
message = "ProcurementMethodID not found",
data = new { }
}, JsonRequestBehavior.AllowGet));
}
currentProcurementMethodID.EnableProcurementMethod = EnableProcurementMethod;
currentProcurementMethodID.DateModified = dt;
db.SaveChanges();
}
catch (Exception ex)
{
LogHelper.Log(Log.Event.UPDATE_PROCUREMENTMETHOD, ex.Message);
ExceptionError(ex.Message, ex.StackTrace);
}
return(Json(new
{
success = true,
message = "Editted successfully!!!",
data = db.ProcurementMethodOrganizationSettings.Where(x => x.TenantID == tenantId).Select(x => new
{
x.ProcurementMethodID,
x.ProcurementMethod.Name,
x.EnableProcurementMethod,
})
}, JsonRequestBehavior.AllowGet));
}
public void SaveDefaultProcurementMethodRecord(Guid TenantID, Guid OrganizationID)
{
DateTime dt = DateTime.Now;
var CurrentProcurementMethod = db.ProcurementMethodOrganizationSettings.Where(s => s.ProcurementMethodID == s.ProcurementMethodID);
var ProcurementMethod = db.ProcurementMethod.ToList();
foreach (ProcurementMethod source in ProcurementMethod)
{
db.ProcurementMethodOrganizationSettings.Add(new ProcurementMethodOrganizationSettings()
{
ProcurementMethodID = source.ProcurementMethodID,
OrganizationID = OrganizationID,
TenantID = TenantID,
EnableProcurementMethod = false,
DateCreated = dt
});
db.SaveChanges();
}
var DefaultProcurementMethod1 = "Selective Tendering";
var DefaultProcurementMethodID1 = db.ProcurementMethod.Where(x => x.Name.Contains(DefaultProcurementMethod1)).Select(x => x.ProcurementMethodID).FirstOrDefault();
var ProcurementMethod1 = db.ProcurementMethodOrganizationSettings.Where(x => x.ProcurementMethodID == DefaultProcurementMethodID1 && x.OrganizationID == OrganizationID && x.TenantID == TenantID).ToList();
ProcurementMethodOrganizationSettings procurementMethodOrganizationSettings = ProcurementMethod1.First();
procurementMethodOrganizationSettings.EnableProcurementMethod = true;
procurementMethodOrganizationSettings.DateModified = dt;
var DefaultProcurementMethod2 = "Direct procurement";
var DefaultProcurementMethodID2 = db.ProcurementMethod.Where(x => x.Name.Contains(DefaultProcurementMethod2)).Select(x => x.ProcurementMethodID).FirstOrDefault();
var ProcurementMethod2 = db.ProcurementMethodOrganizationSettings.Where(x => x.ProcurementMethodID == DefaultProcurementMethodID2 && x.OrganizationID == OrganizationID && x.TenantID == TenantID).ToList();
procurementMethodOrganizationSettings = ProcurementMethod2.First();
procurementMethodOrganizationSettings.EnableProcurementMethod = true;
procurementMethodOrganizationSettings.DateModified = dt;
var DefaultProcurementMethod3 = "Open Competitive method";
var DefaultProcurementMethodID3 = db.ProcurementMethod.Where(x => x.Name.Contains(DefaultProcurementMethod3)).Select(x => x.ProcurementMethodID).FirstOrDefault();
var ProcurementMethod3 = db.ProcurementMethodOrganizationSettings.Where(x => x.ProcurementMethodID == DefaultProcurementMethodID3 && x.OrganizationID == OrganizationID && x.TenantID == TenantID).ToList();
procurementMethodOrganizationSettings = ProcurementMethod3.First();
procurementMethodOrganizationSettings.EnableProcurementMethod = true;
procurementMethodOrganizationSettings.DateModified = dt;
db.SaveChanges();
}
