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));
}
