public void saveVehicle(DataTruck dbitem) { code_mstr model = new code_mstr(); model.code_oid = Guid.NewGuid().ToString(); model.code_code = dbitem.NoTruck; // { get; set; } model.code_name = dbitem.VehicleNo; // { get; set; } model.code_dom_id = 1; //{ get; set; }// smallint, -- DomainId model.code_en_id = 1; //{ get; set; }// integer, -- EntityId model.code_add_date = DateTime.Now; // { get; set; }// timestamp without time zone, -- CreatedDate model.code_upd_date = DateTime.Now; // { get; set; }// timestamp without time zone, -- LastModified model.code_id = 900000 + dbitem.Id; //{ get; set; }// integer, -- Id model.code_seq = 900000 + dbitem.Id; // { get; set; }// integer, -- Sequence model.code_field = "vehicle"; //{ get; set; }// character varying45), -- Field model.code_desc = dbitem.Keterangan; // { get; set; }// character varying255), -- Description model.code_active = "Y"; // { get; set; }// character1) DEFAULT 'N'::bpchar, -- IsActive model.code_dt = DateTime.Now; //{ get; set; }// timestamp without time zone, -- RowVersion context.code_mstr.Add(model); context.SaveChanges(); }
public ActionResult Add(DataTruck model) { if (ModelState.IsValid) { if (RepoDataTruck.IsExist(model.VehicleNo)) { ModelState.AddModelError("VehicleNo", "Vehicle No sudah terdaftar."); return(View("Form", model)); } Context.DataTruck dbitem = new Context.DataTruck(); model.SetDb(dbitem); //generate code dbitem.urutan = RepoDataTruck.getUrutan() + 1; dbitem.NoTruck = RepoDataTruck.generateCode(dbitem.urutan); RepoDataTruck.save(dbitem, UserPrincipal.id); return(RedirectToAction("Index")); } return(View("Form", model)); }
public string GetAlert(int id) { DataTruck model = new DataTruck(RepoDataTruck.FindByPK(id)); List <DataTruckAlert> alert = new List <DataTruckAlert>(); if (model.STNK.HasValue) { if (model.STNK <= DateTime.Now) { alert.Add(new DataTruckAlert() { Keterangan = "STNK Expired", Value = model.STNK.Value.ToShortDateString() }); } } if (model.KIR.HasValue) { if (model.KIR <= DateTime.Now) { alert.Add(new DataTruckAlert() { Keterangan = "KIR Expired", Value = model.KIR.Value.ToShortDateString() }); } } if (model.KIU.HasValue) { if (model.KIU <= DateTime.Now) { alert.Add(new DataTruckAlert() { Keterangan = "KIU Expired", Value = model.KIU.Value.ToShortDateString() }); } } if (model.IBM.HasValue) { if (model.IBM <= DateTime.Now) { alert.Add(new DataTruckAlert() { Keterangan = "IBM Expired", Value = model.IBM.Value.ToShortDateString() }); } } if (model.Asuransi.HasValue) { if (model.Asuransi <= DateTime.Now) { alert.Add(new DataTruckAlert() { Keterangan = "Asuransi Expired", Value = model.Asuransi.Value.ToShortDateString() }); } } if (model.Reklame.HasValue) { if (model.Reklame <= DateTime.Now) { alert.Add(new DataTruckAlert() { Keterangan = "Reklame Expired", Value = model.Reklame.Value.ToShortDateString() }); } } return(new JavaScriptSerializer().Serialize(alert)); }
public ActionResult Add() { DataTruck model = new DataTruck(); return(View("Form", model)); }