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