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