public Models.ac_mstr FindByPk(int?id)
{
Models.ac_mstr model = new Models.ac_mstr();
if (id.HasValue)
{
var data = context.ac_mstr.Where(d => d.ac_id == id).FirstOrDefault();
if (data != null)
{
model.id = data.ac_id;
model.ac_code = data.ac_code;
model.ac_name = data.ac_name;
}
}
return(model);
}
public void save(int seq, Context.glt_det model, Context.SalesOrder soitem, string code, decimal?nominalDb, decimal?nominalCr, Models.ac_mstr ac_mstr)
{
model.glt_oid = Guid.NewGuid().ToString();
model.glt_dom_id = 1;
model.glt_en_id = 1;
model.glt_add_by = "";
model.glt_add_date = DateTime.Now;
model.glt_upd_by = "";
model.glt_upd_date = DateTime.Now;
model.glt_code = code;
model.glt_date = DateTime.Now; //soitem.SalesOrderOncallId.HasValue ? soitem.SalesOrderOncall.TanggalMuat : soitem.SalesOrderProsesKonsolidasiId.HasValue ? soitem.SalesOrderProsesKonsolidasi.TanggalMuat : soitem.SalesOrderPickupId.HasValue ? soitem.SalesOrderPickup.TanggalPickup : DateTime.Now;
model.glt_type = "SO"; //?
model.glt_cu_id = 1;
model.glt_exc_rate = 1;
model.glt_seq = seq;
model.glt_ac_id = ac_mstr.id;
model.glt_cc_id = 0;
model.glt_sb_id = 1;
model.glt_desc = ac_mstr.ac_name;
model.glt_debit = nominalDb;
model.glt_credit = nominalCr;
model.glt_posted = "N";
model.glt_dt = DateTime.Now;
model.glt_branch_id = 10001;
model.glt_driver_id = soitem.SalesOrderOncallId.HasValue ? (soitem.SalesOrderOncall.Driver1Id.HasValue ? soitem.SalesOrderOncall.Driver1Id.Value + 7000000 : 0) : soitem.SalesOrderProsesKonsolidasiId.HasValue ? (soitem.SalesOrderProsesKonsolidasi.Driver1Id.HasValue ? soitem.SalesOrderProsesKonsolidasi.Driver1Id.Value + 7000000 : 0) : soitem.SalesOrderPickupId.HasValue ? (soitem.SalesOrderPickup.Driver1Id.HasValue ? soitem.SalesOrderPickup.Driver1Id.Value + 7000000 : 0) : 0;
model.glt_no_pol = soitem.SalesOrderOncallId.HasValue ? (soitem.SalesOrderOncall.DataTruck == null ? null : soitem.SalesOrderOncall.DataTruck.VehicleNo) : soitem.SalesOrderProsesKonsolidasiId.HasValue ? (soitem.SalesOrderProsesKonsolidasi.DataTruck == null ? null : soitem.SalesOrderProsesKonsolidasi.DataTruck.VehicleNo) : soitem.SalesOrderPickupId.HasValue ? (soitem.SalesOrderPickup.DataTruck == null ? null : soitem.SalesOrderPickup.DataTruck.VehicleNo) : null;
context.glt_det.Add(model);
context.SaveChanges();
}
public void saveFromAc(int seq, string code, decimal?nominalDb, decimal?nominalCr, Models.ac_mstr ac_mstr, string desc = null)
{
Context.glt_det model = new Context.glt_det();
model.glt_oid = Guid.NewGuid().ToString();
model.glt_dom_id = 1;
model.glt_en_id = 1;
model.glt_add_by = "";
model.glt_add_date = DateTime.Now;
model.glt_upd_by = "";
model.glt_upd_date = DateTime.Now;
model.glt_code = code;
model.glt_date = DateTime.Now;
model.glt_type = "SO"; //?
model.glt_cu_id = 1;
model.glt_exc_rate = 1;
model.glt_seq = seq;
model.glt_ac_id = ac_mstr.id;
model.glt_cc_id = 0;
model.glt_sb_id = 1;
model.glt_desc = desc == null ? ac_mstr.ac_name : desc;
model.glt_debit = nominalDb;
model.glt_credit = nominalCr;
model.glt_posted = "N";
model.glt_dt = DateTime.Now;
model.glt_branch_id = 10001;
try{
model.glt_daybook = "TMS-" + code.Split('-')[0] + "-" + code.Split('-')[1];//TMS-<TIGAKODEJURNAL><TYPE SO>;
}
catch (Exception e)
{
}
context.glt_det.Add(model);
context.SaveChanges();
}
