public void saveFromBk(int seq, string code, decimal?nominalDb, decimal?nominalCr, Models.bk_mstr bk_mstr) { 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; //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 = bk_mstr.id; model.glt_cc_id = 0; model.glt_sb_id = 1; model.glt_desc = bk_mstr.bk_name; model.glt_debit = nominalDb; model.glt_credit = nominalCr; model.glt_posted = "N"; model.glt_dt = DateTime.Now; model.glt_branch_id = 10001; context.glt_det.Add(model); context.SaveChanges(); }
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(); }