public ActionResult Employee()
{
ViewData["nowDate"] = DateTime.UtcNow.ToString("yyyy-MM-dd");
DataTable dtblDesignation = GetDesignationFromDB();
if (dtblDesignation.Rows.Count > 0)
{
DataRow drRow = dtblDesignation.NewRow();
drRow["designationId"] = "0";
drRow["designationName"] = "All";
dtblDesignation.Rows.InsertAt(drRow, 0);
}
ViewData["designations"] = dtblDesignation;
DataTable dtblSalaryPackages = new SalaryPackageSP().SalaryPackageViewAllForActive();
ViewData["salaryPackages"] = dtblSalaryPackages;
EmployeeInfo infoEmployee = new EmployeeInfo();
infoEmployee.EmployeeCode = "";
infoEmployee.EmployeeName = "";
infoEmployee.DesignationId = 0;
infoEmployee.SalaryType = "All";
infoEmployee.BankAccountNumber = "";
infoEmployee.PassportNo = "";
infoEmployee.LabourCardNumber = "";
infoEmployee.VisaNumber = "";
DataTable dtblEmployees = SearchEmployeesFromDB(infoEmployee);
return(View(dtblEmployees));
}
public JsonResult GetSalaryPackageDetails(string salaryPackageId)
{
int nSalaryPackageId = int.Parse(salaryPackageId);
SalaryPackageSP spSalaryPackage = new SalaryPackageSP();
SalaryPackageDetailsSP spSalaryPackageDetils = new SalaryPackageDetailsSP();
SalaryPackageInfo infoSalaryPackage = new SalaryPackageInfo();
string jsonDetails = "";
if (nSalaryPackageId > 0)
{
infoSalaryPackage = spSalaryPackage.SalaryPackageView(nSalaryPackageId);
DataTable dtblSalaryPackageDetails = spSalaryPackageDetils.SalaryPackageDetailsViewWithSalaryPackageId(nSalaryPackageId);
jsonDetails = Utils.ConvertDataTabletoString(dtblSalaryPackageDetails);
}
PayHeadSP spPayhead = new PayHeadSP();
DataTable dtblPayheads = spPayhead.PayHeadViewAll();
string jsonPayheads = Utils.ConvertDataTabletoString(dtblPayheads);
return(Json(new
{
isSuccess = true,
message = "success",
data = new
{
salaryPackageId = infoSalaryPackage.SalaryPackageId,
salaryPackageName = infoSalaryPackage.SalaryPackageName,
narration = infoSalaryPackage.Narration,
isActive = infoSalaryPackage.IsActive,
salaryPackageDetails = jsonDetails,
payHeads = jsonPayheads
}
}));
}
/// <summary>
/// On 'Print' button click to print
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dgvSalaryPackage.RowCount > 0)
{
frmReport frmreport = new frmReport();
DataSet ds = new DataSet();
SalaryPackageSP spSalaryPackage = new SalaryPackageSP();
CompanySP spCompany = new CompanySP();
DataTable dtblSalaryPackage = spSalaryPackage.SalaryPackageViewAllForSalaryPackageReport(cmbPackageName.Text, cmbStatus.Text);
DataTable dtblCompany = spCompany.CompanyViewDataTable(1);
ds.Tables.Add(dtblSalaryPackage);
ds.Tables.Add(dtblCompany);
frmreport.MdiParent = formMDI.MDIObj;
frmreport.SalaryPackageReport(ds);
}
else
{
Messages.InformationMessage("No data found");
}
}
catch (Exception ex)
{
MessageBox.Show("SPD:9 " + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public JsonResult DeleteSalaryPackage(string salaryPackageId)
{
int nSalaryPackageId = int.Parse(salaryPackageId);
SalaryPackageSP spSalaryPackage = new SalaryPackageSP();
spSalaryPackage.SalaryPackageDeleteAll(nSalaryPackageId);
return(Json(new
{
isSuccess = true,
message = "success",
}));
}
private DataTable SalaryPackageSearchFromDB(string packageName, string status)
{
try
{
SalaryPackageSP spSalarayPackage = new SalaryPackageSP();
DataTable dtbl = spSalarayPackage.SalaryPackageregisterSearch(packageName, status);
return(dtbl);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
SalaryPackageSP spSalaryPackage = new SalaryPackageSP();
DataTable dtbl = spSalaryPackage.SalaryPackageViewAllForSalaryPackageReport(cmbPackageName.Text, cmbStatus.Text);
dgvSalaryPackage.DataSource = dtbl;
}
catch (Exception ex)
{
MessageBox.Show("SPD:2 " + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void SaveFunction()
{
try
{
SalaryPackageInfo salaryInfo = new SalaryPackageInfo();
SalaryPackageSP salarySp = new SalaryPackageSP();
for (int i = 0; i < dgvSalaryPackage.RowCount - 1; i++)
{
if (dgvSalaryPackage.Rows[i].Cells["dgvPayHead"].Value.ToString() != string.Empty && dgvSalaryPackage.Rows[i].Cells["dgvPayHead"].Value != null)
{
salaryInfo.PayHead = Convert.ToString(dgvSalaryPackage.Rows[i].Cells["dgvPayHead"].Value);
}
if (dgvSalaryPackage.Rows[i].Cells["dgvPayType"].Value.ToString() != string.Empty && dgvSalaryPackage.Rows[i].Cells["dgvPayType"].Value != null)
{
salaryInfo.PayType = Convert.ToString(dgvSalaryPackage.Rows[i].Cells["dgvPayType"].Value);
}
if (dgvSalaryPackage.Rows[i].Cells["dgvAmount"].Value.ToString() != string.Empty && dgvSalaryPackage.Rows[i].Cells["dgvAmount"].Value != null)
{
salaryInfo.Amount = Convert.ToDecimal(dgvSalaryPackage.Rows[i].Cells["dgvAmount"].Value);
}
bool isCellChecked = (bool)dgvSalaryPackage.Rows[i].Cells["dgvtxtIsActive"].Value;
if (isCellChecked == true)
{
salaryInfo.IsActive = true;
}
else
{
salaryInfo.IsActive = false;
}
salarySp.SalaryPackageAdd(salaryInfo);
}
clearfielsd();
Messages.SavedMessage();
}
catch (Exception ex)
{
MessageBox.Show(" SaveFunction " + ex.Message);
}
}
/// <summary>
/// Function to fill SalaryPackage combobox
/// </summary>
public void SalaryPackageComboFill()
{
try
{
SalaryPackageSP spSalaryPackage = new SalaryPackageSP();
DataTable dtbl = spSalaryPackage.SalaryPackageViewAll();
DataRow dr = dtbl.NewRow();
dr[1] = "All";
dtbl.Rows.InsertAt(dr, 0);
cmbSalaryPackage.DataSource = dtbl;
cmbSalaryPackage.ValueMember = "salaryPackageId";
cmbSalaryPackage.DisplayMember = "salaryPackageName";
}
catch (Exception ex)
{
MessageBox.Show("SPDR:2" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
string strCmbName = string.Empty;
try
{
SalaryPackageSP spSalaryPackage = new SalaryPackageSP();
DataTable dtblSalaryPackage = new DataTable();
if (cmbStatus.Text == "Yes")
{
strCmbName = "True";
}
else if (cmbStatus.Text == "No")
{
strCmbName = "False";
}
else
{
strCmbName = "All";
}
dtblSalaryPackage = spSalaryPackage.SalaryPackageregisterSearch(txtPackageName.Text.Trim(), strCmbName);
dgvSalaryPackageRegister.DataSource = dtblSalaryPackage;
int inRowCount = dgvSalaryPackageRegister.RowCount;
for (int i = 0; i < inRowCount; i++)
{
if (dgvSalaryPackageRegister.Rows[i].Cells["dgvtxtActive"].Value.ToString() == "1")
{
dgvSalaryPackageRegister.Rows[i].Cells["dgvtxtActive"].Value = "Yes";
}
if (dgvSalaryPackageRegister.Rows[i].Cells["dgvtxtActive"].Value.ToString() == "0")
{
dgvSalaryPackageRegister.Rows[i].Cells["dgvtxtActive"].Value = "No";
}
}
}
catch (Exception ex)
{
MessageBox.Show("SPR1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Package combobox in Datagridview
/// </summary>
public void SalaryPackageComboFill()
{
try
{
DataTable dtblSalaryPackage = new DataTable();
SalaryPackageSP spSalaryPackage = new SalaryPackageSP();
dtblSalaryPackage = spSalaryPackage.SalaryPackageViewAllForMonthlySalarySettings();
DataRow dr = dtblSalaryPackage.NewRow();
dr[0] = "0";
dr[1] = "--Select--";
dtblSalaryPackage.Rows.InsertAt(dr, 0);
dgvcmbPackage.DataSource = dtblSalaryPackage;
dgvcmbPackage.ValueMember = "salaryPackageId";
dgvcmbPackage.DisplayMember = "salaryPackageName";
}
catch (Exception ex)
{
MessageBox.Show("MSS2" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public JsonResult SalaryPackageViewAllForActive()
{
bool isSave = true;
string message = "success";
string jsonResults = "";
try
{
SalaryPackageSP spSalaryPackage = new SalaryPackageSP();
DataTable dtblSalaryPackage = new DataTable();
dtblSalaryPackage = spSalaryPackage.SalaryPackageViewAllForActive();
jsonResults = Utils.ConvertDataTabletoString(dtblSalaryPackage);
}
catch (Exception ex)
{
message = ex.Message;
}
return(Json(new {
isSuccess = isSave,
messaage = message,
data = jsonResults
}));
}
public ActionResult GetMonthlySalarySettingsDetails(string month)
{
DataTable dtMonthly = GetMonthlySalarySettingsFromDB(month);
DataTable dtblSalaryPackage = new DataTable();
SalaryPackageSP spSalaryPackage = new SalaryPackageSP();
dtblSalaryPackage = spSalaryPackage.SalaryPackageViewAllForMonthlySalarySettings();
string jsonTableData = Utils.ConvertDataTabletoString(dtMonthly);
string jsonComboData = Utils.ConvertDataTabletoString(dtblSalaryPackage);
string jsonBtnStatus = string.Empty;
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
if (spMonthlySalary.MonthlySalarySettingsMonthlySalaryIdSearchUsingSalaryMonth(Convert.ToDateTime(month)) > 0)
{
jsonBtnStatus = "Update";
}
else
{
jsonBtnStatus = "Save";
}
return(Json(new { success = "true", tableData = jsonTableData, comboData = jsonComboData, btnStatus = jsonBtnStatus }));
}
public JsonResult SaveSalaryPackage(string salaryPackageId, string salaryPackageName, string active, string narration, string jsonDetails, string totalAmount)
{
bool isSave = true;
string message = "success";
SalaryPackageInfo infoSalaryPackage = new SalaryPackageInfo();
try
{
SalaryPackageSP spSalaryPackage = new SalaryPackageSP();
SalaryPackageDetailsSP spSalaryPackageDetails = new SalaryPackageDetailsSP();
int nSalaryPackageId = int.Parse(salaryPackageId);
float fTotalAmount = float.Parse(totalAmount);
bool isActive = bool.Parse(active);
infoSalaryPackage.SalaryPackageId = nSalaryPackageId;
infoSalaryPackage.SalaryPackageName = salaryPackageName;
infoSalaryPackage.Narration = narration;
infoSalaryPackage.Extra1 = string.Empty;
infoSalaryPackage.Extra2 = string.Empty;
infoSalaryPackage.IsActive = isActive;
infoSalaryPackage.TotalAmount = Convert.ToDecimal(totalAmount);
if (nSalaryPackageId > 0) // edit mode
{
spSalaryPackage.SalaryPackageEdit(infoSalaryPackage);
spSalaryPackageDetails.SalaryPackageDetailsDeleteWithSalaryPackageId(nSalaryPackageId);
isSave = SavePayHeadDetails(spSalaryPackageDetails, jsonDetails, nSalaryPackageId);
if (!isSave)
{
spSalaryPackage.SalaryPackageDeleteAll(nSalaryPackageId);
}
}
else
{
nSalaryPackageId = (int)spSalaryPackage.SalaryPackageAdd(infoSalaryPackage);
if (nSalaryPackageId != -1)
{
infoSalaryPackage.SalaryPackageId = nSalaryPackageId;
isSave = SavePayHeadDetails(spSalaryPackageDetails, jsonDetails, nSalaryPackageId);
if (!isSave)
{
spSalaryPackage.SalaryPackageDeleteAll(nSalaryPackageId);
}
}
else
{
message = "Package name already exists";
}
}
}
catch (Exception ex)
{
message = ex.Message;
}
return(Json(new {
isSuccess = isSave,
messaage = message,
data = infoSalaryPackage
}));
}
