protected void SavePP_Agen_Click(object sender, EventArgs e)
{
string vendor2 = Request.QueryString["agen"];
string path2 = Server.MapPath("Images/");
if (UploadPP_Agen.HasFile)
{
int filesize1 = UploadPP_Agen.PostedFile.ContentLength;
if (filesize1 > 2097152)
{
Response.Write(@"<script language='javascript'>alert('Ukuran file lebih dari 2Mb');</script>");
}
else
{
UploadPP_Agen.SaveAs(path2 + UploadPP_Agen.FileName);
string name2 = "~/Images/" + UploadPP_Agen.FileName;
string s2 = "UPDATE [dbo].[agen] SET [imgpp_agen] = '" + name2 + "' WHERE [id_vendor_agen] = '" + vendor2 + "'";
SqlCommand cmd2 = new SqlCommand(s2, con);
con.Open();
cmd2.ExecuteNonQuery();
con.Close();
Response.Redirect(Request.RawUrl);
}
}
else
{
}
}
protected void Save_Agen_Click(object sender, EventArgs e)
{
string path = Server.MapPath("Images/");
if (UploadPP_Agen.HasFile)
{
int filesize = UploadPP_Agen.PostedFile.ContentLength;
if (filesize > 2097152)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "scriptkey", "<script>alert('Ukuran file gambar maksimal 2 Megabyte.');</script>");
}
else
{
UploadPP_Agen.SaveAs(path + UploadPP_Agen.FileName);
string name = "~/Images/" + UploadPP_Agen.FileName;
string s = "INSERT INTO agen(no_vendor_agen, soldto_agen, shipto_agen, produk_agen, nama_agen, alamat1_agen, alamat2_agen, kota_agen, provinsi_agen, rayon_agen, status_agen, email_agen, telp_agen, koor_agen, jmltruk_agen, kaptruk_agen, jmlpangkal_agen, jmlsalur_agen, jmltabung_agen, imgpp_agen, kapgdg_agen) VALUES('" + TextBox_vendor_agen.Text + "','" + TextBox_kode_agen.Text + "','" + TextBox_tipe_agen.Text + "','" + TextBox_produk_agen.Text + "','" + TextBox_nama_agen.Text + "','" + TextBox_alamat1_agen.Text + "','" + TextBox_alamat2_agen.Text + "','" + TextBox_kota_agen.Text + "','" + TextBox_provinsi_agen.Text + "','" + TextBox_rayon_agen.Text + "','" + TextBox_status_agen.Text + "','" + TextBox_email_agen.Text + "','" + TextBox_telp_agen.Text + "','" + TextBox_koor_agen.Text + "','" + TextBox_jmltruk_agen.Text + "','" + TextBox_kaptruk_agen.Text + "','" + TextBox_jmlpangkal_agen.Text + "','" + TextBox_jmlsalur_agen.Text + "','" + TextBox_jmltabung_agen.Text + "','" + name + "','" + TextBox_kapgdg_agen.Text + "')";
SqlCommand cmd = new SqlCommand(s, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Response.Redirect(Request.RawUrl);
}
}
else
{
string s = "INSERT INTO agen(no_vendor_agen, soldto_agen, shipto_agen, produk_agen, nama_agen, alamat1_agen, alamat2_agen, kota_agen, provinsi_agen, rayon_agen, status_agen, email_agen, telp_agen, koor_agen, jmltruk_agen, kaptruk_agen, jmlpangkal_agen, jmlsalur_agen, jmltabung_agen, kapgdg_agen) VALUES('" + TextBox_vendor_agen.Text + "','" + TextBox_kode_agen.Text + "','" + TextBox_tipe_agen.Text + "','" + TextBox_produk_agen.Text + "','" + TextBox_nama_agen.Text + "','" + TextBox_alamat1_agen.Text + "','" + TextBox_alamat2_agen.Text + "','" + TextBox_kota_agen.Text + "','" + TextBox_provinsi_agen.Text + "','" + TextBox_rayon_agen.Text + "','" + TextBox_status_agen.Text + "','" + TextBox_email_agen.Text + "','" + TextBox_telp_agen.Text + "','" + TextBox_koor_agen.Text + "','" + TextBox_jmltruk_agen.Text + "','" + TextBox_kaptruk_agen.Text + "','" + TextBox_jmlpangkal_agen.Text + "','" + TextBox_jmlsalur_agen.Text + "','" + TextBox_jmltabung_agen.Text + "','" + TextBox_kapgdg_agen.Text + "')";
SqlCommand cmd = new SqlCommand(s, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Response.Redirect(Request.RawUrl);
}
}
