private void btnSave_Click(object sender, EventArgs e)
{
try
{
BusinessObjects.Company company = new BusinessObjects.Company();
company.CompanyId = CompanyID;
company.CompanyName = txtCompanyName.Text.Trim();
company.Country = txtCountry.Text.Trim();
company.Address = txtAddress.Text.Trim();
company.City = txtCity.Text.Trim();
company.State = cmbState.SelectedValue.ToString();
company.CompanyPhone = txtCompanyPhone.Text.Trim();
company.Email = txtEmail.Text.Trim();
company.Website = txtWebsite.Text.Trim();
company.TIN = txtTIN.Text.Trim();
company.ServiceTaxNo = txtServiceTaxNo.Text.Trim();
company.AdditionalDetails = txtAdditionalDetails.Text.Trim();
company.PAN = txtPAN.Text.Trim();
company.Currency = String.Empty;
company.Logo = ImageName;
company.Status = true;
companyService.UpdateCompany(company);
CustomMessageBox.Show(string.Format(Constants.SUCCESSFULL_SAVE_MESSAGE, txtCompanyName.Text),
Constants.CONSTANT_INFORMATION,
Sleek_Bill.Controls.CustomMessageBox.eDialogButtons.OK,
CustomImages.GetDialogImage(Sleek_Bill.Controls.CustomImages.eCustomDialogImages.Success));
}
catch(Exception ex){
MessageBox.Show("Error : "+ex.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
BusinessObjects.Company company = new BusinessObjects.Company();
company.CompanyId = CompanyID;
company.CompanyName = txtCompanyName.Text.Trim();
company.Country = txtCountry.Text.Trim();
company.Address = txtAddress.Text.Trim();
company.City = txtCity.Text.Trim();
company.State = cmbState.SelectedValue.ToString();
company.CompanyPhone = txtCompanyPhone.Text.Trim();
company.Email = txtEmail.Text.Trim();
company.Website = txtWebsite.Text.Trim();
company.TIN = txtTIN.Text.Trim();
company.ServiceTaxNo = txtServiceTaxNo.Text.Trim();
company.AdditionalDetails = txtAdditionalDetails.Text.Trim();
company.PAN = txtPAN.Text.Trim();
company.Currency = String.Empty;
company.Logo = ImageName;
company.Status = true;
companyService.UpdateCompany(company);
CustomMessageBox.Show(string.Format(Constants.SUCCESSFULL_SAVE_MESSAGE, txtCompanyName.Text),
Constants.CONSTANT_INFORMATION,
Sleek_Bill.Controls.CustomMessageBox.eDialogButtons.OK,
CustomImages.GetDialogImage(Sleek_Bill.Controls.CustomImages.eCustomDialogImages.Success));
}
catch (Exception ex) {
MessageBox.Show("Error : " + ex.Message);
}
}
private void ShowActiveCompanyDetails()
{
BusinessObjects.Company activeCompany = (from company in companyService.GetAllCompany()
.Where(v => v.Status == true)
select company).SingleOrDefault();
SetControlsWithData(activeCompany);
}
public void UpdateCompany(Company company)
{
using (TransactionScope scope = new TransactionScope())
{
Db.ExecuteNonQuery("usp_Company_UpdateCompany", CommandType.StoredProcedure,
new DbParameter[] {
Db.CreateParameter("CompanyId", company.CompanyId),
Db.CreateParameter("CompanyName", company.CompanyName),
Db.CreateParameter("Country", company.Country),
Db.CreateParameter("Address", company.Address),
Db.CreateParameter("City", company.City),
Db.CreateParameter("State", company.State),
Db.CreateParameter("CompanyPhone", company.CompanyPhone),
Db.CreateParameter("Email", company.Email),
Db.CreateParameter("Website", company.Website),
Db.CreateParameter("TIN", company.TIN),
Db.CreateParameter("ServiceTaxNo", company.ServiceTaxNo),
Db.CreateParameter("AdditionalDetails", company.AdditionalDetails),
Db.CreateParameter("PAN", company.PAN),
Db.CreateParameter("Currency", company.Currency),
Db.CreateParameter("Logo", company.Logo)
});
scope.Complete();
}
}
public int AddCompany(Company company)
{
using (TransactionScope scope = new TransactionScope())
{
DbParameter parameter = null;
parameter = Db.CreateParameter("CompanyId", DbType.Int32, 8);
parameter.Direction = ParameterDirection.Output;
Db.ExecuteNonQuery("usp_Company_InsertCompanyDetails", CommandType.StoredProcedure,
new DbParameter[] {
parameter,
Db.CreateParameter("CompanyName", company.CompanyName),
Db.CreateParameter("Country", company.Country),
Db.CreateParameter("Address", company.Address),
Db.CreateParameter("City", company.City),
Db.CreateParameter("State", company.State),
Db.CreateParameter("CompanyPhone", company.CompanyPhone),
Db.CreateParameter("Email", company.Email),
Db.CreateParameter("Website", company.Website),
Db.CreateParameter("TIN", company.TIN),
Db.CreateParameter("ServiceTaxNo", company.ServiceTaxNo),
Db.CreateParameter("AdditionalDetails", company.AdditionalDetails),
Db.CreateParameter("PAN", company.PAN),
Db.CreateParameter("Currency", company.Currency),
Db.CreateParameter("Logo", company.Logo),
Db.CreateParameter("Status", company.Status)
});
scope.Complete();
return (int)parameter.Value;
}
}
private void SetControlsWithData(BusinessObjects.Company activeCompany)
{
if (activeCompany == null)
{
return;
}
CompanyID = activeCompany.CompanyId;
txtCompanyName.Text = activeCompany.CompanyName;
txtAddress.Text = activeCompany.Address;
txtCity.Text = activeCompany.City;
cmbState.SelectedValue = activeCompany.State;
txtCompanyPhone.Text = activeCompany.CompanyPhone;
txtEmail.Text = activeCompany.Email;
txtWebsite.Text = activeCompany.Website;
txtTIN.Text = activeCompany.TIN;
txtServiceTaxNo.Text = activeCompany.ServiceTaxNo;
txtAdditionalDetails.Text = activeCompany.AdditionalDetails;
txtPAN.Text = activeCompany.PAN;
cmbCurrency.SelectedValue = activeCompany.Currency;
string absolutePath = Path.GetDirectoryName(Application.ExecutablePath);
if (absolutePath.EndsWith("\\bin\\Debug"))
{
absolutePath = absolutePath.Replace("\\bin\\Debug", "");
}
string imagePath = Path.Combine(absolutePath, Constants.CONSTANT_IMAGES, Constants.CONSTANT_CompanyLogo);
ImageName = activeCompany.Logo;
Image image = Image.FromFile(Path.Combine(imagePath, activeCompany.Logo), true);
pnlLogo.Controls.Clear();
PictureBox pbLogo = new PictureBox();
pbLogo.Image = image;
pbLogo.SizeMode = PictureBoxSizeMode.StretchImage;
pbLogo.Size = pnlLogo.Size;
pnlLogo.Controls.Add(pbLogo);
btnRemove.Visible = true;
}
public void UpdateCompany(Company company)
{
this.companyDBObj.UpdateCompany(company);
}
public int AddCompany(Company company)
{
return this.companyDBObj.AddCompany(company);
}
