protected void grdCompany_RowCommand(object sender, GridViewCommandEventArgs e) { int rowIndex = int.Parse(e.CommandArgument.ToString()); Session.Add("rowIndex", rowIndex); ManageCompany companyObj = new ManageCompany(); DataTable dt = companyObj.getACompany(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString, rowIndex); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; txtCompanyName.Value = DBUtility.readDBString(dr,"Company_Name"); txtCompanyAddress.Value = DBUtility.readDBString(dr,"Address_Line_1"); txtCompanyAddressLine2.Value = DBUtility.readDBString(dr,"Address_Line_2"); txtCompanyCity.Value = DBUtility.readDBString(dr, "City"); txtCompanyCode.Value = DBUtility.readDBString(dr, "Code"); txtCompanyTelephone.Value = DBUtility.readDBString(dr, "telephone_1"); txtCompanyTelephone2.Value = DBUtility.readDBString(dr, "telephone_2"); txtCompanyFax.Value = DBUtility.readDBString(dr, "fax"); txtCompanyEmail.Value = DBUtility.readDBString(dr, "email"); txtCompanyWebsite.Value = DBUtility.readDBString(dr, "website"); txtCompanyVATNumbwer.Value = DBUtility.readDBString(dr, "VAT_Number"); txtCompanyVATPercentage.Value = DBUtility.readDBString(dr, "VAT_percentage"); if (dr["Disable"] != null && !dr.IsNull("Disable")) { chkBoxCompanyDisable.Checked = Convert.ToBoolean(dr["Disable"]); } } }
protected void btnSaveCompany_ServerClick(object sender, EventArgs e) { CompanyObject obj = new CompanyObject(); obj.Company_NameProp = txtCompanyName.Value; obj.Address_Line_1Prop = txtCompanyAddress.Value; obj.Address_Line_2Prop = txtCompanyAddressLine2.Value; obj.CityProp = txtCompanyCity.Value; obj.CodeProp = txtCompanyCode.Value; obj.Telephone1Prop = txtCompanyTelephone.Value; obj.Telephone2Prop = txtCompanyTelephone2.Value; obj.FaxProp = txtCompanyFax.Value; obj.EmailProp = txtCompanyEmail.Value; obj.WebsiteProp = txtCompanyWebsite.Value; obj.VAT_NumberProp= txtCompanyVATNumbwer.Value; obj.Invoice_FooterProp = ""; if (txtCompanyVATPercentage.Value != "") obj.VAT_percentageProp = int.Parse(txtCompanyVATPercentage.Value); if ( fileUplaodCompanyLogo.PostedFile != null ) { Byte[] bytes; using (System.IO.BinaryReader r = new System.IO.BinaryReader(fileUplaodCompanyLogo.PostedFile.InputStream)) { // Read the data from the stream into the byte array bytes = r.ReadBytes(Convert.ToInt32(fileUplaodCompanyLogo.PostedFile.ContentLength)); } obj.Company_LogoProp = bytes; } obj.DisableProp = chkBoxCompanyDisable.Checked; ManageCompany companyObj = new ManageCompany(); bool success = companyObj.updateACompany(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString, obj, Convert.ToInt32(Session["rowIndex"])); Session.Remove("rowIndex"); if (success) { divSuccess.Visible = true; } else divFailure.Visible = true; }
protected void grdCompany_Load(object sender, EventArgs e) { ManageCompany companyObj = new ManageCompany(); grdCompany.DataSource = companyObj.getCompanyInfo(ConfigurationManager.ConnectionStrings["MVSSqlDev2008ConnectionString"].ConnectionString); grdCompany.DataBind(); }