public async Task<ActionResult> Add(VF_API_CLIENT_OBJECTS model) { try { model.DB_OBJECT_MODIFIED_DATE = DateTime.Now; model.DB_OBJECT_CREATED_DATE = DateTime.Now; await _clientObjectProvider.Save(model); var client = _catalogClientProvider.GetAll().Where(x => x.TRANSDEV_ID == model.TRANSDEV_ID).First(); SuccessMessage = "New Endpoint is Added"; return RedirectToAction("Edit", "Clients", new { id = client.CLIENT_ID }); } catch(Exception ex) { ExceptionDetails = ex; ErrorMessage = "Unexpected error occured while creating an endpoint"; } List<SelectListItem> items = GetProviders(); ViewBag.Providviders = new SelectList(items, "Value", "Text"); return View(model); }
public ActionResult Add(Guid id) { List<SelectListItem> items = GetProviders(); ViewBag.Providviders= new SelectList(items, "Value", "Text"); var model = new VF_API_CLIENT_OBJECTS(); model.TRANSDEV_ID = _catalogClientProvider.GetAll().Where(e => e.CLIENT_ID == id).FirstOrDefault().TRANSDEV_ID; return View(model); }
public async Task<int> Save(VF_API_CLIENT_OBJECTS clientObject) { using (var context = new Entities()) { if (clientObject.CLIENT_OBJECT_ID == System.Guid.Empty) { clientObject.CLIENT_OBJECT_ID = System.Guid.NewGuid(); context.Entry(clientObject).State = EntityState.Added; } else { context.Entry(clientObject).State = EntityState.Modified; } return await context.SaveChangesAsync(); } }
/// <summary> /// Execute DataProvide /// </summary> /// <param name="clients">VF_API_CLIENT_OBJECTS</param> /// <returns>QueryResult of DataTable</returns> public async Task<QueryResult<DataTable>> Execute(VF_API_CLIENT_OBJECTS client) { using (var context = new Entities()) { var adaptor = new SqlServerTableAdaptor(); var parameters = new SqlServerTableParameters(); parameters.UserID = client.DB_USER; parameters.Password = client.DB_USER_PASSWORD; parameters.DataSource = client.DB_SERVER_NAME; parameters.InitialCatalog = client.DB_NAME; parameters.IntegratedSecurity = client.DB_INTEGRATED_SECURITY; parameters.ObjectName = client.DB_OBJECT_NAME; parameters.SchemaName = client.DB_SCHEMA; return adaptor.Execute(parameters); } }