private void CopyRecord() { // copy record if (Request["copyid1"] != null || Request["editid1"] != null) { if (Request["copyid1"] != null) { item = Data.Tb_Vendor.FetchByID(Request["copyid1"]); isCopy = true; } else { item = Data.Tb_Vendor.FetchByID(Request["editid1"]); } // clear key fields defvalues["KD_VENDOR"] = item.KD_VENDOR; } else if (defvalues.Count == 0) { } if (inlineedit == ADD_MODE.ADD_ONTHEFLY) { } }
private bool Init() { inlineedit = ((string)Request["editType"] == "inline"); record_id = (string)Request["recordID"]; if (inlineedit) { templatefile = "Tb_Vendor_inline_edit.aspx"; } else { templatefile = "Tb_Vendor_edit.aspx"; } keys["KD_VENDOR"] = Request["editid1"]; if (keys.Count > 1) { item = controller.FetchByManyID(keys); } else { item = Data.Tb_Vendor.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=\"Tb_Vendor_list.aspx?a=return\">back</a>"); return(false); } } else { this.Server.Transfer("~/Tb_Vendor_list.aspx?a=return"); } return(true); }
private void SaveData() { if (RequestAction != "edited") { item = new Data.Tb_Vendor(); } Data.Tb_Vendor emptyItem = new Data.Tb_Vendor(); // processing NAMA - start if (!string.IsNullOrEmpty(Request["value_NAMA"])) { item.NAMA = Convert.ToString(Request["value_NAMA"]); } else { item.NAMA = emptyItem.NAMA; } // processing ALAMAT - start if (!string.IsNullOrEmpty(Request["value_ALAMAT"])) { item.ALAMAT = Convert.ToString(Request["value_ALAMAT"]); } else { item.ALAMAT = emptyItem.ALAMAT; } // processing NPWP - start if (!string.IsNullOrEmpty(Request["value_NPWP"])) { item.NPWP = Convert.ToString(Request["value_NPWP"]); } else { item.NPWP = emptyItem.NPWP; } // processing TELEPON - start if (!string.IsNullOrEmpty(Request["value_TELEPON"])) { item.TELEPON = Convert.ToString(Request["value_TELEPON"]); } else { item.TELEPON = emptyItem.TELEPON; } // processing FAX - start if (!string.IsNullOrEmpty(Request["value_FAX"])) { item.FAX = Convert.ToString(Request["value_FAX"]); } else { item.FAX = emptyItem.FAX; } // processing EMAIL - start if (!string.IsNullOrEmpty(Request["value_EMAIL"])) { item.EMAIL = Convert.ToString(Request["value_EMAIL"]); } else { item.EMAIL = emptyItem.EMAIL; } // processing STATUS - start if (!string.IsNullOrEmpty(Request["value_STATUS"])) { string checkboxVal = (string)Request["value_STATUS"]; checkboxVal = checkboxVal.ToLower(); if (checkboxVal == "on") { item.STATUS = true; } else { item.STATUS = false; } } else { item.STATUS = emptyItem.STATUS; } // //item.KD_VENDOR = Convert.ToString(Request["editid1"]); // string idx = string.Empty; idx = "1"; item.KD_VENDOR = Convert.ToInt32(Request["editid" + idx]); bool abortSaving = false; if (!abortSaving) { item.MarkOld(); item.Save(); idx = "1"; item.KD_VENDOR = Convert.ToInt32(Request["editid" + idx]); ShowSuccessMessage(); } }
private void SaveData() { item = new Data.Tb_Vendor(); // processing KD_VENDOR - start SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); string ssql = " select top 1 KD_VENDOR from Tb_Vendor order by KD_VENDOR desc "; SqlCommand myCommand = new SqlCommand(); myCommand.CommandText = ssql; myCommand.CommandType = CommandType.Text; myCommand.Connection = myConnection; myConnection.Open(); SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection); int iPbjCtr = 0; while (myReader.Read()) { iPbjCtr = Convert.ToInt32(myReader.GetValue(0).ToString()) + 1; } myReader.Close(); //if(!string.IsNullOrEmpty(Request["value_KD_VENDOR"])) //{ // item.KD_VENDOR = Convert.ToInt32(Request["value_KD_VENDOR"]); //} else { // item.KD_VENDOR = iPbjCtr; //} // processing NAMA - start if (!string.IsNullOrEmpty(Request["value_NAMA"])) { item.NAMA = Convert.ToString(Request["value_NAMA"]); } // processing ALAMAT - start if (!string.IsNullOrEmpty(Request["value_ALAMAT"])) { item.ALAMAT = Convert.ToString(Request["value_ALAMAT"]); } // processing NPWP - start if (!string.IsNullOrEmpty(Request["value_NPWP"])) { item.NPWP = Convert.ToString(Request["value_NPWP"]); } // processing TELEPON - start if (!string.IsNullOrEmpty(Request["value_TELEPON"])) { item.TELEPON = Convert.ToString(Request["value_TELEPON"]); } // processing FAX - start if (!string.IsNullOrEmpty(Request["value_FAX"])) { item.FAX = Convert.ToString(Request["value_FAX"]); } // processing EMAIL - start if (!string.IsNullOrEmpty(Request["value_EMAIL"])) { item.EMAIL = Convert.ToString(Request["value_EMAIL"]); } // processing STATUS - start if (!string.IsNullOrEmpty(Request["value_STATUS"])) { if ((string)Request["value_STATUS"] == "on") { item.STATUS = true; } } bool abortSaving = false; if (!abortSaving) { //item.Save(); // save vendor ssql = "insert into Tb_Vendor values (" + iPbjCtr + ",'" + item.NAMA + "','" + item.ALAMAT + "','" + item.NPWP + "','" + item.TELEPON + "','" + item.FAX + "','" + item.EMAIL + "',1,getdate(),'admin',getdate(),'admin');"; if (!string.IsNullOrEmpty(ssql)) { myCommand = new SqlCommand(); myCommand.CommandText = ssql; myCommand.CommandType = CommandType.Text; myCommand.Connection = myConnection; myConnection.Open(); int recAffected = 0; recAffected = myCommand.ExecuteNonQuery(); myCommand.Dispose(); myConnection.Close(); myConnection.Dispose(); } // end of save vendor ShowSuccessMessage(); } }