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