public void postmaster_vendor_update(AppLogic.Vendor vendor, int get_vid)
{
SqlConnection conVENDOR = new SqlConnection(cs);
SqlCommand cmdVENDOR = new SqlCommand("update vendor_master set [Contact_Person_name]='" + vendor.Contact_Person_name + "' , [Contact_Person_Phone]='" + vendor.Contact_Person_Phone + "' , [Address]='" + vendor.Address + "' , [goods_desc]='" + vendor.goods_desc + "' where id=" + get_vid, conVENDOR);
try
{
conVENDOR.Open();
cmdVENDOR.ExecuteNonQuery();
conVENDOR.Close();
errTrue = false;
}
catch (Exception ex)
{
conVENDOR.Close();
repText = ex.ToString();
errTrue = true;
}
}
public void postmaster_vendor(AppLogic.Vendor vendor)
{
SqlConnection conVENDOR = new SqlConnection(cs);
SqlCommand cmdVENDOR = new SqlCommand("INSERT INTO vendor_master(VendorName, Contact_Person_name, Contact_Person_Phone, Address, goods_desc) values('" + vendor.VendorName + "','" + vendor.Contact_Person_name + "','" + vendor.Contact_Person_Phone + "','" + vendor.Address + "','" + vendor.goods_desc + "')", conVENDOR);
try
{
conVENDOR.Open();
cmdVENDOR.ExecuteNonQuery();
conVENDOR.Close();
errTrue = false;
}
catch (Exception ex)
{
conVENDOR.Close();
repText = ex.ToString();
errTrue = true;
//throw;
}
}
