public void Update(String KODEBPJ, String KODEKELENGKAPAN, DateTime TANGGALDITERIMA, String PENERIMAKELENGKAPAN) { KELENGKAPANPBJ item = new KELENGKAPANPBJ(); item.KODEBPJ = KODEBPJ; item.KODEKELENGKAPAN = KODEKELENGKAPAN; item.TANGGALDITERIMA = TANGGALDITERIMA; item.PENERIMAKELENGKAPAN = PENERIMAKELENGKAPAN; item.MarkOld(); item.Save(""); }
private void SaveData() { item = new Data.KELENGKAPANPBJ(); // processing KODEBPJ - start if (!string.IsNullOrEmpty(Request["value_KODEBPJ"])) { item.KODEBPJ = Convert.ToString(Request["value_KODEBPJ"]); } // processing KODEKELENGKAPAN - start if (!string.IsNullOrEmpty(Request["value_KODEKELENGKAPAN"])) { item.KODEKELENGKAPAN = Convert.ToString(Request["value_KODEKELENGKAPAN"]); } // processing TANGGALDITERIMA - start if (!string.IsNullOrEmpty(Request["value_T
public static void SaveKELENGKAPANMap(string varKODEPBJ, string[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM KELENGKAPANPBJ WHERE KODEBPJ=@KODEBPJ", PBJ.Schema.Provider.Name); cmdDel.AddParameter("@KODEBPJ", varKODEPBJ); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (string item in itemList) { KELENGKAPANPBJ varKELENGKAPANPBJ = new KELENGKAPANPBJ(); varKELENGKAPANPBJ.SetColumnValue("KODEBPJ", varKODEPBJ); varKELENGKAPANPBJ.SetColumnValue("KODEKELENGKAPAN", item); varKELENGKAPANPBJ.Save(); } }
public static void SavePBJMap(string varKODEKELENGKAPAN, System.Web.UI.WebControls.ListItemCollection itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM KELENGKAPANPBJ WHERE KODEKELENGKAPAN=@KODEKELENGKAPAN", KELENGKAPAN.Schema.Provider.Name); cmdDel.AddParameter("@KODEKELENGKAPAN", varKODEKELENGKAPAN); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { KELENGKAPANPBJ varKELENGKAPANPBJ = new KELENGKAPANPBJ(); varKELENGKAPANPBJ.SetColumnValue("KODEKELENGKAPAN", varKODEKELENGKAPAN); varKELENGKAPANPBJ.SetColumnValue("KODEBPJ", l.Value); varKELENGKAPANPBJ.Save(); } } }
private bool Init() { inlineedit = ((string)Request["editType"] == "inline"); record_id = (string)Request["recordID"]; if (inlineedit) { templatefile = "KELENGKAPANPBJ_inline_edit.aspx"; } else { templatefile = "KELENGKAPANPBJ_edit.aspx"; } keys["KODEBPJ"] = Request["editid1"]; keys["KODEKELENGKAPAN"] = Request["editid2"]; if (keys.Count > 1) { item = controller.FetchByManyID(keys); } else { item = Data.KELENGKAPANPBJ.FetchByID(Request["editid1"]); } if (item != null) { bool editable = true; if (!editable) { output.Append("<p>" + "You don't have permissions to access this table" + " <a href=\"KELENGKAPANPBJ_list.aspx?a=return\">back</a>"); return(false); } } else { this.Server.Transfer("~/KELENGKAPANPBJ_list.aspx?a=return"); } return(true); }
private void SaveData() { string sOleh = ""; DateTime tgTerima = new DateTime(1970, 1, 1, 0, 0, 0, 1); if (RequestAction != "edited") { item = new Data.KELENGKAPANPBJ(); } Data.KELENGKAPANPBJ emptyItem = new Data.KELENGKAPANPBJ(); // processing TANGGALDITERIMA - start if (!string.IsNullOrEmpty(Request["value_TANGGALDITERIMA"])) { item.TANGGALDITERIMA = Convert.ToDateTime(Request["value_TANGGALDITERIMA"]); } else { item.TANGGALDITERIMA = emptyItem.TANGGALDITERIMA; } tgTerima = Convert.ToDateTime(item.TANGGALDITERIMA); // processing PENERIMAKELENGKAPAN - start if (!string.IsNullOrEmpty(Request["value_PENERIMAKELENGKAPAN"])) { item.PENERIMAKELENGKAPAN = Convert.ToString(Request["value_PENERIMAKELENGKAPAN"]); } else { item.PENERIMAKELENGKAPAN = emptyItem.PENERIMAKELENGKAPAN; } sOleh = Convert.ToString(item.PENERIMAKELENGKAPAN); // //item.KODEBPJ = Convert.ToString(Request["editid1"]); // //item.KODEKELENGKAPAN = Convert.ToString(Request["editid2"]); // string idx = string.Empty; string sKodeBPJ = ""; string sKodeLkp = ""; idx = "1"; item.KODEBPJ = Convert.ToString(Request["editid" + idx]); idx = "2"; item.KODEKELENGKAPAN = Convert.ToString(Request["editid" + idx]); bool abortSaving = false; if (!abortSaving) { item.MarkOld(); //item.Save(); idx = "1"; item.KODEBPJ = Convert.ToString(Request["editid" + idx]); sKodeBPJ = Convert.ToString(item.KODEBPJ); idx = "2"; item.KODEKELENGKAPAN = Convert.ToString(Request["editid" + idx]); sKodeLkp = Convert.ToString(item.KODEKELENGKAPAN); Response.Redirect("ubah_kelengkapanpbj.aspx?pbj=" + sKodeBPJ + "&lkp=" + sKodeLkp + "&tgl=" + String.Format("{0:yyyy-MM-dd}", tgTerima) + "&oleh=" + sOleh); ShowSuccessMessage(); } }