/// <summary> /// To set the from date and todate in the curresponding feilds /// </summary> public void FinancialYearDate() { try { dtpFromDate.MinDate = PublicVariables._dtFromDate; dtpFromDate.MaxDate = PublicVariables._dtToDate; CompanyInfo infoComapany = new CompanyInfo(); CompanySP spCompany = new CompanySP(); infoComapany = spCompany.CompanyView(1); DateTime dtFromDate = infoComapany.CurrentDate; dtpFromDate.Value = dtFromDate; dtpFromDate.Text = dtFromDate.ToString("dd-MMM-yyyy"); dtpFromDate.Value = Convert.ToDateTime(txtFromDate.Text); txtFromDate.Focus(); txtFromDate.SelectAll(); dtpToDate.MinDate = PublicVariables._dtFromDate; dtpToDate.MaxDate = PublicVariables._dtToDate; infoComapany = spCompany.CompanyView(1); DateTime dtToDate = infoComapany.CurrentDate; dtpToDate.Value = dtToDate; dtpToDate.Text = dtToDate.ToString("dd-MMM-yyyy"); dtpToDate.Value = Convert.ToDateTime(txtToDate.Text); txtToDate.Focus(); txtToDate.SelectAll(); } catch (Exception ex) { formMDI.infoError.ErrorString = "DRNTREP4:" + ex.Message; } }
/// <summary> /// Start a login /// </summary> public void Login() { try { UserSP spUser = new UserSP(); CompanySP spCompany = new CompanySP(); CompanyInfo infoCompany = new CompanyInfo(); string strUserName = txtUserName.Text.Trim(); string strPassword = spUser.LoginCheck(strUserName); if (strPassword == txtPassword.Text.Trim() && strPassword != string.Empty) { int inUserId = spUser.GetUserIdAfterLogin(strUserName, strPassword); PublicVariables._decCurrentUserId = inUserId; infoCompany = spCompany.CompanyView(1); PublicVariables._decCurrencyId = infoCompany.CurrencyId; formMDI.MDIObj.CallFromLogin(); SettingsCheck(); //for Quock Launch menu formMDI.MDIObj.ShowQuickLaunchMenu(); formMDI.MDIObj.CurrentSettings(); //Display ChangeCurrentDate form// frmChangeCurrentDate frmCurrentDateChangeObj = new frmChangeCurrentDate(); frmCurrentDateChangeObj.MdiParent = formMDI.MDIObj; frmCurrentDateChangeObj.CallFromLogin(this); formMDI.MDIObj.Text = "Oneaccount " + infoCompany.CompanyName + " [ " + PublicVariables._dtFromDate.ToString("dd-MMM-yyyy") + " To " + PublicVariables._dtToDate.ToString("dd-MMM-yyyy") + " ]"; // For showing the Oneaccount message from the website formMDI.MDIObj.logoutToolStripMenuItem.Enabled = true; if (PublicVariables.MessageToShow != string.Empty) { frmMessage frmMsg = new frmMessage(); frmMsg.lblHeading.Text = PublicVariables.MessageHeadear; frmMsg.lblMessage.Text = PublicVariables.MessageToShow; frmMsg.MdiParent = formMDI.MDIObj; frmMsg.Show(); frmMsg.Location = new Point(0, formMDI.MDIObj.Height - 270); foreach (Form form in Application.OpenForms) { if (form.GetType() == typeof(frmChangeCurrentDate)) { form.Focus(); } } } } else { lblError.Visible = true; Clear(); } } catch (Exception ex) { formMDI.infoError.ErrorString = "LOGIN1:" + ex.Message; } }
/// <summary> /// To Display the company name in text box /// </summary> public void txtcompanynamefill() { try { CompanySP spcompany = new CompanySP(); CompanyInfo infoCompany = new CompanyInfo(); infoCompany = spcompany.CompanyView(1); string strCompanyName = infoCompany.CompanyName; txtShowCompanyName.Text = strCompanyName; txtShowCompanyName.ReadOnly = true; } catch (Exception ex) { formMDI.infoError.ErrorString = "BS3:" + ex.Message; } }
/// <summary> /// To set current date /// </summary> public void CurrentDate() { try { dtpCompanyCurrentDate.MinDate = PublicVariables._dtFromDate; dtpCompanyCurrentDate.MaxDate = PublicVariables._dtToDate; CompanyInfo infoComapany = new CompanyInfo(); CompanySP spCompany = new CompanySP(); infoComapany = spCompany.CompanyView(1); DateTime dtCurrentDate = PublicVariables._dtFromDate; if (infoComapany.CurrentDate != null) { dtCurrentDate = infoComapany.CurrentDate; } if (dtCurrentDate > PublicVariables._dtToDate) { dtCurrentDate = PublicVariables._dtToDate; } if (dtCurrentDate < PublicVariables._dtFromDate) { dtCurrentDate = PublicVariables._dtFromDate; } dtpCompanyCurrentDate.Value = dtCurrentDate; PublicVariables._dtCurrentDate = dtCurrentDate; DateTime sysDate = System.DateTime.Today; if (sysDate >= PublicVariables._dtFromDate && sysDate <= PublicVariables._dtToDate) { txtCompanyCurrentdate.Text = sysDate.ToString("dd-MMM-yyyy"); } else { txtCompanyCurrentdate.Text = dtCurrentDate.ToString("dd-MMM-yyyy"); } dtpCompanyCurrentDate.Value = Convert.ToDateTime(txtCompanyCurrentdate.Text); txtCompanyCurrentdate.Focus(); txtCompanyCurrentdate.SelectAll(); } catch (Exception ex) { formMDI.infoError.ErrorString = "CCD 3 : " + ex.Message; } }
/// <summary> /// Function to Get the Current Date /// </summary> public void CurrentDate() { try { CompanyInfo infoComapany = new CompanyInfo(); CompanySP spCompany = new CompanySP(); FinancialYearInfo infoFinancialYear = new FinancialYearInfo(); FinancialYearSP spFinancialYear = new FinancialYearSP(); infoComapany = spCompany.CompanyView(1); PublicVariables._dtCurrentDate = infoComapany.CurrentDate; infoFinancialYear = spFinancialYear.FinancialYearView(1); PublicVariables._dtFromDate = infoFinancialYear.FromDate; PublicVariables._dtToDate = infoFinancialYear.ToDate; } catch (Exception ex) { formMDI.infoError.ErrorString = "SELCMPNY : 2" + ex.Message; } }
/// <summary> /// Changing company's financial year /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSelect_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Are you sure you want to change the financial year?", "Oneaccount", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { FinancialYearInfo infoFinancialYear = new FinancialYearInfo(); FinancialYearSP spFinancialYear = new FinancialYearSP(); decimal decFinacialId = Convert.ToDecimal(dgvChangeFinancialYear.CurrentRow.Cells["dgvtxtfinancialYearId"].Value); DateTime dtmFromDate = Convert.ToDateTime(dgvChangeFinancialYear.CurrentRow.Cells["dgvtxtFromDate"].Value); DateTime dtmToDate = Convert.ToDateTime(dgvChangeFinancialYear.CurrentRow.Cells["dgvtxtToDate"].Value); PublicVariables._decCurrentFinancialYearId = decFinacialId; PublicVariables._dtFromDate = dtmFromDate; PublicVariables._dtToDate = dtmToDate; DateTime dtGetCurrentdate = DateTime.Now; CompanySP spCompany = new CompanySP(); spCompany.CompanyCurrentDateEdit(dtmFromDate); if (dtGetCurrentdate < dtmFromDate) { PublicVariables._dtCurrentDate = dtmFromDate; spCompany.CompanyCurrentDateEdit(dtmFromDate); formMDI.MDIObj.ShowCurrentDate(); } else { PublicVariables._dtCurrentDate = dtGetCurrentdate; spCompany.CompanyCurrentDateEdit(dtmFromDate); formMDI.MDIObj.ShowCurrentDate(); } CompanyInfo infoCompany = new CompanyInfo(); infoCompany = spCompany.CompanyView(1); formMDI.MDIObj.Text = "Oneaccount " + infoCompany.CompanyName + " [ " + PublicVariables._dtFromDate.ToString("dd-MMM-yyyy") + " To " + PublicVariables._dtToDate.ToString("dd-MMM-yyyy") + " ]"; this.Close(); } } catch (Exception ex) { formMDI.infoError.ErrorString = "CHGFINYR:5" + ex.Message; } }
/// <summary> /// Function for Start the thread /// </summary> private void threadStart() { try { CompanySP spCompany = new CompanySP(); CompanyInfo infoCompany = new CompanyInfo(); try { infoCompany = spCompany.CompanyView(1); } catch (Exception) { } MailMessage mailMsg = new MailMessage(); mailMsg.From = ""; mailMsg.To = ""; mailMsg.Subject = "Oneaccount MsSql Error!" + " Version : " + Application.ProductVersion; mailMsg.BodyFormat = MailFormat.Text; mailMsg.Body = infoCompany.EmailId + " - " + txtError.Text; mailMsg.Priority = MailPriority.High; SmtpMail.SmtpServer = "smtp.gmail.com";//smtp is :smtp.gmail.com // SmtpMail.SmtpServer = "plus.smtp.mail.yahoo.com";//smtp is :smtp.yahoo.com mailMsg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "1"); mailMsg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", ""); mailMsg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendpassword", ""); // - smtp.gmail.com use port 465 or 587 // - plus.smtp.mail.yahoo.com use port 465 or 587 mailMsg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpserverport", "465"); mailMsg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpusessl", "true"); SmtpMail.Send(mailMsg); Cursor.Current = Cursors.Default; this.Invoke(new MethodInvoker(delegate { this.Close(); })); } catch { } }
/// <summary> /// Setting the check box Status /// </summary> public void FillSettings() { try { BarcodeSettingsInfo Info = new BarcodeSettingsSP().BarcodeSettingsView(1); if (Info.ShowMRP == true) { cbxShowMrp.Checked = true; } else { cbxShowMrp.Checked = false; } if (Info.ShowProductCode == true) { rbtnShowProductCode.Checked = true; } else { rbtnShowProductName.Checked = true; } if (Info.ShowCompanyName == true) { cbxShowCompanyNAmeAs.Checked = true; } else { cbxShowCompanyNAmeAs.Checked = false; } if (Info.ShowPurchaseRate == true) { cbxShowPurchaseRate.Checked = true; } else { cbxShowPurchaseRate.Checked = false; } txtShowCompanyName.Text = Info.CompanyName; if (txtShowCompanyName.Text == string.Empty) { CompanyInfo InfoCompany = new CompanyInfo(); CompanySP Sp = new CompanySP(); InfoCompany = Sp.CompanyView(1); txtShowCompanyName.Text = InfoCompany.CompanyName; } txtZero.Text = Info.Zero; txtOne.Text = Info.One; txtTwo.Text = Info.Two; txtThree.Text = Info.Three; txtFour.Text = Info.Four; txtFive.Text = Info.Five; txtSix.Text = Info.Six; txtSeven.Text = Info.Seven; txtEight.Text = Info.Eight; txtNine.Text = Info.Nine; txtPoint.Text = Info.Point; } catch (Exception ex) { formMDI.infoError.ErrorString = "BS4:" + ex.Message; } }