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