/// <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);
}
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);
}
}
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
}));
}