public JsonResult InsertAndUpdate(DivisionVM divisionsVM, int id) { try { var json = JsonConvert.SerializeObject(divisionsVM); var buffer = System.Text.Encoding.UTF8.GetBytes(json); var byteContent = new ByteArrayContent(buffer); byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json"); if (divisionsVM.id == 0) { var result = client.PostAsync("divisions", byteContent).Result; return(Json(result)); } else if (divisionsVM.id == id) { var result = client.PutAsync("divisions/" + id, byteContent).Result; return(Json(result)); } return(Json(404)); } catch (Exception ex) { throw ex; } }
// // GET: /SysAdmin/Division/Create public ActionResult Create() { DivisionVM viewModel = new DivisionVM(); viewModel.Status = true; return(View(viewModel)); }
//Export //Export public ActionResult ExportToPDF(DivisionVM division) { DivisionReport divreport = new DivisionReport(); byte[] abytes = divreport.PrepareReport(GetDivision()); return(File(abytes, "application/pdf")); }
public ActionResult Create(DivisionVM viewModel) { try { // TODO: Add insert logic here if (ModelState.IsValid) { Entities.Division entity = new Entities.Division(); entity.DivisionId = viewModel.DivisionId; entity.DivisionName = viewModel.DivisionName; entity.Status = viewModel.Status; entity.Remark = viewModel.Remark; DivisionBAL balObject = new DivisionBAL(); balObject.Add(entity); return(RedirectToAction("Index")); } else { // AcademicYearBAL academicYearBAL = new AcademicYearBAL(); // viewModel.AcademicYears = from obj in academicYearBAL.GetAll() where obj.Status == true select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() }; return(View(viewModel)); } } catch { //AcademicYearBAL academicYearBAL = new AcademicYearBAL(); //viewModel.AcademicYears = from obj in academicYearBAL.GetAll() where obj.Status == true select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() }; return(View(viewModel)); } }
public void CreateTest() { DivisionVM vm = _controller.Wtm.CreateVM <DivisionVM>(); Division v = new Division(); v.ID = 86; v.Code = "yOher"; v.ParentCode = "dIt"; v.RuralCode = "Sz3"; v.Name = "s8W"; vm.Entity = v; var rv = _controller.Add(vm); Assert.IsInstanceOfType(rv, typeof(OkObjectResult)); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { var data = context.Set <Division>().Find(v.ID); Assert.AreEqual(data.ID, 86); Assert.AreEqual(data.Code, "yOher"); Assert.AreEqual(data.ParentCode, "dIt"); Assert.AreEqual(data.RuralCode, "Sz3"); Assert.AreEqual(data.Name, "s8W"); Assert.AreEqual(data.CreateBy, "user"); Assert.IsTrue(DateTime.Now.Subtract(data.CreateTime.Value).Seconds < 10); } }
public ActionResult Edit(DivisionVM viewModel) { try { // TODO: Add update logic here if (ModelState.IsValid) { Entities.Division entity = new Entities.Division(); entity.DivisionId = viewModel.DivisionId; entity.DivisionName = viewModel.DivisionName; entity.Status = viewModel.Status; entity.Remark = viewModel.Remark; DivisionBAL balObject = new DivisionBAL(); balObject.Edit(entity); return(RedirectToAction("Index")); } else { return(View(viewModel)); } } catch { return(View()); } }
public JsonResult InsertOrUpdate(DivisionVM divisionVM) { if (divisionVM.Id == 0) { var myContent = JsonConvert.SerializeObject(divisionVM); var buffer = System.Text.Encoding.UTF8.GetBytes(myContent); var byteContent = new ByteArrayContent(buffer); byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json"); var result = client.PostAsync("Divisions", byteContent).Result; return(new JsonResult { Data = result, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } else { var myContent = JsonConvert.SerializeObject(divisionVM); var buffer = System.Text.Encoding.UTF8.GetBytes(myContent); var byteContent = new ByteArrayContent(buffer); byteContent.Headers.ContentType = new MediaTypeHeaderValue("application/json"); var result = client.PutAsync("Divisions/" + divisionVM.Id, byteContent).Result; return(new JsonResult { Data = result, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
public ActionResult Select() { string mode = Request.QueryString["Grid-mode"]; if (!string.IsNullOrEmpty(mode)) { return(this.RedirectToAction("Create")); } else { List <DivisionVM> viewModels = new List <DivisionVM>(); DivisionBAL balObject = new DivisionBAL(); IQueryable <Entities.Division> entites = balObject.GetAll(); foreach (Entities.Division entity in entites) { DivisionVM viewModel = new DivisionVM(); viewModel.DivisionId = entity.DivisionId; viewModel.DivisionName = entity.DivisionName; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; viewModels.Add(viewModel); } return(this.View("Index", new GridModel <DivisionVM> { Data = viewModels })); } }
public bool Insert(DivisionVM divisionVM) { var push = new Division(divisionVM); applicationContext.Divisions.Add(push); var result = applicationContext.SaveChanges(); return(result > 0); }
public IHttpActionResult Delete(DivisionVM division, int id) { var del = myContext.Division.Find(id); myContext.Division.Remove(del); myContext.SaveChanges(); return(Ok(del)); }
public IHttpActionResult Update(int id, DivisionVM divisionVM) { if ((divisionVM.Name != null) && (divisionVM.Name != "")) { var data = _repository.Update(id, divisionVM); return(Ok($"Data {divisionVM.Name} berhasil diupdate")); } return(BadRequest("Department Name can't be NULL")); }
public IHttpActionResult Post(DivisionVM divisionVM) { if ((divisionVM.Name != null) && (divisionVM.Name != "")) { _repository.Create(divisionVM); return(Ok($"Data {divisionVM.Name} Berhasil Dimasukkan ke Database Department")); } return(BadRequest("Department Name can't be NULL")); }
// GET: Divisions public IHttpActionResult Post(DivisionVM divisionVM) { if ((divisionVM.Name != null) && (divisionVM.Name != "")) { _repository.Create(divisionVM); return(Ok("Data Berhasil Diinput")); } return(BadRequest("Department Name Can't be null")); }
public IActionResult Post(DivisionVM divisionVM) { var post = _divisionRepository.Create(divisionVM); if (post > 0) { return(Ok(post)); } return(BadRequest("Can't be created")); }
public bool Update(int id, DivisionVM divisionVM) { var get = Get(id); get.Update(divisionVM); applicationContext.Entry(get).State = EntityState.Modified; var result = applicationContext.SaveChanges(); return(result > 0); }
public IHttpActionResult Put(DivisionVM division, int id) { var put = myContext.Division.Find(id); put.name = division.name; myContext.Entry(put).State = EntityState.Modified; myContext.SaveChanges(); return(StatusCode(HttpStatusCode.NoContent)); }
public int Create(DivisionVM divisionVM) { var sp = "SP_InsertDivision"; parameters.Add("@Name", divisionVM.Name); parameters.Add("@Dept_id", divisionVM.Dept_id); var create = connection.Execute(sp, parameters, commandType: CommandType.StoredProcedure); return(create); }
public IActionResult EditDivision(int id, DivisionVM divisionVM) { var edit = _divisionRepository.Update(divisionVM, id); if (edit > 0) { return(Ok(edit)); } return(BadRequest("Not Successfully")); }
public IActionResult Put(int Id, DivisionVM divisionVM) { var put = _divisionRepository.Update(Id, divisionVM); if (put > 0) { return(Ok(put)); } return(BadRequest("Can't be updated")); }
public IActionResult CreateDivision(DivisionVM divisionVM, int id) { var create = _divisionRepository.Create(divisionVM, id); if (create > 0) { return(Ok(create)); } return(BadRequest("Not Successfully")); }
public HttpResponseMessage InsertDivision(DivisionVM divisionVM) { var message = Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Wrong Parameter"); var result = _iDivisionService.Insert(divisionVM); if (result) { message = Request.CreateResponse(HttpStatusCode.OK, "Successfully Added"); } return(message); }
public int Create(DivisionVM divisionVM, int id) { using (SqlConnection connection = new SqlConnection(_configuration.GetConnectionString("myConn"))) { var procName = "SPInsertDivision"; parameters.Add("Name", divisionVM.Name); parameters.Add("departmentId", divisionVM.departmentId); var insertDepartment = connection.Execute(procName, parameters, commandType: CommandType.StoredProcedure); return(insertDepartment); } }
public IHttpActionResult Update(int id, DivisionVM divisionVM) { //_repository.Update(id, department); //return Ok("Data Department Berhasil di Updated"); if ((divisionVM.Name != null) && (divisionVM.Name != "")) { _repository.Update(id, divisionVM); return(Ok("Data Department Berhasil di Updated")); } return(BadRequest("Department Name Can't be null")); }
public int Update(int id, DivisionVM divisionVM) { var sp = "SP_UpdateDivision"; parameters.Add("@Id", id); parameters.Add("@Name", divisionVM.Name); parameters.Add("@Dept_id", divisionVM.Dept_id); var update = connection.Execute(sp, parameters, commandType: CommandType.StoredProcedure); return(update); }
public int Update(int Id, DivisionVM divisionVM) { using (SqlConnection connection = new SqlConnection(_configuration.GetConnectionString("MyConnection"))) { var procName = "SPUpdateDivision"; parameters.Add("Id", Id); parameters.Add("Name", divisionVM.Name); parameters.Add("DeptId", divisionVM.DeptId); var Insert = connection.Execute(procName, parameters, commandType: CommandType.StoredProcedure); return(Insert); } }
public bool Update(int id, DivisionVM divisionVM) { if (string.IsNullOrWhiteSpace(id.ToString()) || string.IsNullOrWhiteSpace(divisionVM.Name)) { return(status); } else { var result = _divisionRepository.Update(id, divisionVM); return(result); } }
public int Update(int id, DivisionVM divisionVM) { var sp = "SP_Update_Division"; parameters.Add("@Id", id); parameters.Add("@Name", divisionVM.Name); parameters.Add("@Dept_Id", divisionVM.Dept_Id); var update = connection.Execute(sp, parameters, commandType: CommandType.StoredProcedure); //throw new NotImplementedException(); return(update); }
public bool Insert(DivisionVM divisionVM) { if (string.IsNullOrWhiteSpace(divisionVM.Name)) { return(status); } else { var result = _divisionRepository.Insert(divisionVM); return(result); } }
public void EditTest() { Division v = new Division(); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { v.ID = 86; v.Code = "yOher"; v.ParentCode = "dIt"; v.RuralCode = "Sz3"; v.Name = "s8W"; context.Set <Division>().Add(v); context.SaveChanges(); } DivisionVM vm = _controller.Wtm.CreateVM <DivisionVM>(); var oldID = v.ID; v = new Division(); v.ID = oldID; v.Code = "OOo90B"; v.ParentCode = "KC5NKKyBW"; v.RuralCode = "uCZ"; v.Name = "Np4"; vm.Entity = v; vm.FC = new Dictionary <string, object>(); vm.FC.Add("Entity.ID", ""); vm.FC.Add("Entity.Code", ""); vm.FC.Add("Entity.ParentCode", ""); vm.FC.Add("Entity.RuralCode", ""); vm.FC.Add("Entity.Name", ""); var rv = _controller.Edit(vm); Assert.IsInstanceOfType(rv, typeof(OkObjectResult)); using (var context = new DataContext(_seed, DBTypeEnum.Memory)) { var data = context.Set <Division>().Find(v.ID); Assert.AreEqual(data.Code, "OOo90B"); Assert.AreEqual(data.ParentCode, "KC5NKKyBW"); Assert.AreEqual(data.RuralCode, "uCZ"); Assert.AreEqual(data.Name, "Np4"); Assert.AreEqual(data.UpdateBy, "user"); Assert.IsTrue(DateTime.Now.Subtract(data.UpdateTime.Value).Seconds < 10); } }
public JsonResult LoadId(int id) { DivisionVM divisions = null; var readTask = client.GetAsync("Divisions/" + id); readTask.Wait(); var result = readTask.Result; if (result.IsSuccessStatusCode) { var output = result.Content.ReadAsStringAsync().Result; divisions = JsonConvert.DeserializeObject <DivisionVM>(output); } return(Json(divisions, JsonRequestBehavior.AllowGet)); }