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