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();
}
}
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 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 + "'");
}
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 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 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 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();
}
}
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 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);
}
}