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>
/// Function to insert data in tblsalaryPackage
/// </summary>
public void SalaryPackageAdd(SalaryPackageInfo salaryInfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
MySqlCommand sccmd = new MySqlCommand("SalaryPackageAdd", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
MySqlParameter sprmparam = new MySqlParameter();
sprmparam = sccmd.Parameters.Add("?PayHead", MySqlDbType.VarChar);
sprmparam.Value = salaryInfo.PayHead;
sprmparam = sccmd.Parameters.Add("?PayType", MySqlDbType.VarChar);
sprmparam.Value = salaryInfo.PayType;
sprmparam = sccmd.Parameters.Add("?Amount", MySqlDbType.Decimal);
sprmparam.Value = salaryInfo.Amount;
sprmparam = sccmd.Parameters.Add("?IsActive", MySqlDbType.Bit);
sprmparam.Value = salaryInfo.IsActive;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(" attendance sql exception" + ex.Message);
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function to Update values in SalaryPackage Table
/// </summary>
/// <param name="salarypackageinfo"></param>
public void SalaryPackageEdit(SalaryPackageInfo salarypackageinfo)
{
try
{
spSalaryPackage.SalaryPackageEdit(salarypackageinfo);
}
catch (Exception ex)
{
MessageBox.Show("AL2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to insert values to SalaryPackage Table
/// </summary>
/// <param name="salarypackageinfo"></param>
/// <returns></returns>
public decimal SalaryPackageAdd(SalaryPackageInfo salarypackageinfo)
{
decimal decIdentity = -1;
try
{
decIdentity = spSalaryPackage.SalaryPackageAdd(salarypackageinfo);
}
catch (Exception ex)
{
MessageBox.Show("AL2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(decIdentity);
}
/// <summary>
/// Function to get particular values from SalaryPackage table based on the parameter
/// </summary>
/// <param name="salaryPackageId"></param>
/// <returns></returns>
public SalaryPackageInfo SalaryPackageView(decimal salaryPackageId)
{
SalaryPackageInfo salarypackageinfo = new SalaryPackageInfo();
try
{
salarypackageinfo = spSalaryPackage.SalaryPackageView(salaryPackageId);
}
catch (Exception ex)
{
MessageBox.Show("AL2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(salarypackageinfo);
}
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 insert values to SalaryPackage Table
/// </summary>
/// <param name="salarypackageinfo"></param>
/// <returns></returns>
public decimal SalaryPackageAdd(SalaryPackageInfo salarypackageinfo)
{
decimal decIdentity = -1;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("SalaryPackageWithRetunIdentity", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@salaryPackageName", SqlDbType.VarChar);
sprmparam.Value = salarypackageinfo.SalaryPackageName;
sprmparam = sccmd.Parameters.Add("@isActive", SqlDbType.Bit);
sprmparam.Value = salarypackageinfo.IsActive;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = salarypackageinfo.Narration;
sprmparam = sccmd.Parameters.Add("@totalAmount", SqlDbType.Decimal);
sprmparam.Value = salarypackageinfo.TotalAmount;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = salarypackageinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = salarypackageinfo.Extra2;
object obj = sccmd.ExecuteScalar();
if (obj != null)
{
decIdentity = Convert.ToDecimal(obj.ToString());
}
else
{
decIdentity = -1;
}
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
return(decIdentity);
}
/// <summary>
/// Function to get particular values from SalaryPackage table based on the parameter
/// </summary>
/// <param name="salaryPackageId"></param>
/// <returns></returns>
public SalaryPackageInfo SalaryPackageView(decimal salaryPackageId)
{
SalaryPackageInfo salarypackageinfo = new SalaryPackageInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("SalaryPackageView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@salaryPackageId", SqlDbType.Decimal);
sprmparam.Value = salaryPackageId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
salarypackageinfo.SalaryPackageId = Convert.ToDecimal(sdrreader[0].ToString());
salarypackageinfo.SalaryPackageName = sdrreader[1].ToString();
salarypackageinfo.IsActive = Convert.ToBoolean(sdrreader[2].ToString());
salarypackageinfo.Narration = sdrreader[3].ToString();
salarypackageinfo.Extra1 = sdrreader[4].ToString();
salarypackageinfo.Extra2 = sdrreader[5].ToString();
}
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return(salarypackageinfo);
}
/// <summary>
/// Function to Update values in SalaryPackage Table
/// </summary>
/// <param name="salarypackageinfo"></param>
public void SalaryPackageEdit(SalaryPackageInfo salarypackageinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("SalaryPackageEdit", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@salaryPackageId", SqlDbType.Decimal);
sprmparam.Value = salarypackageinfo.SalaryPackageId;
sprmparam = sccmd.Parameters.Add("@salaryPackageName", SqlDbType.VarChar);
sprmparam.Value = salarypackageinfo.SalaryPackageName;
sprmparam = sccmd.Parameters.Add("@isActive", SqlDbType.Bit);
sprmparam.Value = salarypackageinfo.IsActive;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = salarypackageinfo.Narration;
sprmparam = sccmd.Parameters.Add("@totalAmount", SqlDbType.Decimal);
sprmparam.Value = salarypackageinfo.TotalAmount;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = salarypackageinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = salarypackageinfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function to call this form from frmSalaryPackageRegister for updation
/// </summary>
/// <param name="decSalaryPackageIdFromRegister"></param>
/// <param name="frm"></param>
public void CallFromSalaryPackageRegister(decimal decSalaryPackageIdFromRegister, frmSalaryPackageRegister frm)
{
try
{
frmSalaryPackageRegisterObj = frm;
List<DataTable> listObjSalaryPackageDetails = new List<DataTable>();
infoSalaryPackage = BllSalaryPackageCreation.SalaryPackageView(decSalaryPackageIdFromRegister);
decSalaryPackageId = infoSalaryPackage.SalaryPackageId;
txtPackageName.Text = infoSalaryPackage.SalaryPackageName;
strSalaryPackageName = infoSalaryPackage.SalaryPackageName;
txtNarration.Text = infoSalaryPackage.Narration;
listObjSalaryPackageDetails = BllSalaryPackageDetails.SalaryPackageDetailsViewWithSalaryPackageId(decSalaryPackageIdFromRegister);
foreach (DataRow dtblRow in listObjSalaryPackageDetails[0].Rows)
{
if (dtblRow != null)
{
dgvSalaryPackage.Rows.Add();
dgvSalaryPackage.Rows[dgvSalaryPackage.NewRowIndex - 1].Cells["dgvtxtSlNo"].Value = dtblRow["SL.NO"];
dgvSalaryPackage.Rows[dgvSalaryPackage.NewRowIndex - 1].Cells["dgvcmbPayHead"].Value = dtblRow["payHeadId"];
dgvSalaryPackage.Rows[dgvSalaryPackage.NewRowIndex - 1].Cells["dgvtxtAmount"].Value = dtblRow["amount"];
dgvSalaryPackage.Rows[dgvSalaryPackage.NewRowIndex - 1].Cells["dgvtxtStatus"].Value = "Complete";
}
}
btnSave.Text = "Update";
btnDelete.Enabled = true;
base.Show();
if (infoSalaryPackage.IsActive)
{
cmbActive.SelectedIndex = 0;
}
else
{
cmbActive.SelectedIndex = 1;
}
}
catch (Exception ex)
{
MessageBox.Show("SPC2" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
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
}));
}
