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