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;
}
public CompanyObject getACompanyObject(string connectionString, int companyID)
{
DataTable results = new DataTable();
CompanyObject company = new CompanyObject();
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareReadCommand("GetACompany", conn);
cmdIns.Parameters.Add(new SqlParameter("@Company_ID", companyID));
using (conn)
using (cmdIns)
using (SqlDataAdapter dataAdapter = new SqlDataAdapter(cmdIns))
{
dataAdapter.Fill(results);
}
cmdIns.Dispose();
DBUtility.Close(conn);
conn.Dispose();
return populateCompany(results.Rows[0], connectionString);
}
catch (Exception ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
DBUtility.Close(conn);
conn.Dispose();
}
}
public Boolean updateACompany(string connectionString, CompanyObject companyObj, int rowIndex)
{
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareSPCommand("sp_UpdateCompany", insertParameters(companyObj), conn);
cmdIns.Parameters.Add(new SqlParameter("@Company_ID",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 CompanyObject populateCompany(DataRow dr, string connectionString)
{
CompanyObject companyObject = new CompanyObject();
if (dr != null)
{
companyObject.Address_Line_1Prop = DBUtility.readDBString(dr, "Address_Line_1");
companyObject.Address_Line_2Prop = DBUtility.readDBString(dr, "Address_Line_2");
companyObject.CityProp = DBUtility.readDBString(dr, "City");
companyObject.CodeProp = DBUtility.readDBString(dr, "Code");
companyObject.Company_LogoProp = DBUtility.readDBImage(dr, "Company_logo");
companyObject.Company_NameProp = DBUtility.readDBString(dr, "Company_name");
companyObject.DisableProp = DBUtility.readDBBool(dr, "Disable");
companyObject.EmailProp = DBUtility.readDBString(dr, "email");
companyObject.FaxProp = DBUtility.readDBString(dr, "fax");
companyObject.Invoice_FooterProp = DBUtility.readDBString(dr, "Invoice_Footer");
companyObject.Telephone1Prop = DBUtility.readDBString(dr, "telephone_1");
companyObject.Telephone2Prop = DBUtility.readDBString(dr, "telephone_2");
companyObject.VAT_NumberProp = DBUtility.readDBString(dr, "VAT_number");
companyObject.VAT_percentageProp = DBUtility.readDBInt(dr, "VAT_percentage");
companyObject.WebsiteProp = DBUtility.readDBString(dr, "website");
}
return companyObject;
}
public List<SqlParameter> insertParameters(CompanyObject companyObj)
{
List <SqlParameter> insertParamsArray = new List<SqlParameter>();
insertParamsArray.Add(new SqlParameter("@Company_name", companyObj.Company_NameProp));
insertParamsArray.Add(new SqlParameter("@Address_Line_1", companyObj.Address_Line_1Prop));
insertParamsArray.Add(new SqlParameter("@Address_Line_2", companyObj.Address_Line_2Prop));
insertParamsArray.Add(new SqlParameter("@City", companyObj.CityProp));
insertParamsArray.Add(new SqlParameter("@Code", companyObj.CodeProp));
insertParamsArray.Add(new SqlParameter("@Telephone1", companyObj.Telephone1Prop));
insertParamsArray.Add(new SqlParameter("@Telephone2", companyObj.Telephone2Prop));
insertParamsArray.Add(new SqlParameter("@Fax", companyObj.FaxProp));
insertParamsArray.Add(new SqlParameter("@Email", companyObj.EmailProp));
insertParamsArray.Add(new SqlParameter("@Website", companyObj.WebsiteProp));
insertParamsArray.Add(new SqlParameter("@VAT_Number", companyObj.VAT_NumberProp ));
insertParamsArray.Add(new SqlParameter("@VAT_Percentage", companyObj.VAT_percentageProp));
insertParamsArray.Add(new SqlParameter("@Invoice_Footer", companyObj.Invoice_FooterProp));
insertParamsArray.Add(new SqlParameter("@Company_Logo", companyObj.Company_LogoProp));
insertParamsArray.Add(new SqlParameter("@disable", companyObj.DisableProp));
return insertParamsArray;
}
public bool insert(CompanyObject CompanyObj, string connectionString)
{
try
{
conn = DBUtility.createConnection(connectionString);
SqlCommand cmdIns = DBUtility.PrepareSPCommand("sp_InsertCompany", insertParameters(CompanyObj), 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();
}
}