public void CompanyPathEdit(CompanyPathInfo companypathinfo) { try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("CompanyPathEdit", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam7 = new SqlParameter(); sprmparam7 = sccmd.Parameters.Add("@companyId", SqlDbType.Decimal); sprmparam7.Value = companypathinfo.CompanyId; sprmparam7 = sccmd.Parameters.Add("@companyName", SqlDbType.VarChar); sprmparam7.Value = companypathinfo.CompanyName; sprmparam7 = sccmd.Parameters.Add("@companyPath", SqlDbType.VarChar); sprmparam7.Value = companypathinfo.CompanyPath; sprmparam7 = sccmd.Parameters.Add("@isDefault", SqlDbType.Bit); sprmparam7.Value = companypathinfo.IsDefault; sprmparam7 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam7.Value = companypathinfo.Extra1; sprmparam7 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam7.Value = companypathinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { base.sqlcon.Close(); } }
public void CompanyPathEdit(CompanyPathInfo companypathinfo) { CompanyPathSP spCompanyPath = new CompanyPathSP(); try { spCompanyPath.CompanyPathEdit(companypathinfo); } catch (Exception ex) { MessageBox.Show("CP2" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void CompanyPathAdd(CompanyPathInfo companypathinfo) { CompanyPathInfo infoCompanyPath = new CompanyPathInfo(); decimal idCheck = PublicVariables._decCurrentCompanyId; try { spCompanyPath.CompanyPathAdd(companypathinfo); } catch (Exception ex) { MessageBox.Show("CP1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public CompanyPathInfo CompanyPathView(decimal companyId) { CompanyPathSP spCompanyPath = new CompanyPathSP(); CompanyPathInfo infoCompanyPath = new CompanyPathInfo(); try { infoCompanyPath = spCompanyPath.CompanyPathView(companyId); } catch (Exception ex) { MessageBox.Show("CP3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(infoCompanyPath); }
public void CompanyPathAdd(CompanyPathInfo companypathinfo) { try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@companyName", companypathinfo.CompanyName)); paramCollection.Add(new DBParameter("@companyPath", companypathinfo.CompanyPath)); paramCollection.Add(new DBParameter("@isDefault", companypathinfo.IsDefault)); paramCollection.Add(new DBParameter("@extra1", companypathinfo.Extra1)); paramCollection.Add(new DBParameter("@extra2", companypathinfo.Extra2)); _dbHelper.ExecuteNonQuery("spCompanyPathAdd", paramCollection, System.Data.CommandType.StoredProcedure); } catch (Exception ex) { } finally { } }
public CompanyPathInfo CompanyPathView(decimal companyId) { CompanyPathInfo companypathinfo = new CompanyPathInfo(); SqlDataReader sdrreader = null; try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("CompanyPathView", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam2 = new SqlParameter(); sprmparam2 = sccmd.Parameters.Add("@companyId", SqlDbType.Decimal); sprmparam2.Value = companyId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { companypathinfo.CompanyId = decimal.Parse(((DbDataReader)sdrreader)[0].ToString()); companypathinfo.CompanyName = ((DbDataReader)sdrreader)[1].ToString(); companypathinfo.CompanyPath = ((DbDataReader)sdrreader)[2].ToString(); companypathinfo.IsDefault = bool.Parse(((DbDataReader)sdrreader)[3].ToString()); companypathinfo.ExtraDate = DateTime.Parse(((DbDataReader)sdrreader)[4].ToString()); companypathinfo.Extra1 = ((DbDataReader)sdrreader)[5].ToString(); companypathinfo.Extra2 = ((DbDataReader)sdrreader)[6].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); base.sqlcon.Close(); } return(companypathinfo); }
/// <summary> /// Function for Save /// </summary> public void SaveFunction() { try { CompanyInfo infoCompany = new CompanyInfo(); CompanyCreationBll BllCompanyCreation = new CompanyCreationBll(); CompanyPathInfo infoCompanyPath = new CompanyPathInfo(); CompanyPathBll BllCompanyPath = new CompanyPathBll(); UserInfo infoUser = new UserInfo(); UserBll bllUser = new UserBll(); ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo(); //ExchangeRateBll BllExchangeRate = new ExchangeRateBll(); infoCompany.CompanyName = txtCompanyName.Text.Trim(); infoCompany.MailingName = txtMailingName.Text.Trim(); infoCompany.Address = txtAddress.Text.Trim(); infoCompany.Phone = txtPhoneNo.Text.Trim(); infoCompany.Mobile = txtMobile.Text.Trim(); infoCompany.EmailId = txtEmail.Text.Trim(); infoCompany.Web = txtWeb.Text.Trim(); infoCompany.Country = txtCountry.Text.Trim(); infoCompany.State = txtState.Text.Trim(); infoCompany.Pin = txtPincode.Text.Trim(); infoCompany.CurrencyId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()); decCurrencyIdForStatus = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()); infoCompany.FinancialYearFrom = Convert.ToDateTime(txtFinancialYearFrom.Text.Trim().ToString()); infoCompany.BooksBeginingFrom = Convert.ToDateTime(txtBooksBegining.Text.Trim().ToString()); infoCompany.Tin = txtTinNo.Text.Trim(); infoCompany.Cst = txtCstNo.Text.Trim(); infoCompany.Pan = txtPanNo.Text.Trim(); infoCompany.CurrentDate = DateTime.Now; infoCompany.Logo = logo; infoCompany.Extra1 = string.Empty; infoCompany.Extra2 = string.Empty; infoCompanyPath.CompanyName = txtCompanyName.Text.Trim(); infoCompanyPath.IsDefault = cbxSetAsDefault.Checked; infoCompanyPath.Extra1 = string.Empty; infoCompanyPath.Extra2 = string.Empty; infoUser.UserName = txtAdminUserName.Text.Trim(); infoUser.Password = txtPassword.Text.Trim(); infoUser.Active = true; infoUser.Extra1 = string.Empty; infoUser.Extra2 = string.Empty; infoUser.Narration = string.Empty; infoUser.RoleId = 1; if (BllCompanyCreation.CompanyCheckExistence(txtCompanyName.Text.Trim().ToString(), 0) == false) { decimal decCompanyId = BllCompanyCreation.CompanyAddParticularFeilds(infoCompany); PublicVariables._decCurrentCompanyId = decCompanyId; infoCompanyPath.CompanyPath = Application.StartupPath + "\\Data\\" + PublicVariables._decCurrentCompanyId; BllCompanyPath.CompanyPathAdd(infoCompanyPath); if (formMDI.demoProject || CreateCompany()) { if (!formMDI.demoProject) { infoCompanyPath.CompanyPath = strPath; } else { infoCompanyPath.CompanyPath = Application.StartupPath + "\\Data"; PublicVariables._decCurrentCompanyId = 0; } CompanyInfo infoNewCompany = new CompanyInfo(); CompanyPathInfo infoNewCompanyPath = new CompanyPathInfo(); UserInfo infoNewUser = new UserInfo(); UserBll bllNewUser = new UserBll(); ExchangeRateInfo infoNewExchangeRate = new ExchangeRateInfo(); ExchangeRateBll BllExchangeRate = new ExchangeRateBll(); CompanyPathBll BllNewCompanyPath = new CompanyPathBll(); infoNewCompany = infoCompany; infoNewCompanyPath = infoCompanyPath; infoNewUser = infoUser; decCompanyId = BllCompanyCreation.CompanyAddParticularFeilds(infoNewCompany); bllNewUser.UserAdd(infoNewUser); BllNewCompanyPath.CompanyPathAdd(infoNewCompanyPath); Messages.SavedMessage(); formMDI.MDIObj.MenuStripEnabling(); // To set default currencyId.............// infoNewExchangeRate.CurrencyId = infoNewCompany.CurrencyId; infoNewExchangeRate.Rate = 1; infoNewExchangeRate.Narration = string.Empty; infoNewExchangeRate.Extra1 = string.Empty; infoNewExchangeRate.Extra2 = string.Empty; infoNewExchangeRate.ExtraDate = System.DateTime.Now; infoNewExchangeRate.Date = System.DateTime.Now; BllExchangeRate.ExchangeRateAdd(infoNewExchangeRate); CurrencyBll BllCurrency = new CurrencyBll(); BllCurrency.DefaultCurrencySet(decCurrencyIdForStatus); AfterCompanyCreation(); Clear(); this.Close(); } else { Messages.InformationMessage("Company creation failed"); } } else { Messages.InformationMessage("Companyname already exist"); txtCompanyName.Focus(); } } catch (Exception ex) { MessageBox.Show("CR1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function for Edit /// </summary> public void EditFunction() { try { CompanyInfo infoCompany = new CompanyInfo(); CompanyCreationBll BllCompanyCreation = new CompanyCreationBll(); CompanyPathInfo infoCompanyPath = new CompanyPathInfo(); CompanyPathBll BllCompanyPath = new CompanyPathBll(); UserInfo infoUser = new UserInfo(); UserBll bllUser = new UserBll(); infoCompany.CompanyName = txtCompanyName.Text.Trim(); infoCompany.MailingName = txtMailingName.Text.Trim(); infoCompany.Address = txtAddress.Text.Trim(); infoCompany.Phone = txtPhoneNo.Text.Trim(); infoCompany.Mobile = txtMobile.Text.Trim(); infoCompany.EmailId = txtEmail.Text.Trim(); infoCompany.Web = txtWeb.Text.Trim(); infoCompany.Country = txtCountry.Text.Trim(); infoCompany.State = txtState.Text.Trim(); infoCompany.Pin = txtPincode.Text.Trim(); infoCompany.CurrencyId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()); infoCompany.FinancialYearFrom = Convert.ToDateTime(txtFinancialYearFrom.Text.Trim().ToString()); infoCompany.BooksBeginingFrom = Convert.ToDateTime(txtBooksBegining.Text.Trim().ToString()); infoCompany.Tin = txtTinNo.Text.Trim(); infoCompany.Cst = txtCstNo.Text.Trim(); infoCompany.Pan = txtPanNo.Text.Trim(); infoCompany.CurrentDate = DateTime.Now; infoCompany.Logo = logo; infoCompany.Extra1 = string.Empty; infoCompany.Extra2 = string.Empty; infoCompanyPath.CompanyName = txtCompanyName.Text.Trim(); infoCompanyPath.IsDefault = cbxSetAsDefault.Checked; strPath = Application.StartupPath + "\\Data\\" + PublicVariables._decCurrentCompanyId; infoCompanyPath.CompanyPath = strPath; infoCompanyPath.Extra1 = string.Empty; infoCompanyPath.Extra2 = string.Empty; infoCompanyPath.ExtraDate = DateTime.Now; infoCompanyPath.CompanyId = 1; infoCompany.CompanyId = 1; BllCompanyCreation.CompanyEdit(infoCompany); BllCompanyPath.CompanyPathEdit(infoCompanyPath); Messages.UpdatedMessage(); // To set default currencyId...........In exchangeRate..// ExchangeRateBll BllExchangeRate = new ExchangeRateBll(); ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo(); infoExchangeRate.ExchangeRateId = 1; infoExchangeRate.Date = PublicVariables._dtCurrentDate; infoExchangeRate.CurrencyId = infoCompany.CurrencyId; infoExchangeRate.ExtraDate = PublicVariables._dtCurrentDate; infoExchangeRate.Narration = string.Empty; infoExchangeRate.Rate = 1; infoExchangeRate.Extra1 = string.Empty; infoExchangeRate.Extra2 = string.Empty; BllExchangeRate.ExchangeRateEdit(infoExchangeRate); FinancialYearInfo infoFinancialYear = new FinancialYearInfo(); FinancialYearBll BllFinancialYear = new FinancialYearBll(); decimal decIdentity; infoFinancialYear.FromDate = PublicVariables._dtFromDate; infoFinancialYear.ToDate = PublicVariables._dtToDate; infoFinancialYear.ExtraDate = DateTime.Now; infoFinancialYear.Extra1 = string.Empty; infoFinancialYear.Extra2 = string.Empty; bool isExist = BllFinancialYear.FinancialYearExistenceCheck(PublicVariables._dtFromDate, PublicVariables._dtToDate); if (!isExist) { decIdentity = BllFinancialYear.FinancialYearAddWithReturnIdentity(infoFinancialYear); } //===========Add companyDetails in ExternalDb =====================// decimal decCompanyIdForTemp = PublicVariables._decCurrentCompanyId; PublicVariables._decCurrentCompanyId = 0; CompanyCreationBll bllExCompanyCreation = new CompanyCreationBll(); CompanyPathBll bllExCompanyPath = new CompanyPathBll(); CompanyInfo infoExCompany = new CompanyInfo(); CompanyPathInfo infoExCompanyPath = new CompanyPathInfo(); infoExCompany = infoCompany; infoExCompanyPath = infoCompanyPath; infoExCompany.CompanyId = decCompanyIdForTemp; infoExCompanyPath.CompanyId = decCompanyIdForTemp; bllExCompanyCreation.CompanyEdit(infoExCompany); bllExCompanyPath.CompanyPathEdit(infoExCompanyPath); PublicVariables._decCurrentCompanyId = decCompanyIdForTemp; this.Close(); } catch (Exception ex) { MessageBox.Show("CR2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill controls for Update /// </summary> public void CompanyViewForEdit() { try { isEditMode = true; this.Text = "Edit Company"; btnSave.Text = "Update"; btnDelete.Enabled = true; gbxDetails.Visible = false; txtAdminUserName.ReadOnly = true; txtAdminUserName.BackColor = Color.White; cmbCurrency.Enabled = false; CompanyCreationBll BllCompanyCreation = new CompanyCreationBll(); CompanyInfo infoCompany = new CompanyInfo(); decimal decCompanyId = 1; infoCompany = BllCompanyCreation.CompanyView(PublicVariables._decCurrentCompanyId); txtCompanyName.Text = infoCompany.CompanyName; txtMailingName.Text = infoCompany.MailingName; txtAddress.Text = infoCompany.Address; txtPhoneNo.Text = infoCompany.Phone; txtMobile.Text = infoCompany.Mobile; txtEmail.Text = infoCompany.EmailId; txtWeb.Text = infoCompany.Web; txtCountry.Text = infoCompany.Country; txtState.Text = infoCompany.State; txtPincode.Text = infoCompany.Pin; cmbCurrency.SelectedValue = infoCompany.CurrencyId; txtFinancialYearFrom.Text = infoCompany.FinancialYearFrom.ToString("dd-MMM-yyyy"); dtpFinancialYearFrom.Text = infoCompany.FinancialYearFrom.ToString(); txtBooksBegining.Text = infoCompany.BooksBeginingFrom.ToString("dd-MMM-yyyy"); dtpBooksBegining.Text = infoCompany.BooksBeginingFrom.ToString(); txtTinNo.Text = infoCompany.Tin; txtCstNo.Text = infoCompany.Cst; txtPanNo.Text = infoCompany.Pan; logo = (byte[])infoCompany.Logo; MemoryStream ms = new MemoryStream(logo); Image newimage = Image.FromStream(ms); pbxLogo.Image = newimage; pbxLogo.SizeMode = PictureBoxSizeMode.StretchImage; CompanyPathInfo infoCompanyPath = new CompanyPathInfo(); CompanyPathBll BllComapnyPath = new CompanyPathBll(); infoCompanyPath = BllComapnyPath.CompanyPathView(1); if (infoCompanyPath.IsDefault == true) { cbxSetAsDefault.Checked = true; } else { cbxSetAsDefault.Checked = false; } UserBll bllUser = new UserBll(); UserInfo infoUser = new UserInfo(); decimal decuserId = PublicVariables._decCurrentUserId; infoUser = bllUser.UserView(decuserId); txtAdminUserName.Text = infoUser.UserName; txtPassword.Text = infoUser.Password; txtRetypePassword.Text = infoUser.Password; } catch (Exception ex) { MessageBox.Show("CR8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }