/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
DataTable dtblMonthlySalaryDetails = new DataTable();
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo();
MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP();
MonthlySalaryDetailsInfo infoMonthlySalaryDetailsInfo = new MonthlySalaryDetailsInfo();
dtblMonthlySalaryDetails = spMonthlySalary.MonthlySalarySettingsEmployeeViewAll(Convert.ToDateTime(dtpSalaryMonth.Text));
dgvMonthySalarySettings.DataSource = dtblMonthlySalaryDetails;
int inRowCount = dgvMonthySalarySettings.RowCount;
string strNarration = string.Empty;
for (int i = 0; i < inRowCount; i++)
{
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtnarration"].Value.ToString() != string.Empty)
{
strNarration = dgvMonthySalarySettings.Rows[i].Cells["dgvtxtnarration"].Value.ToString();
}
}
for (int i = 0; i < inRowCount; i++)
{
//select default package for employee
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtdefaultPackageId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtdefaultPackageId"].Value.ToString() != "")
{
dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value = dgvMonthySalarySettings.Rows[i].Cells["dgvtxtdefaultPackageId"].Value;
}
}
txtNarration.Text = strNarration;
}
catch (Exception ex)
{
MessageBox.Show("MSS4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to Update values in MonthlySalary Table
/// </summary>
/// <param name="monthlysalaryinfo"></param>
public void MonthlySalaryEdit(MonthlySalaryInfo monthlysalaryinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("MonthlySalaryEdit", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@monthlySalaryId", SqlDbType.Decimal);
sprmparam.Value = monthlysalaryinfo.MonthlySalaryId;
sprmparam = sccmd.Parameters.Add("@salaryMonth", SqlDbType.DateTime);
sprmparam.Value = monthlysalaryinfo.SalaryMonth;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = monthlysalaryinfo.Narration;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = monthlysalaryinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = monthlysalaryinfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
public void MonthlySalarySettingsEdit(MonthlySalaryInfo monthlysalaryinfo)
{
try
{
SpMonthlySalary.MonthlySalarySettingsEdit(monthlysalaryinfo);
}
catch (Exception ex)
{
MessageBox.Show("MSV:11" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public decimal MonthlySalaryAddWithIdentity(MonthlySalaryInfo monthlysalaryinfo)
{
decimal decResult = 0;
try
{
decResult = SPMonthlySalary.MonthlySalaryAddWithIdentity(monthlysalaryinfo);
}
catch (Exception ex)
{
MessageBox.Show("MS4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(decResult);
}
private DataTable GetMonthlySalarySettingsFromDB(string date)
{
DataTable dtblMonthlySalaryDetails = new DataTable();
try
{
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo();
MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP();
MonthlySalaryDetailsInfo infoMonthlySalaryDetailsInfo = new MonthlySalaryDetailsInfo();
dtblMonthlySalaryDetails = spMonthlySalary.MonthlySalarySettingsEmployeeViewAll(Convert.ToDateTime(date));
}
catch (Exception ex)
{
}
return(dtblMonthlySalaryDetails);
}
/// <summary>
/// Function for Save
/// </summary>
public void SaveFunction()
{
try
{
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo();
MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP();
MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo();
infoMonthlySalary.SalaryMonth = Convert.ToDateTime(dtpSalaryMonth.Text);
infoMonthlySalary.Narration = txtNarration.Text.Trim();
infoMonthlySalary.Extra1 = string.Empty;
infoMonthlySalary.Extra2 = string.Empty;
decMasterIdForEdit = spMonthlySalary.MonthlySalaryAddWithIdentity(infoMonthlySalary);
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
int RowCount = dgvMonthySalarySettings.RowCount;
for (int i = 0; i < RowCount; i++)
{
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString() != string.Empty)
{
infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString());
if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString() != "0")
{
infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString());
infoMonthlySalaryDetails.Extra1 = string.Empty;
infoMonthlySalaryDetails.Extra2 = string.Empty;
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
spMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails);
}
}
}
Messages.SavedMessage();
GridFill();
dtpSalaryMonth.Focus();
btnDelete.Enabled = true;
DeleteButtonEnableDisableChoose();
}
catch (Exception ex)
{
MessageBox.Show("MSS7" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public string SaveMonthlySalarySettings(string month, string tableData)
{
try
{
List <Dictionary <string, object> > items = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(tableData);
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo();
MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP();
MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo();
infoMonthlySalary.SalaryMonth = Convert.ToDateTime(month);
infoMonthlySalary.Narration = string.Empty;
infoMonthlySalary.Extra1 = string.Empty;
infoMonthlySalary.Extra2 = string.Empty;
decimal decMasterIdForEdit = spMonthlySalary.MonthlySalaryAddWithIdentity(infoMonthlySalary);
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
int RowCount = items.Count;
for (int i = 0; i < RowCount; i++)
{
if (items[i]["employeeId"] != null)
{
infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(items[i]["employeeId"]);
if (items[i]["selectedSalaryPackageId"].ToString() != string.Empty && items[i]["selectedSalaryPackageId"].ToString() != "0")
{
infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(items[i]["selectedSalaryPackageId"].ToString());
infoMonthlySalaryDetails.Extra1 = string.Empty;
infoMonthlySalaryDetails.Extra2 = string.Empty;
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
spMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails);
}
}
}
}
catch (Exception ex)
{
return("MSS7" + ex.Message);
}
return("no");
}
/// <summary>
/// Function to get particular values from MonthlySalary Table based on the parameter
/// </summary>
/// <param name="monthlySalaryId"></param>
/// <returns></returns>
public MonthlySalaryInfo MonthlySalaryView(decimal monthlySalaryId)
{
MonthlySalaryInfo monthlysalaryinfo = new MonthlySalaryInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("MonthlySalaryView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@monthlySalaryId", SqlDbType.Decimal);
sprmparam.Value = monthlySalaryId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
monthlysalaryinfo.MonthlySalaryId = Convert.ToDecimal(sdrreader[0].ToString());
monthlysalaryinfo.SalaryMonth = Convert.ToDateTime(sdrreader[1].ToString());
monthlysalaryinfo.Narration = sdrreader[2].ToString();
monthlysalaryinfo.ExtraDate = Convert.ToDateTime(sdrreader[3].ToString());
monthlysalaryinfo.Extra1 = sdrreader[4].ToString();
monthlysalaryinfo.Extra2 = sdrreader[5].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return(monthlysalaryinfo);
}
/// <summary>
/// Function to insert values to MonthlySalary Table and return the Curresponding row's Id
/// </summary>
/// <param name="monthlysalaryinfo"></param>
/// <returns></returns>
public decimal MonthlySalaryAddWithIdentity(MonthlySalaryInfo monthlysalaryinfo)
{
decimal decIdentity = 0;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("MonthlySalaryAddWithIdentity", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@salaryMonth", SqlDbType.DateTime);
sprmparam.Value = monthlysalaryinfo.SalaryMonth;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = monthlysalaryinfo.Narration;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = monthlysalaryinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = monthlysalaryinfo.Extra2;
object obj = sccmd.ExecuteScalar();
if (obj != null)
{
decIdentity = Convert.ToDecimal(obj.ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
return(decIdentity);
}
public void MonthlySalarySettingsEdit(MonthlySalaryInfo monthlysalaryinfo)
{
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("MonthlySalarySettingsEdit", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam6 = new SqlParameter();
sprmparam6 = sccmd.Parameters.Add("@monthlySalaryId", SqlDbType.Decimal);
sprmparam6.Value = monthlysalaryinfo.MonthlySalaryId;
sprmparam6 = sccmd.Parameters.Add("@salaryMonth", SqlDbType.DateTime);
sprmparam6.Value = monthlysalaryinfo.SalaryMonth;
sprmparam6 = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam6.Value = monthlysalaryinfo.Narration;
sprmparam6 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam6.Value = monthlysalaryinfo.Extra1;
sprmparam6 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam6.Value = monthlysalaryinfo.Extra2;
int ineffectedrow = sccmd.ExecuteNonQuery();
if (ineffectedrow > 0)
{
goto end_IL_0001;
}
end_IL_0001 :;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
base.sqlcon.Close();
}
}
/// <summary>
/// Function for Save
/// </summary>
public void SaveFunction()
{
try
{
MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll();
MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo();
MonthlySalaryVoucherBll BllMonthlySalaryDetails = new MonthlySalaryVoucherBll();
MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo();
infoMonthlySalary.SalaryMonth = Convert.ToDateTime(dtpSalaryMonth.Text);
infoMonthlySalary.Narration = txtNarration.Text.Trim();
infoMonthlySalary.Extra1 = string.Empty;
infoMonthlySalary.Extra2 = string.Empty;
decMasterIdForEdit = BllMonthlySalary.MonthlySalaryAddWithIdentity(infoMonthlySalary);
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
int RowCount = dgvMonthySalarySettings.RowCount;
for (int i = 0; i < RowCount; i++)
{
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString() != string.Empty)
{
infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString());
if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString() != "0")
{
infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString());
infoMonthlySalaryDetails.Extra1 = string.Empty;
infoMonthlySalaryDetails.Extra2 = string.Empty;
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
BllMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails);
}
}
}
Messages.SavedMessage();
GridFill();
dtpSalaryMonth.Focus();
btnDelete.Enabled = true;
DeleteButtonEnableDisableChoose();
}
catch (Exception ex)
{
MessageBox.Show("MSS7" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
List<DataTable> ListMonthlySalaryDetails = new List<DataTable>();
MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll();
MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo();
MonthlySalaryVoucherBll BllMonthlySalaryDetails = new MonthlySalaryVoucherBll();
MonthlySalaryDetailsInfo infoMonthlySalaryDetailsInfo = new MonthlySalaryDetailsInfo();
ListMonthlySalaryDetails = BllMonthlySalary.MonthlySalarySettingsEmployeeViewAll(Convert.ToDateTime(dtpSalaryMonth.Text));
dgvMonthySalarySettings.DataSource = ListMonthlySalaryDetails[0];
int inRowCount = dgvMonthySalarySettings.RowCount;
string strNarration = string.Empty;
for (int i = 0; i < inRowCount; i++)
{
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtnarration"].Value.ToString() != string.Empty)
{
strNarration = dgvMonthySalarySettings.Rows[i].Cells["dgvtxtnarration"].Value.ToString();
}
}
for (int i = 0; i < inRowCount; i++)
{
//select default package for employee
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtdefaultPackageId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtdefaultPackageId"].Value.ToString() != "")
{
dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value = dgvMonthySalarySettings.Rows[i].Cells["dgvtxtdefaultPackageId"].Value;
}
}
txtNarration.Text = strNarration;
}
catch (Exception ex)
{
MessageBox.Show("MSS4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for Edit
/// </summary>
public void EditFunction()
{
try
{
MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll();
MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo();
MonthlySalaryVoucherBll BllMonthlySalaryDetails = new MonthlySalaryVoucherBll();
MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo();
EmployeeCreationBll BllEmployeeCreation = new EmployeeCreationBll();
infoMonthlySalary.SalaryMonth = Convert.ToDateTime(dtpSalaryMonth.Text);
infoMonthlySalary.Narration = txtNarration.Text.Trim();
infoMonthlySalary.Extra1 = string.Empty;
infoMonthlySalary.Extra2 = string.Empty;
int RowCount = dgvMonthySalarySettings.RowCount;
for (int i = 0; i <= RowCount - 1; i++)
{
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString() != string.Empty)
{
decMasterIdForEdit = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString());
}
}
infoMonthlySalary.MonthlySalaryId = decMasterIdForEdit;
BllMonthlySalary.MonthlySalarySettingsEdit(infoMonthlySalary);
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
for (int i = 0; i <= RowCount - 1; i++)
{
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString() != string.Empty)
{
string st = dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].FormattedValue.ToString();
if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].FormattedValue.ToString() != "--Select--")
{
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString() != string.Empty)
{
infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString());
}
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString() != string.Empty)
{
infoMonthlySalaryDetails.MonthlySalaryDetailsId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString());
}
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString() != "0")
{
infoMonthlySalaryDetails.MonthlySalaryId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString());
}
if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString() != "0")
{
infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString());
infoMonthlySalaryDetails.Extra1 = string.Empty;
infoMonthlySalaryDetails.Extra2 = string.Empty;
BllEmployeeCreation.EmployeePackageEdit(infoMonthlySalaryDetails.EmployeeId, infoMonthlySalaryDetails.SalaryPackageId);
BllMonthlySalaryDetails.MonthlySalaryDetailsEditUsingMasterIdAndDetailsId(infoMonthlySalaryDetails);
}
}
else
{
decimal decMonthlySalaryDetailsId = 0;
for (int j = 0; j < RowCount; j++)
{
if (dgvMonthySalarySettings.Rows[j].Cells["dgvtxtMonthlySalaryDetailsId"].Value != null && dgvMonthySalarySettings.Rows[j].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString() != string.Empty)
{
if (dgvMonthySalarySettings.Rows[j].Cells["dgvcmbPackage"].FormattedValue.ToString() == "--Select--")
{
decMonthlySalaryDetailsId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[j].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString());
BllMonthlySalaryDetails.MonthlySalarySettingsDetailsIdDelete(decMonthlySalaryDetailsId);
}
}
}
}
}
else
{
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString() != string.Empty)
{
infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString());
if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString() != "0")
{
infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString());
infoMonthlySalaryDetails.Extra1 = string.Empty;
infoMonthlySalaryDetails.Extra2 = string.Empty;
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
BllMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails);
}
}
}
}
Messages.UpdatedMessage();
GridFill();
dtpSalaryMonth.Focus();
btnDelete.Enabled = true;
DeleteButtonEnableDisableChoose();
}
catch (Exception ex)
{
MessageBox.Show("MSS8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for Edit
/// </summary>
public void EditFunction()
{
try
{
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo();
MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP();
MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo();
EmployeeSP spEmployee = new EmployeeSP();
infoMonthlySalary.SalaryMonth = Convert.ToDateTime(dtpSalaryMonth.Text);
infoMonthlySalary.Narration = txtNarration.Text.Trim();
infoMonthlySalary.Extra1 = string.Empty;
infoMonthlySalary.Extra2 = string.Empty;
int RowCount = dgvMonthySalarySettings.RowCount;
for (int i = 0; i <= RowCount - 1; i++)
{
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString() != string.Empty)
{
decMasterIdForEdit = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString());
}
}
infoMonthlySalary.MonthlySalaryId = decMasterIdForEdit;
spMonthlySalary.MonthlySalarySettingsEdit(infoMonthlySalary);
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
for (int i = 0; i <= RowCount - 1; i++)
{
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString() != string.Empty)
{
string st = dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].FormattedValue.ToString();
if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].FormattedValue.ToString() != "--Select--")
{
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString() != string.Empty)
{
infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString());
}
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString() != string.Empty)
{
infoMonthlySalaryDetails.MonthlySalaryDetailsId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString());
}
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString() != "0")
{
infoMonthlySalaryDetails.MonthlySalaryId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString());
}
if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString() != "0")
{
infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString());
infoMonthlySalaryDetails.Extra1 = string.Empty;
infoMonthlySalaryDetails.Extra2 = string.Empty;
spEmployee.EmployeePackageEdit(infoMonthlySalaryDetails.EmployeeId, infoMonthlySalaryDetails.SalaryPackageId);
spMonthlySalaryDetails.MonthlySalaryDetailsEditUsingMasterIdAndDetailsId(infoMonthlySalaryDetails);
}
}
else
{
decimal decMonthlySalaryDetailsId = 0;
for (int j = 0; j < RowCount; j++)
{
if (dgvMonthySalarySettings.Rows[j].Cells["dgvtxtMonthlySalaryDetailsId"].Value != null && dgvMonthySalarySettings.Rows[j].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString() != string.Empty)
{
if (dgvMonthySalarySettings.Rows[j].Cells["dgvcmbPackage"].FormattedValue.ToString() == "--Select--")
{
decMonthlySalaryDetailsId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[j].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString());
spMonthlySalaryDetails.MonthlySalarySettingsDetailsIdDelete(decMonthlySalaryDetailsId);
}
}
}
}
}
else
{
if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString() != string.Empty)
{
infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString());
if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString() != "0")
{
infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString());
infoMonthlySalaryDetails.Extra1 = string.Empty;
infoMonthlySalaryDetails.Extra2 = string.Empty;
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
spMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails);
}
}
}
}
Messages.UpdatedMessage();
GridFill();
dtpSalaryMonth.Focus();
btnDelete.Enabled = true;
DeleteButtonEnableDisableChoose();
}
catch (Exception ex)
{
MessageBox.Show("MSS8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public string EditMonthlySalarySettings(string month, string tableData)
{
try
{
List <Dictionary <string, object> > items = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(tableData);
decimal decMasterIdForEdit = 0;
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo();
MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP();
MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo();
EmployeeSP spEmployee = new EmployeeSP();
infoMonthlySalary.SalaryMonth = Convert.ToDateTime(month);
infoMonthlySalary.Narration = string.Empty;
infoMonthlySalary.Extra1 = string.Empty;
infoMonthlySalary.Extra2 = string.Empty;
int RowCount = items.Count;
for (int i = 0; i < RowCount; i++)
{
if (items[i]["monthlySalaryId"].GetType().Name != "JObject")
{
decMasterIdForEdit = Convert.ToDecimal(items[i]["monthlySalaryId"].ToString());
}
}
infoMonthlySalary.MonthlySalaryId = decMasterIdForEdit;
spMonthlySalary.MonthlySalarySettingsEdit(infoMonthlySalary);
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
for (int i = 0; i <= RowCount - 1; i++)
{
if (items[i]["monthlySalaryDetailsId"].GetType().Name != "JObject")
{
string st = items[i]["selectedSalaryPackageId"].ToString();
if (items[i]["selectedSalaryPackageId"].ToString() != "0")
{
if (items[i]["employeeId"].GetType().Name != "JObject" && items[i]["employeeId"].ToString() != string.Empty)
{
infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(items[i]["employeeId"].ToString());
}
if (items[i]["monthlySalaryDetailsId"].GetType().Name != "JObject" && items[i]["monthlySalaryDetailsId"].ToString() != string.Empty)
{
infoMonthlySalaryDetails.MonthlySalaryDetailsId = Convert.ToDecimal(items[i]["monthlySalaryDetailsId"].ToString());
}
if (items[i]["monthlySalaryId"].GetType().Name != "JObject" && items[i]["monthlySalaryId"].ToString() != "0")
{
infoMonthlySalaryDetails.MonthlySalaryId = Convert.ToDecimal(items[i]["monthlySalaryId"].ToString());
}
if (items[i]["selectedSalaryPackageId"].GetType().Name != "JObject" && items[i]["selectedSalaryPackageId"].ToString() != "0")
{
infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(items[i]["selectedSalaryPackageId"].ToString());
infoMonthlySalaryDetails.Extra1 = string.Empty;
infoMonthlySalaryDetails.Extra2 = string.Empty;
spEmployee.EmployeePackageEdit(infoMonthlySalaryDetails.EmployeeId, infoMonthlySalaryDetails.SalaryPackageId);
spMonthlySalaryDetails.MonthlySalaryDetailsEditUsingMasterIdAndDetailsId(infoMonthlySalaryDetails);
}
}
else
{
decimal decMonthlySalaryDetailsId = 0;
for (int j = 0; j < RowCount; j++)
{
if (items[j]["monthlySalaryDetailsId"].GetType().Name != "JObject" && items[j]["monthlySalaryDetailsId"].ToString() != string.Empty)
{
if (items[j]["selectedSalaryPackageId"].ToString() == "0")
{
decMonthlySalaryDetailsId = Convert.ToDecimal(items[j]["monthlySalaryDetailsId"].ToString());
spMonthlySalaryDetails.MonthlySalarySettingsDetailsIdDelete(decMonthlySalaryDetailsId);
}
}
}
}
}
else
{
if (items[i]["employeeId"].GetType().Name != "JObject" && items[i]["employeeId"].ToString() != string.Empty)
{
infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(items[i]["employeeId"].ToString());
if (items[i]["selectedSalaryPackageId"].GetType().Name != "JObject" && items[i]["selectedSalaryPackageId"].ToString() != "0")
{
infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(items[i]["selectedSalaryPackageId"].ToString());
infoMonthlySalaryDetails.Extra1 = string.Empty;
infoMonthlySalaryDetails.Extra2 = string.Empty;
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
spMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails);
}
}
}
}
}
catch (Exception ex)
{
return("MSS8" + ex.Message);
}
return("no");
}
