public ActionResult Create(LenderModel model, string[] users)
{
try
{
if (!ModelState.IsValid)
{
throw new Exception();
}
// Step 1: Create Lender
var lenderModelToInsert = DataRepository.GetLender(DataRepository.InsertLender(model));
// Step 2: Update Lender-User assignments
DataRepository.UpdateAssignments((int)lenderModelToInsert.id, users);
// Step 3: Return to list of Lenders
return RedirectToAction("Index");
}
catch
{
ViewBag.active_menu_item_id = "menu-btn-lenders";
var dbUsers = DataRepository.GetUsers();
ViewBag.Users = dbUsers;
ViewBag.SelectedUsers = users;
return View(model);
}
}
public async Task <string> UpdateLender(LenderModel lender)
{
//Lender existinglender = LenderRepository.GetLenders().SingleOrDefault(p => p.LenderId == lender.LenderId);
//if (existinglender == default(Lender))
// return "lender doesn't exist";
int updatelenderMaster = 0;
LenderMaster lendermaster = LenderMasterRepository.MasterLenders.FirstOrDefault(c => c.LenderMasterId == lender.LenderId);
if (lendermaster == default(LenderMaster))
{
return("Lender doesn't exist");
}
else
{
lendermaster.LenderName = lender.LenderName;
lendermaster.LenderAddress = lender.LenderAddress;
lendermaster.UpdatedDate = lender.UpdatedDate;
lendermaster.UpdatedBy = lender.UpdatedBy;
}
updatelenderMaster = await LenderMasterRepository.UpdateLenderMaster(lendermaster);
return(updatelenderMaster > 0 ? "Successfully updated Master Lender" : "Updation failed");
}
public IHttpActionResult UpdateLender(LenderModel lender)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
Task.Run(async() => await _lender.UpdateLender(lender));
return(Ok("Record Updated"));
}
public async Task <string> AddLender(LenderModel lender)
{
//Lender existinglender = LenderRepository.GetLenders().SingleOrDefault(p => p.LenderId == lender.LenderId);
//if (existinglender == default(Lender))
// return "lender doesn't exist";
int insertlenderMaster = 0;
int insertlender = 0;
if (lender.LenderId == 0)
{
insertlenderMaster = await LenderMasterRepository.AddLenderMaster(new LenderMaster { LenderName = lender.LenderName, LenderAddress = lender.LenderAddress, CreatedDate = lender.CreatedDate, CreatedBy = lender.CreatedBy, UpdatedDate = lender.UpdatedDate, UpdatedBy = lender.UpdatedBy });
}
else
{
insertlender = await LenderRepository.AddLender(new Lender { ClientId = lender.ClientId = lender.ClientId, ProjectId = lender.ProjectId, LenderMasterId = lender.LenderId, CreatedDate = lender.CreatedDate, CreatedBy = lender.CreatedBy, UpdatedDate = lender.UpdatedDate, UpdatedBy = lender.UpdatedBy });
}
return((insertlenderMaster > 0 || insertlender > 0) ? "Successfully added Lender" : "Insertion failed");
}
/// <summary>
/// Updates a Lender
/// </summary>
/// <param name="model"></param>
public static void UpdateLender(LenderModel model)
{
var db = new BicikliDataClassesDataContext();
var lenderToUpdate = db.Lenders.First(l => l.id == model.id);
lenderToUpdate.address = model.address;
lenderToUpdate.description = model.description;
lenderToUpdate.latitude = model.latitude;
lenderToUpdate.longitude = model.longitude;
lenderToUpdate.name = model.name;
lenderToUpdate.printer_ip = model.printer_ip;
if ((model.printer_password != null) && (model.printer_password != ""))
{
lenderToUpdate.printer_password = model.printer_password;
}
else
{
lenderToUpdate.printer_password = ((int)(new Random().NextDouble() * 899999) + 100000).ToString();
}
db.SubmitChanges();
}
/// <summary>
/// Inserts a Lender, then returns the generated primary key
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int InsertLender(LenderModel model)
{
var db = new BicikliDataClassesDataContext();
var lenderToInsert = new Lender();
lenderToInsert.name = model.name;
lenderToInsert.address = model.address;
lenderToInsert.description = model.description;
lenderToInsert.printer_ip = model.printer_ip;
lenderToInsert.latitude = model.latitude;
lenderToInsert.longitude = model.longitude;
if ((model.printer_password != null) && (model.printer_password != ""))
{
lenderToInsert.printer_password = model.printer_password;
}
else
{
lenderToInsert.printer_password = ((int)(new Random().NextDouble() * 899999) + 100000).ToString();
}
db.Lenders.InsertOnSubmit(lenderToInsert);
db.SubmitChanges();
return lenderToInsert.id;
}
public ActionResult Delete(LenderModel model)
{
try
{
DataRepository.DeleteLender((int)model.id);
return RedirectToAction("Index");
}
catch
{
return RedirectToAction("Index");
}
}
public ActionResult Edit(LenderModel model, string[] users)
{
if (!AppUtilities.IsSiteAdmin())
{
try
{
DataRepository.GetLendersOfUser((Guid)Membership.GetUser().ProviderUserKey).Single(l => l.id == model.id);
}
catch
{
return new HttpStatusCodeResult(HttpStatusCode.Forbidden);
}
}
try
{
if (!ModelState.IsValid)
{
throw new Exception();
}
DataRepository.UpdateLender(model);
if (AppUtilities.IsSiteAdmin())
{
DataRepository.UpdateAssignments((int)model.id, users);
}
return RedirectToAction("Index");
}
catch
{
ViewBag.active_menu_item_id = "menu-btn-lenders";
var dbUsers = DataRepository.GetUsers();
ViewBag.Users = dbUsers;
ViewBag.SelectedUsers = users;
return View(model);
}
}
