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());
}
}
public static DataSet GetData(string _ProgCode, string _Parameters = "", string version = "")
{
DataSet dsMaster = null;
try
{
//DataSet ds = ProjectFunctionsUtils.GetDataSet("sp_ProgramMaster '" + _ProgCode + "'");
//string ProcedureName = ds.Tables[0].Rows[0]["ProgProcName"].ToString();
ProgramMasterModel storedProcObj = GetProgramMasterModel(_ProgCode);
string ProcedureName = storedProcObj.ProgProcName;
if (!_Parameters.Equals(""))
{
_Parameters = _Parameters.Trim();
_Parameters = " " + _Parameters;
}
System.Diagnostics.Debug.WriteLine("ProcedureName ********** " + ProcedureName + _Parameters);
//PrintLogWin.PrintLog("ProcedureName ********** " + ProcedureName + _Parameters);
dsMaster = ProjectFunctionsUtils.GetDataSet(ProcedureName + version + _Parameters);
}
catch (Exception)
{
//throw;
}
return(dsMaster);
}
private void FillGrid()
{
DataSet dsAccName = ProjectFunctionsUtils.GetDataSet("Select AccCode,AccName,AccCodeBusy from ActMst");
DataSet ds = ProjectFunctionsUtils.GetDataSetBusy("Select Code as AccCodeBusy,Name as AccNameBusy,'' as AccCode,'' as AccName from Master1 where MasterType='2' ");
if (ds.Tables[0].Rows.Count > 0)
{
dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
foreach (DataRow drActMst in dsAccName.Tables[0].Rows)
{
if (dr["AccCodeBusy"].ToString() == drActMst["AccCodeBusy"].ToString())
{
dr["AccCode"] = drActMst["AccCode"].ToString();
dr["AccName"] = drActMst["AccName"].ToString();
}
}
}
AccountGrid.DataSource = dt;
AccountGridView.BestFitColumns();
}
else
{
AccountGrid.DataSource = null;
AccountGridView.BestFitColumns();
}
}
private void SetFormValues(int rowIndex, string _employee_code, string _attendance_date, int _serial_id)
{
try
{
string str = "sp_GatePassData_Single '" + _employee_code + "', '" + ConvertTo.DateFormatDb(ConvertTo.DateTimeVal(_attendance_date)) + "', " + _serial_id + string.Empty;
PrintLogWin.PrintLog(str);
DataSet _ds = ProjectFunctionsUtils.GetDataSet(str);
if (ComparisonUtils.IsNotNull_DataSet(_ds))
{
DataRow dr = _ds.Tables[0].Rows[rowIndex];
DtDate.EditValue = Convert.ToDateTime(dr["AttendanceDate"]);
txtEmpCode.Text = dr["EmpCode"].ToString();
txtEmpCode.Tag = dr["SerialId"].ToString();
txtEmpCodeDesc.Text = dr["EmpName"].ToString();
txtEmpCodeDesc.Tag = dr["DeptDesc"].ToString();
txtStatusCode.Text = dr["StatusCode"].ToString();
txtStatusCode.Tag = dr["UnitName"].ToString();
txtStatusCodeDesc.Text = dr["Status"].ToString();
timeEdit_Time_Out.EditValue = dr["TimeOut"].ToString();
timeEdit_Time_In.EditValue = dr["TimeIn"].ToString();
pictureBox1.Image = ImageUtils.ConvertBinaryToImage((byte[])dr["EmpImage"]);
PrintLogWin.PrintLog("TimeOut " + dr["TimeOut"].ToString());
PrintLogWin.PrintLog("TimeIn " + dr["TimeIn"].ToString());
////////////////////////
/*XtraReportGatePass report = new XtraReportGatePass(
* dr["EmpCode"].ToString(),
* ConvertTo.IntVal(dr["SerialId"].ToString()),
* dr["EmpName"].ToString(),
* dr["DeptDesc"].ToString() + "",
* dr["UnitName"].ToString() + "",
* "",
* dr["Status"].ToString(),
* timeEdit_Time_Out.EditValue + "",
* timeEdit_Time_In.EditValue + "",
* pictureBox1.Image
* );*/
}
else
{
//clear();
}
}
catch (Exception ex)
{
PrintLogWin.PrintLog(ex);
// clear();
}
}
public FrmVouchers()
{
InitializeComponent();
dt.Columns.Add("CRDR", typeof(String));
dt.Columns.Add("AccCode", typeof(String));
dt.Columns.Add("AccName", typeof(String));
dt.Columns.Add("Amount", typeof(Decimal));
dt.Columns.Add("Narration", typeof(String));
dsPopUps = ProjectFunctionsUtils.GetDataSet("sp_LoadVoucherPopUps '" + GlobalVariables.ProgCode + "'");
}
private void BtnImport_Click(object sender, EventArgs e)
{
DataRow currentrow = AccountGridView.GetDataRow(AccountGridView.FocusedRowHandle);
DataSet ds = ProjectFunctionsUtils.GetDataSetBusy("Select * from MasterAddressInfo where MasterCode='" + currentrow["AccCodeBusy"].ToString() + "'");
if (ds.Tables[0].Rows.Count > 0)
{
FrmAccountMstAddEdit frm = new FrmAccountMstAddEdit()
{
S1 = "&Add", Text = "Account Addition"
};
frm.StartPosition = FormStartPosition.CenterScreen;
// only name block
DataSet dsNane = ProjectFunctionsUtils.GetDataSetBusy("Select Code ,Name from MASTER1 Where Code='" + currentrow["AccCodeBusy"].ToString() + "'");
frm.txtAccCodeBusy.Text = dsNane.Tables[0].Rows[0]["Code"].ToString();
frm.txtAccNameBusy.Text = dsNane.Tables[0].Rows[0]["Name"].ToString();
frm.txtAcName.Text = dsNane.Tables[0].Rows[0]["Name"].ToString();
frm.txtBillingName.Text = dsNane.Tables[0].Rows[0]["Name"].ToString();
// only name block
//address block & others
frm.txtAddress1.Text = ds.Tables[0].Rows[0]["Address1"].ToString();
frm.txtAddress2.Text = ds.Tables[0].Rows[0]["Address2"].ToString();
frm.txtAddress3.Text = ds.Tables[0].Rows[0]["Address3"].ToString();
frm.txtAddress4.Text = ds.Tables[0].Rows[0]["Address4"].ToString();
frm.txtZipCode.Text = ds.Tables[0].Rows[0]["PINCode"].ToString();
DataSet dsCity = ProjectFunctions.GetDataSet("SELECT CITYMASTER.CTSYSID, CITYMASTER.CTNAME,STATEMASTER.STNAME,STATEMASTER.UNDERRG FROM CITYMASTER INNER JOIN STATEMASTER ON CITYMASTER.UNDERSTID = STATEMASTER.STSYSID Where CITYMASTER.CTNAME like'%" + ds.Tables[0].Rows[0]["Station"].ToString() + "%'");
if (dsCity.Tables[0].Rows.Count > 0)
{
frm.txtCityCode.Text = dsCity.Tables[0].Rows[0]["CTSYSID"].ToString();
frm.txtCityName.Text = dsCity.Tables[0].Rows[0]["CTNAME"].ToString();
frm.txtState.Text = dsCity.Tables[0].Rows[0]["STNAME"].ToString();
frm.txtCountry.Text = dsCity.Tables[0].Rows[0]["UNDERRG"].ToString();
}
frm.txtTel.Text = ds.Tables[0].Rows[0]["TelNo"].ToString() + "," + ds.Tables[0].Rows[0]["Mobile"].ToString();
frm.txtEmail.Text = ds.Tables[0].Rows[0]["Email"].ToString();
frm.txtTinNo.Text = ds.Tables[0].Rows[0]["TINNo"].ToString();
frm.txtCstPst.Text = ds.Tables[0].Rows[0]["CST"].ToString();
frm.txtPanNo.Text = ds.Tables[0].Rows[0]["ITPAN"].ToString();
frm.txtGSTNo.Text = ds.Tables[0].Rows[0]["GSTNo"].ToString();
frm.txtWhatsAppNo.Text = ds.Tables[0].Rows[0]["WhatsAppNo"].ToString();
//address block
frm.ShowDialog(Parent);
FillGrid();
}
}
private void BtnBestMatch_Click(object sender, EventArgs e)
{
DataSet ds = ProjectFunctionsUtils.GetDataSetBusy("Select Code as MasterCode1,Name as PrintName from MASTER1 Where Name like '%" + txtAcName.Text + "%'");
if (ds.Tables[0].Rows.Count > 0)
{
HelpGrid.Text = "txtAccCodeBusy";
HelpGrid.DataSource = ds.Tables[0];
HelpGrid.BringToFront();
HelpGrid.Show();
HelpGrid.Focus();
HelpGridView.BestFitColumns();
}
}
//private DataSet dsMain;
private void FrmGatePassTimeAddEdit_Load(object sender, EventArgs e)
{
securityPassword = ProjectFunctionsUtils.GetDateChangePassword();
PrintLogWin.PrintLog(securityPassword);
PrintPrivewButton.Enabled = false;
PrintButton.Enabled = false;
SetMyControls();
if (S1 == "Add")
{
//DtDate.Enabled = false;
DtDate.EditValue = DateTime.Now;
//DtDateforMonth.EditValue = DateTime.Now;
//txtAdvanceNo.Text = getNewLoanPassNo().PadLeft(6, '0');
//txtStatusCode.Text = "A";
txtEmpCode.Focus();
}
if (S1 == "Edit")
{
//DtDateforMonth.Enabled = false;
DtDate.Enabled = false;
txtEmpCode.Enabled = false;
DtDate.EditValue = Attendance_date;
txtEmpCode.EditValue = Employee_code;
try
{
SetFormValues(0, Employee_code, Attendance_date, 0);
//if (ComparisonUtils.IsNotNull_DataSet(dsMain))
//{
//gridControl_GatePassData.DataSource = dsMain.Tables[0];
//gridView_GatePassData.BestFitColumns();
//DtDate.EditValue = Convert.ToDateTime(ds.Tables[0].Rows[0]["AttendanceDate"]);
//txtEmpCode.Text = ds.Tables[0].Rows[0]["EmpCode"].ToString();
//txtEmpCodeDesc.Text = ds.Tables[0].Rows[0]["EmpName"].ToString();
//txtStatusCode.Text = ds.Tables[0].Rows[0]["StatusCode"].ToString();
//txtStatusCodeDesc.Text = ds.Tables[0].Rows[0]["Status"].ToString();
//}
}
catch (Exception ex)
{
PrintLogWin.PrintLog(ex);
}
}
}
//private projectFunctionsUtils;
private void Btn_Chnge_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(txtOldPass.Text) || string.IsNullOrWhiteSpace(txtOldPass.Text))
{
ProjectFunctions.SpeakError("Please Enter Old Password.");
txtNewPass.Focus();
return;
}
if (string.IsNullOrEmpty(txtNewPass.Text) || string.IsNullOrWhiteSpace(txtNewPass.Text))
{
ProjectFunctions.SpeakError("Please Enter New Password.");
txtNewPass.Focus();
return;
}
if ((txtNewPass.Text != txtConfirmPass.Text))
{
ProjectFunctions.SpeakError("Password doesn't Match.");
txtOldPass.Focus();
return;
}
var validUserPass = ProjectFunctionsUtils.GetDataSet_T(SQL_QUERIES._frm_Chng_Pswd.SQL_UserMaster(GlobalVariables.CurrentUser, txtConfirmPass.Text));
if (validUserPass.Item1)
{
int intResult = ProjectFunctionsUtils.InsertQuery(SQL_QUERIES._frm_Chng_Pswd.SQL_UserMaster_Update_Pass(GlobalVariables.CurrentUser, txtConfirmPass.Text));//String.Format("Update UserMaster Set UserPwd='{0}' where username='******'", txtConfirmPass.Text, GlobalVariables.CurrentUser)
GlobalVariables.UserPwd = txtConfirmPass.Text;
ProjectFunctions.SpeakError("Password Changed.");
}
else
{
ProjectFunctions.SpeakError("Old Password is Not Valid.");
txtOldPass.Focus();
return;
}
Dispose();
}
catch (Exception ex)
{
ProjectFunctions.SpeakError(ex.Message);
}
}
public FrmJournalVoucher()
{
InitializeComponent();
dt.Columns.Add("CRDR", typeof(String));
dt.Columns.Add("AccCode", typeof(String));
dt.Columns.Add("AccName", typeof(String));
dt.Columns.Add("Debit", typeof(Decimal));
dt.Columns.Add("Credit", typeof(Decimal));
dt.Columns.Add("Narration", typeof(String));
// VoucherGrid.DataSource = dt;
dsPopUps = ProjectFunctionsUtils.GetDataSet("sp_LoadVoucherPopUps '" + GlobalVariables.ProgCode + "'");
}
private string GetNewLoanPassNo()
{
var s2 = string.Empty;
var strsql = string.Empty;
var ds = new DataSet();
strsql = strsql + "select isnull(max(Cast(ExNo as int)),00000) from ExMst";
ds = ProjectFunctionsUtils.GetDataSet(strsql);
if (ds.Tables[0].Rows.Count > 0)
{
s2 = ds.Tables[0].Rows[0][0].ToString().Trim();
s2 = (Convert.ToInt32(s2) + 1).ToString().Trim();
}
return(s2);
}
private void FrmDesignationAddEdit_Load(object sender, EventArgs e)
{
SetMyControls();
if (S1 == "&Add")
{
txtDesc.Focus();
txtDesgCode.Text = ProjectFunctionsUtils.GetNewDesgCode();
}
if (S1 == "Edit")
{
DataSet ds = ProjectFunctions.GetDataSet("SELECT DesgCode, DesgDesc FROM DesgMst Where DesgCode='" + DesgCode + "'");
if (ds.Tables[0].Rows.Count > 0)
{
txtDesgCode.Text = ds.Tables[0].Rows[0]["DesgCode"].ToString();
txtDesc.Text = ds.Tables[0].Rows[0]["DesgDesc"].ToString();
txtDesc.Focus();
}
}
}
private void FillDataToGrid()
{
PrintLogWin.PrintLog("FillGrid ******************** " + GlobalVariables.ProgCode);
try
{
DataSet ds = ProjectFunctions.GetDataSet("Select ProgProcName,ProgDesc from ProgramMaster Where ProgCode='" + GlobalVariables.ProgCode + "'");
string ProcedureName = ds.Tables[0].Rows[0]["ProgProcName"].ToString();
PrintLogWin.PrintLog("FillGrid => ProcedureName ******************** " + ProcedureName);
//ProjectFunctions.BindMasterFormToGrid(ProcedureName, gridControl_UserMaster, gridView_UserMaster);
DataSet dsMaster = ProjectFunctionsUtils.GetDataSet(ProcedureName);
FillTable(dsMaster);
AddUnboundColumn();
AddButtonToGrid();
//userMasterBindingSource.DataSource = Binding_DataHelper.GetData(dsMaster);
//RepositoryItemPictureEdit pictureEdit = new RepositoryItemPictureEdit();
//pictureEdit.SizeMode = PictureSizeMode.Zoom;
//pictureEdit.NullText = " ";
//pictureEdit.Padding = new Padding(1);
//pictureEdit.Click += gridControl_UserMaster_Click
// ;
//gridControl_UserMaster.DataSource = CreateData(dsMaster);
//gridView_UserMaster.Columns["Edit_Link"].ColumnEdit = pictureEdit ;
//gridView_UserMaster.Columns["Edit_Link"].Visible = false;
//GridColumn col = gridView_UserMaster.Columns.AddVisible("Edit", "Edit_Link");
//col.UnboundType = DevExpress.Data.UnboundColumnType.Object;
//col.ColumnEdit = pictureEdit;// repositoryItemPictureEdit1;
//gridView_UserMaster.CustomUnboundColumnData += gridView1_CustomUnboundColumnData;
toolStrip_lbl.Text = ds.Tables[0].Rows[0]["ProgDesc"].ToString();
}
catch (Exception ex)
{
MessageBox_Debug.ShowBox("frmMaster => FillGrid() => " + ex);
}
}
private void FrmDepartmentAddUpdate_Load(object sender, EventArgs e)
{
SetMyControls();
if (S1 == "&Add")
{
txtDesc.Focus();
txtDeptCode.Text = ProjectFunctionsUtils.GetNewDeptCode();//.PadLeft(4, '0');
}
if (S1 == "Edit")
{
//txtDesc.Enabled = false;
DataSet ds = ProjectFunctions.GetDataSet("SELECT DeptCode,DeptDesc,Remarks FROM DeptMst Where DeptCode='" + DeptCode + "'");
//if (ds.Tables[0].Rows.Count > 0)
//{
// txtDeptCode.Text = ds.Tables[0].Rows[0]["DeptCode"].ToString();
// txtDesc.Text = ds.Tables[0].Rows[0]["DeptDesc"].ToString();
// txtRemarks.Text = ds.Tables[0].Rows[0]["Remarks"].ToString();
// txtDesc.Focus();
//}
}
}
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 EmployeeFormData_Load()
{
SetMyControls();
if (S1 == "&Add")
{
chkDailyWage.Checked = true;
chkDailyWage.Checked = false;
chkTeaBreak.Checked = true;
chkTeaBreak.Checked = false;
txtEmpName.Select();
txtEmpCode.Text = ProjectFunctionsUtils.GetNewEmpCode();//.PadLeft(5, '0');
form_loaded = true;
}
if (S1 == "Edit")
{
RepList <EmployeeMasterModel> lista = new RepList <EmployeeMasterModel>();
DynamicParameters param = new DynamicParameters();
param.Add("@EmpCode", EmpCode);
EmployeeMasterModel empData = lista.returnClass_SP(SQL_QUERIES._frmEmployeeMstAddEdit.sp_LoadEmpMstFEditing(), param);
//PrintLogWin.PrintLog("**************** =========> Line 120 => listData => " + listData.Count + "");
if (empData != null)
{
if (empData.EmpTeaTag == "Y")
{
chTeaTag.Checked = true;
}
else
{
chTeaTag.Checked = false;
}
txtEmpCode.Text = empData.EmpCode; // ds.Tables[0].Rows[0]["EmpCode"].ToString();
txtEmpName.Text = empData.EmpName;
txtRelationTag.Text = empData.EmpFHRelationTag; //ds.Tables[0].Rows[0]["EmpFHRelationTag"].ToString();
txtFHName.Text = empData.EmpFHName; //ds.Tables[0].Rows[0]["EmpFHName"].ToString();
txtDeptCode.Text = empData.EmpDeptCode; //ds.Tables[0].Rows[0]["EmpDeptCode"].ToString();
txtDeptDesc.Text = empData.DeptDesc; //ds.Tables[0].Rows[0]["DeptDesc"].ToString();
txtDesgCode.Text = empData.EmpDesgCode; //ds.Tables[0].Rows[0]["EmpDesgCode"].ToString();
txtDesgDesc.Text = empData.DesgDesc; //ds.Tables[0].Rows[0]["DesgDesc"].ToString();
txtUnitCode.Text = empData.UnitCode; //ds.Tables[0].Rows[0]["EmpDesgCode"].ToString();
txtUnitDesc.Text = empData.UnitName; //ds.Tables[0].Rows[0]["DesgDesc"].ToString();
txtEmpSex.Text = empData.EmpSex; //ds.Tables[0].Rows[0]["EmpSex"].ToString();
if (empData.EmpDOJ.ToString() == string.Empty)
{
}
else
{
txtDOJ.EditValue = Convert.ToDateTime(empData.EmpDOJ);
}
if (empData.EmpDOL.ToString() == string.Empty)
{
}
else
{
txtDOL.EditValue = Convert.ToDateTime(empData.EmpDOL);
}
txtEPFTag.Text = empData.EmpPFDTag; //ds.Tables[0].Rows[0]["EmpPFDTag"].ToString();
txtESIDTag.Text = empData.EmpESIDTag; //ds.Tables[0].Rows[0]["EmpESIDTag"].ToString();
txtEPFNo.Text = empData.EmpPFno; //ds.Tables[0].Rows[0]["EmpPFno"].ToString();
txtESICNo.Text = empData.EmpESIno; //ds.Tables[0].Rows[0]["EmpESIno"].ToString();
txtTDS.Text = empData.EmpTDS.ToString(); //ds.Tables[0].Rows[0]["EmpTDS"].ToString();
txtEmpLeft.Text = empData.EmpLeft; //ds.Tables[0].Rows[0]["EmpLeft"].ToString();
txtRemarks.Text = empData.EmpRemarks; //ds.Tables[0].Rows[0]["EmpRemarks"].ToString();
txtMotherName.Text = empData.EmpMotherNm; //ds.Tables[0].Rows[0]["EmpMotherNm"].ToString();
txtState.Text = empData.EmpPerState; //ds.Tables[0].Rows[0]["EmpPerState"].ToString();
txtState.Text = empData.EmpPerCountry; //ds.Tables[0].Rows[0]["EmpPerCountry"].ToString();
txtNationality.Text = empData.EmpNationality; //ds.Tables[0].Rows[0]["EmpNationality"].ToString();
txtEmail.Text = empData.EmpEmail; //ds.Tables[0].Rows[0]["EmpEmail"].ToString();
txtCategoryCode.Text = empData.EmpCategory; //ds.Tables[0].Rows[0]["EmpCategory"].ToString();
txtCategoryDesc.Text = empData.CatgDesc; //ds.Tables[0].Rows[0]["CatgDesc"].ToString();
txtDOB.EditValue = Convert.ToDateTime(empData.EmpDoB);
txtPanNo.Text = empData.EmpPanNo; //ds.Tables[0].Rows[0]["EmpPanNo"].ToString();
txtPassPortNo.Text = empData.EmpPassportNo; //ds.Tables[0].Rows[0]["EmpPassportNo"].ToString();
txtEmployeeReligion.Text = empData.EmpReligion; //ds.Tables[0].Rows[0]["EmpReligion"].ToString();
txtMaritalStatus.Text = empData.EmpMaritalStatus; //ds.Tables[0].Rows[0]["EmpMaritalStatus"].ToString();
txtPaymentMode.Text = empData.EmpPymtMode; //ds.Tables[0].Rows[0]["EmpPymtMode"].ToString();
txtIfscCode.Text = empData.EmpBankIFSCode; //ds.Tables[0].Rows[0]["EmpBankIFSCode"].ToString();
txtBankAccountNo.Text = empData.EmpBankAcNo; //ds.Tables[0].Rows[0]["EmpBankAcNo"].ToString();
txtBankName.Text = empData.EmpBankName; //ds.Tables[0].Rows[0]["EmpBankName"].ToString();
txtNomineeName.Text = empData.EmpNominee; //ds.Tables[0].Rows[0]["EmpNominee"].ToString();
txtNomineeRelation.Text = empData.EmpNomineeRelation; //ds.Tables[0].Rows[0]["EmpNomineeRelation"].ToString();
if (empData.EmpNomineeDOB.ToString() == string.Empty)
{
}
else
{
txtNomineeDOB.EditValue = Convert.ToDateTime(empData.EmpNomineeDOB);
}
txtAdharCardNo.Text = empData.EmpAdharCardNo; //ds.Tables[0].Rows[0]["EmpAdharCardNo"].ToString();
txtHealthInsurance.Text = empData.EmpGHISDed.ToString(); //ds.Tables[0].Rows[0]["EmpGHISDed"].ToString();
txtMiscDed.Text = empData.EmpMscD1.ToString(); //ds.Tables[0].Rows[0]["EmpMscD1"].ToString();
txtAddress1.Text = empData.EmpAddress1; //ds.Tables[0].Rows[0]["EmpAddress1"].ToString();
txtAddress2.Text = empData.EmpAddress2; //ds.Tables[0].Rows[0]["EmpAddress2"].ToString();
txtAddress3.Text = empData.EmpAddress3; //ds.Tables[0].Rows[0]["EmpAddress3"].ToString();
txtState.Text = empData.EmpState; //ds.Tables[0].Rows[0]["EmpState"].ToString();
txtCountry.Text = empData.EmpCountry; //ds.Tables[0].Rows[0]["EmpCountry"].ToString();
txtEFPFTag.Text = empData.EmpFpfDTag; //ds.Tables[0].Rows[0]["EmpFpfDTag"].ToString();
//NULL Exception
//txtUANNo.Text = ds.Tables[0].Rows[0]["EmpUANNo"].ToString();
//txtUnitCode.Text = ds.Tables[0].Rows[0]["UnitCode"].ToString();
//txtUnitName.Text = ds.Tables[0].Rows[0]["UnitName"].ToString();
//txtAccCode.Text = ds.Tables[0].Rows[0]["EmpPartyCode"].ToString();
//txtBankBranchCode.Text = ds.Tables[0].Rows[0]["EmpBankBranchCode"].ToString();
txtCategoryCode.Focus();
timeEdit_Time_In_First.EditValue = empData.TimeInFirst.ToString();
timeEdit_Time_Out_First.EditValue = empData.TimeOutFirst.ToString();
timeEdit_Time_In_Last.EditValue = empData.TimeInLast.ToString();
timeEdit_Time_Out_Last.EditValue = empData.TimeOutLast.ToString();
totalWorkingHours_Text.EditValue = empData.WorkingHours;
pictureBox1.Image = ConvertBinaryToImage(empData.EmpImage);
chkTeaBreak.Checked = (empData.TeaBreak == 1) ? true : false;
txtTeaBreakTime.EditValue = empData.TeaBreakTime;
PrintLogWin.PrintLog("chkTeaBreak.Checked =========> " + chkTeaBreak.Checked + string.Empty);
PrintLogWin.PrintLog("empData.TeaBreak =========> " + empData.TeaBreak + string.Empty);
chkDailyWage.Checked = empData.DailyWage;
PrintLogWin.PrintLog("chkDailyWage.Checked =========> " + chkDailyWage.Checked + string.Empty);
PrintLogWin.PrintLog("empData.DailyWage =========> " + empData.DailyWage + string.Empty);
//DAILY WAGER//////////////////////////////
if (chkDailyWage.Checked)
{
if (empData.DailyWageRate != null && empData.DailyWageRate != 0)
{
txtDailyWageRate.EditValue = empData.DailyWageRate;
txtDailyWageRate.Tag = empData.DailyWageRate;
}
else
{
txtDailyWageRate.EditValue = null;
}
if (empData.DailyWageMinutes != null && empData.DailyWageMinutes != 0)
{
txtDailyWageHours.EditValue = empData.DailyWageMinutes / 60;
txtDailyWageHours.Tag = empData.DailyWageMinutes / 60;
}
else
{
txtDailyWageHours.EditValue = null;
}
}
else
{
txtDailyWageRate.Enabled = false;
txtDailyWageRate.EditValue = null;
txtDailyWageHours.Enabled = false;
txtDailyWageHours.EditValue = null;
}
//TEA BREAK//////////////////////////////
if (chkTeaBreak.Checked)
{
if (empData.TeaBreakTime != null && empData.TeaBreakTime != 0)
{
txtTeaBreakTime.EditValue = empData.TeaBreakTime;
txtTeaBreakTime.Tag = empData.TeaBreakTime;
}
else
{
txtTeaBreakTime.EditValue = null;
}
}
else
{
txtTeaBreakTime.Enabled = false;
txtTeaBreakTime.EditValue = null;
}
}
form_loaded = true;
txtEmpName.Enabled = false;
PrintLogWin.PrintLog("frmEmployeeMstAddEdit_Load =========> Line 131 => sp_LoadEmpMstFEditing '" + EmpCode + "'");
}
}
public static void Roles(string ProgCode, string CurrentUser,
ToolStripButton btnAdd,
ToolStripButton btnEdit = null,
ToolStripButton btnDelete = null,
ToolStripButton btnPrint = null)
{
string Query4Controls = string.Format("SELECT ProgAdd_F, ProgUpd_F, ProgDel_F, ProgRep_p, ProgRep_p,ProgSpl_U FROM UserProgAccess WHERE (ProgActive is Null or progActive= 'Y') AND (ProgCode = N'" + ProgCode + "') AND (UserName = N'{0}'); ", CurrentUser);
using (var Tempds = ProjectFunctionsUtils.GetDataSet(Query4Controls))
{
if (Tempds != null)
{
if (Tempds.Tables[0].Rows.Count > 0)
{
if (btnAdd != null)
{
if (Tempds.Tables[0].Rows[0]["ProgAdd_F"].ToString() == "-1")
{
btnAdd.Enabled = true;
}
else
{
btnAdd.Enabled = false;
}
}
if (btnEdit != null)
{
if (Tempds.Tables[0].Rows[0]["ProgUpd_F"].ToString() == "-1")
{
btnEdit.Enabled = true;
}
else
{
btnEdit.Enabled = false;
}
}
if (btnDelete != null)
{
if (Tempds.Tables[0].Rows[0]["ProgDel_F"].ToString() == "-1")
{
btnDelete.Enabled = true;
}
else
{
btnDelete.Enabled = false;
}
}
if (btnPrint != null)
{
if (Tempds.Tables[0].Rows[0]["ProgRep_p"].ToString() == "-1")
{
btnPrint.Enabled = true;
}
else
{
btnPrint.Enabled = false;
}
}
}
}
}
}
private void HelpGrid_DoubleClick(object sender, EventArgs e)
{
try
{
DataRow row = HelpGridView.GetDataRow(HelpGridView.FocusedRowHandle);
if (HelpGrid.Text == "txtAccCodeBusy")
{
txtAccCodeBusy.Text = row["MasterCode1"].ToString();
txtAccNameBusy.Text = row["PRINTNAME"].ToString();
HelpGrid.Visible = false;
txtAccCodeBusy.Focus();
if (chImportAll.Checked)
{
DataSet ds = ProjectFunctionsUtils.GetDataSetBusy("Select * from MasterAddressInfo where MasterCode='" + txtAccCodeBusy.Text + "'");
if (ds.Tables[0].Rows.Count > 0)
{
txtAcName.Text = txtAccNameBusy.Text;
txtBillingName.Text = txtAccNameBusy.Text;
txtAddress1.Text = ds.Tables[0].Rows[0]["Address1"].ToString();
txtAddress2.Text = ds.Tables[0].Rows[0]["Address2"].ToString();
txtAddress3.Text = ds.Tables[0].Rows[0]["Address3"].ToString();
txtAddress4.Text = ds.Tables[0].Rows[0]["Address4"].ToString();
txtZipCode.Text = ds.Tables[0].Rows[0]["PINCode"].ToString();
DataSet dsCity = ProjectFunctions.GetDataSet("SELECT CITYMASTER.CTSYSID, CITYMASTER.CTNAME,STATEMASTER.STNAME,STATEMASTER.UNDERRG FROM CITYMASTER INNER JOIN STATEMASTER ON CITYMASTER.UNDERSTID = STATEMASTER.STSYSID Where CITYMASTER.CTNAME like'%" + ds.Tables[0].Rows[0]["Station"].ToString() + "%'");
if (dsCity.Tables[0].Rows.Count > 0)
{
txtCityCode.Text = dsCity.Tables[0].Rows[0]["CTSYSID"].ToString();
txtCityName.Text = dsCity.Tables[0].Rows[0]["CTNAME"].ToString();
txtState.Text = dsCity.Tables[0].Rows[0]["STNAME"].ToString();
txtCountry.Text = dsCity.Tables[0].Rows[0]["UNDERRG"].ToString();
}
txtTel.Text = ds.Tables[0].Rows[0]["TelNo"].ToString() + "," + ds.Tables[0].Rows[0]["Mobile"].ToString();
txtEmail.Text = ds.Tables[0].Rows[0]["Email"].ToString();
txtTinNo.Text = ds.Tables[0].Rows[0]["TINNo"].ToString();
txtCstPst.Text = ds.Tables[0].Rows[0]["CST"].ToString();
txtPanNo.Text = ds.Tables[0].Rows[0]["ITPAN"].ToString();
txtGSTNo.Text = ds.Tables[0].Rows[0]["GSTNo"].ToString();
txtWhatsAppNo.Text = ds.Tables[0].Rows[0]["WhatsAppNo"].ToString();
}
}
}
if (HelpGrid.Text == "txtSLCode")
{
txtSLCode.Text = row["LgrCode"].ToString();
txtSLDesc.Text = row["LgrDesc"].ToString();
HelpGrid.Visible = false;
txtBSCode.Focus();
}
if (HelpGrid.Text == "txtBSCode")
{
txtBSCode.Text = row["BSCode"].ToString();
txtBSDesc.Text = row["BSDesc"].ToString();
HelpGrid.Visible = false;
txtBSCode.Focus();
}
if (HelpGrid.Text == "txtMainLedgerCode")
{
txtMainLedgerCode.Text = row["GrpCode"].ToString();
txtMainLedgerDesc.Text = row["GrpDesc"].ToString();
txtSubLedgerCode.Text = row["GrpSubCode"].ToString();
txtSubLedgerDesc.Text = row["GrpSubDesc"].ToString();
HelpGrid.Visible = false;
txtBSCode.Focus();
}
if (HelpGrid.Text == "txtEmpCode")
{
txtEmpCode.Text = row["EmpCode"].ToString();
txtEmpName.Text = row["EmpName"].ToString();
HelpGrid.Visible = false;
txtChequeName.Focus();
}
if (HelpGrid.Text == "txtGSTStateCode")
{
txtGSTStateCode.Text = row["GSTStateCode"].ToString();
txtGSTStateDesc.Text = row["GSTStateDesc"].ToString();
HelpGrid.Visible = false;
txtChequeName.Focus();
}
if (HelpGrid.Text == "txtCityCode")
{
txtCityCode.Text = row["CTSYSID"].ToString();
txtCityName.Text = row["CTNAME"].ToString();
txtState.Text = row["STNAME"].ToString();
txtCountry.Text = row["UNDERRG"].ToString();
HelpGrid.Visible = false;
txtContactPerson.Focus();
}
if (HelpGrid.Text == "txtAgentCode")
{
txtAgentCode.Text = row["AgentCode"].ToString();
txtAgentName.Text = row["AgentName"].ToString();
HelpGrid.Visible = false;
txtAgentCode.Focus();
}
if (HelpGrid.Text == "txtUnitCode")
{
txtUnitCode.Text = row["UNITID"].ToString();
txtUnitName.Text = row["UNITNAME"].ToString();
HelpGrid.Visible = false;
txtUnitCode.Focus();
}
if (HelpGrid.Text == "txtDelCitycode")
{
txtDelCitycode.Text = row["CTSYSID"].ToString();
txtDelCityName.Text = row["CTNAME"].ToString();
HelpGrid.Visible = false;
txtDelGSTNo.Focus();
}
}
catch (Exception ex)
{
ProjectFunctions.SpeakError(ex.Message);
}
}
private void SetGridViewStyle()
{
gridView_Style_List = ProjectFunctionsUtils.GridView_Style("frmProcessSalary", "gridControl_SalaryProcess");
if (gridView_Style_List != null)
{
int rowIndex = 0;
foreach (GridColumn Col in gridView_SalaryProcess.Columns)
{
try
{
if (gridView_Style_List.Exists(x => x.column_name.Equals(Col.FieldName)))
{
GridView_Style_Model item = gridView_Style_List.Single <GridView_Style_Model>(x => x.column_name.Equals(Col.FieldName));
bool colShow = true;
try
{
if (ComparisonUtils.IsNotEmpty(item.column_show))
{
if (item.column_show == 0)
{
colShow = false;
Col.Visible = false;
//gridView_SalaryProcess.Columns[Col.FieldName].Visible = false;
}
else
{
colShow = true;
Col.Visible = true;
//gridView_SalaryProcess.Columns[Col.FieldName].Visible = true;
}
}
}
catch (Exception ex)
{
PrintLogWin.PrintLog("SetGridViewStyle => Color => Exception => " + ex);
}
if (colShow)
{
try
{
if (ComparisonUtils.IsNotEmpty(item.color_code))
{
string hex = item.color_code;
Color color = System.Drawing.ColorTranslator.FromHtml(hex);
Col.AppearanceCell.BackColor = color;
}
}
catch (Exception ex)
{
PrintLogWin.PrintLog("SetGridViewStyle => Color => Exception => " + ex);
}
try
{
if (ComparisonUtils.IsNotEmpty(item.font_style))
{
if (item.font_style.ToLower().Equals("bold"))
{
Col.AppearanceCell.FontStyleDelta = FontStyle.Bold;
}
if (item.font_style.ToLower().Equals("Italic"))
{
Col.AppearanceCell.FontStyleDelta = FontStyle.Italic;
}
}
}
catch (Exception ex)
{
PrintLogWin.PrintLog("SetGridViewStyle => FontStyle => Exception => " + ex);
}
}
}
}
catch (Exception ex)
{
PrintLogWin.PrintLog("SetGridViewStyle => Exception => " + ex);
}
if (Col.FieldName == "SalaryLocked")
{
}
rowIndex++;
}
}
}
private void FillGrid()
{
ClearGrid();
//DECLARE @Salary_Month DATETIME = '2020-06-01 00:00:00';
var str = "sp_Salary_Process '','" + ConvertTo.DateFormatDb(ConvertTo.DateTimeVal(DtStartDate.EditValue)) + "', 1, 1,'1','" + txtteatrate.Text + "','0'";
PrintLogWin.PrintLog(str);
DataSet ds = ProjectFunctionsUtils.GetDataSet(str);
ds.Tables[0].Columns.Add(new DataColumn("Balance_1", typeof(double)));
ds.Tables[0].Columns.Add(new DataColumn("Arrears_1", typeof(double)));
ds.Tables[0].Columns.Add(new DataColumn("Loan_1", typeof(double)));
ds.Tables[0].Columns.Add(new DataColumn("SalaryCalculated_1", typeof(double)));
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
ds.Tables[0].Rows[i]["Balance_1"] = ConvertTo.DoubleVal(ds.Tables[0].Rows[i]["Balance"]);
ds.Tables[0].Rows[i]["Arrears_1"] = ds.Tables[0].Rows[i]["Arrears"];
ds.Tables[0].Rows[i]["Loan_1"] = ds.Tables[0].Rows[i]["Loan"];
ds.Tables[0].Rows[i]["SalaryCalculated_1"] = ds.Tables[0].Rows[i]["SalaryCalculated"];
}
if (ComparisonUtils.IsNotNull_DataSet(ds))
{
if (ds.Tables[0].Rows.Count > 0)
{
gridControl_SalaryProcess.DataSource = ds.Tables[0];
gridView_SalaryProcess.BestFitColumns();
gridView_SalaryProcess.Columns["EmpSalary"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "EmpSalary", string.Empty);
gridView_SalaryProcess.Columns["SalaryEarned"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "SalaryEarned", string.Empty);
gridView_SalaryProcess.Columns["OT_Salary"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "OT_Salary", string.Empty);
gridView_SalaryProcess.Columns["DeductionSalary"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "DeductionSalary", string.Empty);
gridView_SalaryProcess.Columns["SalaryGenerateBasic"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "SalaryGenerateBasic", string.Empty);
gridView_SalaryProcess.Columns["AdvanceSalary"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "AdvanceSalary", string.Empty);
object p = gridView_SalaryProcess.Columns["Loan"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "Loan", string.Empty);
gridView_SalaryProcess.Columns["SalaryCalculated"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "SalaryCalculated", string.Empty);
gridView_SalaryProcess.Columns["SalaryPaid"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "SalaryPaid", string.Empty);
gridView_SalaryProcess.Columns["Balance"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "Balance", string.Empty);
gridView_SalaryProcess.Columns["Arrears"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "Arrears", string.Empty);
gridView_SalaryProcess.Columns["TotalTeaAmount"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "TotalTeaAmount", string.Empty);
//gridView_SalaryProcess.Columns["EmpSalary"].Summary.Add(DevExpress.Data.SummaryItemType.Custom);
gridView_SalaryProcess.UpdateTotalSummary();
}
}
else
{
}
gridView_SalaryProcess.OptionsBehavior.Editable = true;
foreach (DevExpress.XtraGrid.Columns.GridColumn Col in gridView_SalaryProcess.Columns)
{
if (Col.FieldName == "LoanIntsallment" || Col.FieldName == "SalaryPaid" || Col.FieldName == "Loan" || Col.FieldName == "NoOfCups")
{
}
else
{
Col.OptionsColumn.AllowEdit = false;
}
}
SetGridViewStyle();
}
private void FrmAdvanceAddEdit_Load(object sender, EventArgs e)
{
SetMyControls();
if (S1 == "Add")
{
DtDate.Enabled = true;
DtDate.EditValue = DateTime.Now;
DtDateforMonth.EditValue = DateTime.Now;
txtAdvanceNo.Text = GetNewLoanPassNo().PadLeft(6, '0');
txtType.Text = "A";
DtDate.Focus();
}
if (S1 == "Edit")
{
DtDateforMonth.Enabled = false;
DtDate.Enabled = false;
txtType.Enabled = false;
string str = "SELECT "
+ " ExMst.ExPostHead, "
+ " ExMst.ExVoucherType, "
+ " ExMst.ExVoucherNo, "
+ " ExMst.ExVoucherDt, "
+ " ExMst.ExNo, "
+ " ExMst.ExId, "
+ " ExMst.ExDate, "
+ " ExMst.ExEmpCode, "
+ " ExMst.ExAmt, "
+ " ExMst.ExTag, "
+ " ExMst.ExDatePost, "
+ " ExMst.ExLoadTag, "
+ " ExMst.ExEmpCCode, "
+ " ExMst.ExFedDate, "
+ " ExMst.ExLoadedDate, "
+ " empmst.EmpName, "
+ " actmst.AccName "
+ " FROM ExMst "
+ " LEFT OUTER JOIN EmpMST ON ExMst.ExEmpCode = empmst.EmpCode "
+ " LEFT OUTER JOIN ActMst ON ExMst.ExPostHead = actmst.AccCode "
+ " WHERE ExId='" + ExId + "';" +
string.Empty;
//var qr = " SELECT ExMst.ExPostHead, ExMst.ExVoucherType, ExMst.ExVoucherNo, ExMst.ExVoucherDt, ExMst.ExNo, ExMst.ExId, ExMst.ExDate, ExMst.ExEmpCode, ExMst.ExAmt, ExMst.ExTag, ExMst.ExDatePost, ";
//qr = qr + " ExMst.ExLoadTag, ExMst.ExEmpCCode, ExMst.ExFedDate, ExMst.ExLoadedDate, empmst.EmpName, EmpEmplrRef.ERMDesc, actmst.AccName ";
//qr = qr + " FROM ExMst LEFT OUTER JOIN ";
//qr = qr + " empmst ON ExMst.ExEmpCode = empmst.EmpCode LEFT OUTER JOIN ";
//qr = qr + " EmpEmplrRef ON ExMst.ExEmpCCode = EmpEmplrRef.ERMCode LEFT OUTER JOIN ";
//qr = qr + " actmst ON ExMst.ExPostHead = actmst.AccCode ";
//qr = qr + " WHERE ExId='" + ExId + "'";
PrintLogWin.PrintLog(str);
var ds = ProjectFunctionsUtils.GetDataSet(str);
try
{
txtAdvanceNo.Text = ds.Tables[0].Rows[0]["ExNo"].ToString();
DtDate.EditValue = Convert.ToDateTime(ds.Tables[0].Rows[0]["ExDate"]);
DtDateforMonth.EditValue = Convert.ToDateTime(ds.Tables[0].Rows[0]["ExDatePost"]);
txtEmpCode.Text = ds.Tables[0].Rows[0]["ExEmpCode"].ToString();
txtEmpCodeDesc.Text = ds.Tables[0].Rows[0]["EmpName"].ToString();
txtType.Text = ds.Tables[0].Rows[0]["ExTag"].ToString();
txtAmount.Text = ds.Tables[0].Rows[0]["ExAmt"].ToString();
}
catch (Exception ex)
{
PrintLogWin.PrintLog(ex);
}
//GetBasicDetail();
}
}
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);
}
}
