protected void btnSaveSupplier_ServerClick(object sender, EventArgs e)
{
SupplierObject obj = new SupplierObject();
obj.Supplier_NameProp = txtSupplierName.Value;
obj.Address_Line_1Prop = txtSupplierAddress.Value;
obj.Address_Line_2Prop = txtSupplierAddressLine2.Value;
obj.CityProp = txtSupplierCity.Value;
obj.CodeProp = txtSupplierCode.Value;
obj.Telephone1Prop = txtSupplierTelephone.Value;
obj.Telephone2Prop = txtSupplierTelephone2.Value;
obj.FaxProp = txtSupplierFax.Value;
obj.EmailProp = txtSupplierEmail.Value;
obj.RepresentativeProp = txtSupplierRepresentative.Value;
obj.VAT_NumberProp = txtSupplierVATNumber.Value;
obj.CK_NumberProp = txtSupplierCKNumber.Value;
obj.DisableProp = chkBoxSupplierDisable.Checked;
obj.Wholesale_SupplierProp = chkSupplierWholesale.Checked;
ManageSupplier supplierObj = new ManageSupplier();
bool success = supplierObj.updateASupplier(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString, obj, Convert.ToInt32(Session["rowIndex"]));
Session.Remove("rowIndex");
if (success)
{
divSuccess.Visible = true;
}
else
divFailure.Visible = true;
}
public List<SqlParameter> insertParameters(SupplierObject supplierObj)
{
List<SqlParameter> insertParamsArray = new List<SqlParameter>();
insertParamsArray.Add(new SqlParameter("@Supplier_name", supplierObj.Supplier_NameProp));
insertParamsArray.Add(new SqlParameter("@Address_Line_1", supplierObj.Address_Line_1Prop));
insertParamsArray.Add(new SqlParameter("@Address_Line_2", supplierObj.Address_Line_2Prop));
insertParamsArray.Add(new SqlParameter("@City", supplierObj.CityProp));
insertParamsArray.Add(new SqlParameter("@Code", supplierObj.CodeProp));
insertParamsArray.Add(new SqlParameter("@Telephone1", supplierObj.Telephone1Prop));
insertParamsArray.Add(new SqlParameter("@Telephone2", supplierObj.Telephone2Prop));
insertParamsArray.Add(new SqlParameter("@Fax", supplierObj.FaxProp));
insertParamsArray.Add(new SqlParameter("@Email", supplierObj.EmailProp));
insertParamsArray.Add(new SqlParameter("@Wholesale_Supplier", supplierObj.Wholesale_SupplierProp));
insertParamsArray.Add(new SqlParameter("@Cellphone", supplierObj.Cellphone1Prop));
insertParamsArray.Add(new SqlParameter("@VAT_Number", supplierObj.VAT_NumberProp));
insertParamsArray.Add(new SqlParameter("@Representative", supplierObj.RepresentativeProp));
insertParamsArray.Add(new SqlParameter("@CK_Number", supplierObj.CK_NumberProp));
insertParamsArray.Add(new SqlParameter("@Disable", supplierObj.DisableProp));
return insertParamsArray;
}
public Boolean updateASupplier(string connectionString, SupplierObject supplierObj, int rowIndex)
{
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareSPCommand("sp_UpdateSupplier", insertParameters(supplierObj), conn);
cmdIns.Parameters.Add(new SqlParameter("@Supplier_Code", rowIndex));
int rowsUpdated = cmdIns.ExecuteNonQuery();
cmdIns.Dispose();
DBUtility.Close(conn);
conn.Dispose();
if (rowsUpdated > 0)
{
return true;
}
else return false;
}
catch (Exception ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
DBUtility.Close(conn);
conn.Dispose();
}
}
public bool insert(SupplierObject SupplierObj, string connectionString)
{
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareSPCommand("sp_InsertSupplier", insertParameters(SupplierObj), conn);
int rowsUpdated = cmdIns.ExecuteNonQuery();
// cmdIns.Parameters.Clear();
// cmdIns.CommandText = "SELECT @@IDENTITY";
// // Get the last inserted id.
// int insertID = Convert.ToInt32(cmdIns.ExecuteScalar());
cmdIns.Dispose();
DBUtility.Close(conn);
conn.Dispose();
if (rowsUpdated > 0)
{
return true;
}
else return false;
}
catch (Exception ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
DBUtility.Close(conn);
conn.Dispose();
}
}