protected void grdSupplier_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowIndex = int.Parse(e.CommandArgument.ToString());
Session.Add("rowIndex", rowIndex);
ManageSupplier supplierObj = new ManageSupplier();
DataTable dt = supplierObj.getASupplier(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString, rowIndex);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
txtSupplierName.Value = DBUtility.readDBString(dr, "Supplier_name");
txtSupplierAddress.Value = DBUtility.readDBString(dr, "Address_Line_1");
txtSupplierAddressLine2.Value = DBUtility.readDBString(dr, "Address_Line_2");
txtSupplierCity.Value = DBUtility.readDBString(dr, "City");
txtSupplierCode.Value = DBUtility.readDBString(dr, "Code");
txtSupplierTelephone.Value = DBUtility.readDBString(dr, "telephone_1");
txtSupplierTelephone2.Value = DBUtility.readDBString(dr, "telephone_2");
txtSupplierCellphone.Value = DBUtility.readDBString(dr, "Cellphone");
txtSupplierFax.Value = DBUtility.readDBString(dr, "fax");
txtSupplierEmail.Value = DBUtility.readDBString(dr, "email");
txtSupplierRepresentative.Value = DBUtility.readDBString(dr, "Representative");
txtSupplierVATNumber.Value = DBUtility.readDBString(dr, "VAT_number");
txtSupplierCKNumber.Value = DBUtility.readDBString(dr, "CK_number");
if (dr["wholesale_supplier"] != null && !dr.IsNull("wholesale_supplier"))
{
chkSupplierWholesale.Checked = Convert.ToBoolean(dr["wholesale_supplier"]);
}
if (dr["Disable"] != null && !dr.IsNull("Disable"))
{
chkBoxSupplierDisable.Checked = Convert.ToBoolean(dr["Disable"]);
}
}
}
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;
}
private void bindLstSupplier()
{
ManageSupplier manageSupplier = new ManageSupplier();
var lstSupplier = manageSupplier.getSupplierList(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString);
lstVehicleSupplier.DataSource = lstSupplier;
lstVehicleSupplier.DataTextField = "Supplier_name";
lstVehicleSupplier.DataValueField = "Supplier_name";
lstVehicleSupplier.DataBind();
}
protected void grdSupplier_Load(object sender, EventArgs e)
{
ManageSupplier supplierObj = new ManageSupplier();
grdSupplier.DataSource = supplierObj.getSupplierInfo(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString);
grdSupplier.DataBind();
}