public ActionResult GetDailySalarySearch(string voucherDateFrom, string voucherDateTo, string salaryDateFrom, string salaryDateTo, string voucherNo)
{
bool isSuccess = true;
string message = "success";
string jsonResults = "";
try
{
voucherNo = voucherNo ?? string.Empty;
DataTable dtblDailySalaryRegister = new DataTable();
DailySalaryVoucherMasterSP spDailySalaryVoucherMasterSP = new DailySalaryVoucherMasterSP();
dtblDailySalaryRegister = spDailySalaryVoucherMasterSP.DailySalaryRegisterSearch(Convert.ToDateTime(voucherDateFrom), Convert.ToDateTime(voucherDateTo),
Convert.ToDateTime(salaryDateFrom), Convert.ToDateTime(salaryDateTo), voucherNo);
jsonResults = Utils.ConvertDataTabletoString(dtblDailySalaryRegister);
}
catch (Exception ex)
{
isSuccess = false;
message = ex.Message;
}
return(Json(new
{
isSuccess,
message,
data = jsonResults
}));
}
public List <DataTable> DailySalaryRegisterSearch(DateTime dtVoucherDateFrom, DateTime dtVoucherDateTo, DateTime dtSalaryDateFrom, DateTime dtSalaryDateTo, string strInvoiceNo)
{
try
{
return(SpMaster.DailySalaryRegisterSearch(dtVoucherDateFrom, dtVoucherDateTo, dtSalaryDateFrom, dtSalaryDateTo, strInvoiceNo));
}
catch (Exception)
{
throw;
}
}
public List <DataTable> DailySalaryRegisterSearch(DateTime dtVoucherDateFrom, DateTime dtVoucherDateTo, DateTime dtSalaryDateFrom, DateTime dtSalaryDateTo, string strInvoiceNo)
{
List <DataTable> listObj = new List <DataTable>();
try
{
listObj = SpDailySalaryVoucherMaster.DailySalaryRegisterSearch(dtVoucherDateFrom, dtVoucherDateTo, dtSalaryDateFrom, dtSalaryDateTo, strInvoiceNo);
}
catch (Exception ex)
{
MessageBox.Show("DSV7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(listObj);
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
DataTable dtblDailySalaryRegister = new DataTable();
DailySalaryVoucherMasterSP spDailySalaryVoucherMasterSP = new DailySalaryVoucherMasterSP();
dtblDailySalaryRegister = spDailySalaryVoucherMasterSP.DailySalaryRegisterSearch(Convert.ToDateTime(txtVoucherDateFrom.Text.ToString()), Convert.ToDateTime(txtVoucherDateTo.Text.ToString()), Convert.ToDateTime(txtSalaryDateFrom.Text.ToString()), Convert.ToDateTime(txtSalaryDateTo.Text.ToString()), txtVoucherNo.Text);
dgvDailySalaryRegister.DataSource = dtblDailySalaryRegister;
}
catch (Exception ex)
{
MessageBox.Show("DSR2" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}