public void LoadGatePassDataGrid() { PrintLogWin.PrintLog("LoadGatePassDataGrid => GlobalVariables.ProgCode ******************** : " + GlobalVariables.ProgCode); try { gridView_GatePassData.Columns.Clear(); string _storedProcedre = SQL_QUERIES.Sp_GatePassData_Daily_List() + " '" + txtEmpCode.EditValue + "', '" + ConvertTo.DateFormatDb(DtDate.EditValue) + "'"; //DataSet ds = ProgramMasterData.GetData(GlobalVariables.ProgCode, _params); DataSet _ds = ProjectFunctionsUtils.GetDataSet(_storedProcedre); if (_ds.Tables[0].Rows.Count > 0) { gridControl_GatePassData.DataSource = _ds.Tables[0]; gridView_GatePassData.BestFitColumns(); //////////////////// PrintPrivewButton.Enabled = true; PrintButton.Enabled = true; } else { gridControl_GatePassData.DataSource = null; } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString().Trim()); } }
private void BtnLogin_Click(object sender, EventArgs e) { try { if (ValidateData()) { DataSet dsCompany = ProjectFunctions.GetDataSet(SQL_QUERIES.SQL_COMCONF_ALL()); DataRow dr = dsCompany.Tables[0].Rows[0]; GlobalVariables.CAddress1 = dr[SQL_COLUMNS.COMCONF._COMADD].ToString(); GlobalVariables.CAddress2 = dr[SQL_COLUMNS.COMCONF._COMADD1].ToString(); GlobalVariables.CAddress3 = dr[SQL_COLUMNS.COMCONF._COMADD2].ToString(); GlobalVariables.CmpGSTNo = dr[SQL_COLUMNS.COMCONF._COMGST].ToString(); GlobalVariables.CompanyName = dr[SQL_COLUMNS.COMCONF._COMNAME].ToString(); GlobalVariables.TelNo = dr[SQL_COLUMNS.COMCONF._COMPHONE].ToString(); GlobalVariables.CmpEmailID = dr[SQL_COLUMNS.COMCONF._COMEID].ToString(); GlobalVariables.CmpZipCode = dr[SQL_COLUMNS.COMCONF._COMZIP].ToString(); GlobalVariables.CmpWebSite = dr[SQL_COLUMNS.COMCONF._COMWEBSITE].ToString(); DataSet dsFY = ProjectFunctions.GetDataSet(SQL_QUERIES.SQL_FN_YEAR(txtFNYear.Text)); DataRow drFY = dsFY.Tables[0].Rows[0]; GlobalVariables.CUnitID = txtUnit.SelectedValue.ToString().PadLeft(2, '0'); GlobalVariables.FinancialYear = drFY[SQL_COLUMNS.FN_YEAR._FNYearCode].ToString(); GlobalVariables.FinYearStartDate = Convert.ToDateTime(drFY[SQL_COLUMNS.FN_YEAR._FNStartDate]).Date; GlobalVariables.FinYearEndDate = Convert.ToDateTime(drFY[SQL_COLUMNS.FN_YEAR._FNEndDate]).Date; GlobalVariables.BarCodePreFix = ProjectFunctions.GetDataSet(SQL_QUERIES.SQL_UNITS(GlobalVariables.CUnitID)).Tables[0].Rows[0][0].ToString(); DataSet dsAPI = ProjectFunctions.GetDataSet("Select * from APIIntegrationSetting Where Active='Y'"); if (dsAPI.Tables[0].Rows.Count > 0) { GlobalVariables.GSPName = dsAPI.Tables[0].Rows[0]["GSPName"].ToString(); GlobalVariables.ASPNetUser = dsAPI.Tables[0].Rows[0]["ASPNetUser"].ToString(); GlobalVariables.ASPPassword = dsAPI.Tables[0].Rows[0]["ASPPassword"].ToString(); GlobalVariables.BaseUrl = dsAPI.Tables[0].Rows[0]["BaseUrl"].ToString(); GlobalVariables.EWBGSTIN = dsAPI.Tables[0].Rows[0]["EWBGSTIN"].ToString(); GlobalVariables.EWBUserID = dsAPI.Tables[0].Rows[0]["EWBUserID"].ToString(); GlobalVariables.EWBPassword = dsAPI.Tables[0].Rows[0]["EWBPassword"].ToString(); GlobalVariables.AuthToken = dsAPI.Tables[0].Rows[0]["EayBillAuthToken"].ToString(); GlobalVariables.AuthTokenTimeStamp = Convert.ToDateTime(dsAPI.Tables[0].Rows[0]["AuthTokenGenDate"]); } WindowsFormsApplication1.XtraForm1 frm = new WindowsFormsApplication1.XtraForm1(); Hide(); ProjectFunctions.Speak("WELCOME TO " + dr[SQL_COLUMNS.COMCONF._COMNAME].ToString() + drFY[SQL_COLUMNS.FN_YEAR._FNYearCode].ToString()); frm.ShowDialog(Parent); frm.BringToFront(); } } catch (Exception ex) { ProjectFunctions.SpeakError(ex.Message); } }
private bool ValidateData() { if (txtUserName.Text.Trim().Length == 0) { ProjectFunctions.SpeakError("Invalid UserName"); txtUserName.Focus(); return(false); } if (txtPassword.Text.Trim().Length == 0) { ProjectFunctions.SpeakError("Invalid Password"); txtPassword.Focus(); return(false); } DataSet dsGetUser = ProjectFunctions.GetDataSet(SQL_QUERIES.SQL_USERMASTER(txtUserName.Text.Trim(), txtPassword.Text.Trim())); if (dsGetUser.Tables[0].Rows.Count > 0) { GlobalVariables.CurrentUser = txtUserName.Text; } else { ProjectFunctions.SpeakError("Invalid Username or Password"); txtUserName.Focus(); return(false); } if (DateTime.Now.Date <= GlobalVariables.LicenseToExpireDate.Date) { if (DateTime.Now.Date >= Convert.ToDateTime("2019-04-1").Date&& DateTime.Now.Date <= Convert.ToDateTime("2026-03-31").Date) { if (Math.Abs((DateTime.Now.Date - GlobalVariables.LicenseToExpireDate.Date).Days) < 30) { ProjectFunctions.SpeakError("Only " + Math.Abs((DateTime.Now.Date - GlobalVariables.LicenseToExpireDate.Date).Days) + " Days Left For License To Expire,Please Recharge Immediately"); } } else { ProjectFunctions.SpeakError("Unauthorised Access"); return(false); } } else { ProjectFunctions.SpeakError("License Has Been Expired"); return(false); } return(true); }
private void TxtUserName_KeyDown(object sender, KeyEventArgs e) { //if (e.KeyCode == Keys.Enter || e.KeyCode == Keys.Tab) { DataSet dsGetUser = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_USERMASTER_BY_USER(txtUserName.Text.Trim())); if (ComparisonUtils.IsNotNull_DataSet(dsGetUser)) { GlobalVariables.CurrentUser = txtUserName.Text; DataSet dsUnit = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_UNITS_BY_USER(txtUserName.Text)); if (ComparisonUtils.IsNotNull_DataSet(dsUnit)) { txtUnit.DataSource = dsUnit.Tables[0]; txtUnit.ValueMember = SQL_COLUMNS.UNITS._UNITID; txtUnit.DisplayMember = SQL_COLUMNS.UNITS._UNITNAME; } DataSet dsFNYear = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_USER_FN_ACCESS_BY_USER(txtUserName.Text)); if (ComparisonUtils.IsNotNull_DataSet(dsFNYear)) { txtFNYear.DataSource = dsFNYear.Tables[0]; txtFNYear.ValueMember = SQL_COLUMNS.FN_YEAR._FNYearCode; txtFNYear.DisplayMember = SQL_COLUMNS.FN_YEAR._FNYearCode; } DataSet dsFNYear2 = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_FN_YEAR_ACTIVE("Y")); if (ComparisonUtils.IsNotNull_DataSet(dsFNYear2)) { txtFNYear.SelectedValue = dsFNYear2.Tables[0].Rows[0]["FNYearCode"].ToString(); //txtFNYear.ValueMember = SQL_COLUMNS.FN_YEAR._FNYearCode; //txtFNYear.DisplayMember = SQL_COLUMNS.FN_YEAR._FNYearCode; } } else { ProjectFunctions.SpeakError("Invalid UserName"); } } }
private void FrmLogincs_Load(object sender, EventArgs e) { if (System.IO.Directory.Exists("C:\\Application")) { } else { System.IO.Directory.CreateDirectory("C:\\Application"); } if (System.IO.Directory.Exists("C:\\Temp")) { } else { System.IO.Directory.CreateDirectory("C:\\Temp"); } if (System.IO.Directory.Exists("C:\\ERP To Busy")) { } else { System.IO.Directory.CreateDirectory("C:\\ERP To Busy"); } if (System.IO.Directory.Exists(Application.StartupPath + "\\PTFile")) { } else { System.IO.Directory.CreateDirectory(Application.StartupPath + "\\PTFile"); } if (System.IO.Directory.Exists(Application.StartupPath + "\\EWAY")) { } else { System.IO.Directory.CreateDirectory(Application.StartupPath + "\\EWAY"); } if (System.IO.Directory.Exists(Application.StartupPath + "\\EWayDetailed")) { } else { System.IO.Directory.CreateDirectory(Application.StartupPath + "\\EWayDetailed"); } if (System.IO.Directory.Exists(Application.StartupPath + "\\LABEL")) { } else { System.IO.Directory.CreateDirectory(Application.StartupPath + "\\LABEL"); } if (System.IO.Directory.Exists(Application.StartupPath + "\\PI")) { } else { System.IO.Directory.CreateDirectory(Application.StartupPath + "\\PI"); } if (System.IO.Directory.Exists(Application.StartupPath + "\\Salary")) { } else { System.IO.Directory.CreateDirectory(Application.StartupPath + "\\salary"); } if (System.IO.Directory.Exists("C:\\Temp\\GST")) { } else { System.IO.Directory.CreateDirectory("C:\\Temp\\GST"); } defaultLookAndFeel1.LookAndFeel.SkinName = "McSkin"; ProjectFunctions.TextBoxVisualize(this); ProjectFunctions.ButtonVisualize(this); SqlConnection cnn = new SqlConnection(ProjectFunctions.ConnectionString); try { cnn.Open(); cnn.Close(); } catch (Exception) { Master.FrmServer frm = new Master.FrmServer(); this.Hide(); frm.ShowDialog(); frm.BringToFront(); return; } DataSet dsCompany = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_COMCONF()); if (ComparisonUtils.IsNotNull_DataSet(dsCompany)) { txtCompany.DataSource = dsCompany.Tables[0]; txtCompany.ValueMember = SQL_COLUMNS.COMCONF._COMSYSID; // "COMSYSID"; txtCompany.DisplayMember = SQL_COLUMNS.COMCONF._COMNAME; // "COMNAME"; } if (isDebug) { //MessageBox.Show(dsFNYear.Tables[0].Rows.Count.ToString()); txtPassword.Text = "123"; txtUserName.Text = "HAPPY"; SendKeys.Send("{Enter}"); txtUserName.Focus(); TxtUserName_KeyDown(null, null); BtnLogin_Click(null, null); } }