private bool SavePayHeadDetails(SalaryPackageDetailsSP spSalaryPackageDetails, string jsonDetails, int nSalaryPackageId)
{
bool isSave = false;
try
{
List <Dictionary <string, object> > items = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(jsonDetails);
for (int i = 0; i < items.Count; i++)
{
SalaryPackageDetailsInfo infoSalaryPackageDetails = new SalaryPackageDetailsInfo();
infoSalaryPackageDetails.PayHeadId = Convert.ToDecimal(items[i]["payHeadId"]);
infoSalaryPackageDetails.Amount = Convert.ToDecimal(items[i]["Amount"]);
infoSalaryPackageDetails.Narration = items[i]["Narration"].ToString();
infoSalaryPackageDetails.SalaryPackageId = nSalaryPackageId;
infoSalaryPackageDetails.Extra1 = string.Empty;
infoSalaryPackageDetails.Extra2 = string.Empty;
if (spSalaryPackageDetails.SalaryPackageDetailsAdd(infoSalaryPackageDetails))
{
isSave = true;
}
else
{
isSave = false;
break;
}
}
}
catch (Exception ex)
{
isSave = false;
}
return(isSave);
}
/// <summary>
/// Function to insert values to SalaryPackageDetails Table
/// </summary>
/// <param name="salarypackagedetailsinfo"></param>
/// <returns></returns>
public bool SalaryPackageDetailsAdd(SalaryPackageDetailsInfo salarypackagedetailsinfo)
{
bool isSave = false;
try
{
isSave = spSalaryPackageDetails.SalaryPackageDetailsAdd(salarypackagedetailsinfo);
}
catch (Exception ex)
{
MessageBox.Show("AL2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(isSave);
}
public bool SalaryPackageDetailsAdd(SalaryPackageDetailsInfo salarypackagedetailsinfo)
{
bool isSave = false;
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("SalaryPackageDetailsAdd", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam7 = new SqlParameter();
sprmparam7 = sccmd.Parameters.Add("@salaryPackageId", SqlDbType.Decimal);
sprmparam7.Value = salarypackagedetailsinfo.SalaryPackageId;
sprmparam7 = sccmd.Parameters.Add("@payHeadId", SqlDbType.Decimal);
sprmparam7.Value = salarypackagedetailsinfo.PayHeadId;
sprmparam7 = sccmd.Parameters.Add("@amount", SqlDbType.Decimal);
sprmparam7.Value = salarypackagedetailsinfo.Amount;
sprmparam7 = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam7.Value = salarypackagedetailsinfo.Narration;
sprmparam7 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam7.Value = salarypackagedetailsinfo.Extra1;
sprmparam7 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam7.Value = salarypackagedetailsinfo.Extra2;
int inValue = sccmd.ExecuteNonQuery();
if (inValue > 0)
{
isSave = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
base.sqlcon.Close();
}
return(isSave);
}
public SalaryPackageDetailsInfo SalaryPackageDetailsView(decimal salaryPackageDetailsId)
{
SalaryPackageDetailsInfo salarypackagedetailsinfo = new SalaryPackageDetailsInfo();
SqlDataReader sdrreader = null;
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("SalaryPackageDetailsView", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam2 = new SqlParameter();
sprmparam2 = sccmd.Parameters.Add("@salaryPackageDetailsId", SqlDbType.Decimal);
sprmparam2.Value = salaryPackageDetailsId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
salarypackagedetailsinfo.SalaryPackageDetailsId = decimal.Parse(((DbDataReader)sdrreader)[0].ToString());
salarypackagedetailsinfo.SalaryPackageId = decimal.Parse(((DbDataReader)sdrreader)[1].ToString());
salarypackagedetailsinfo.PayHeadId = decimal.Parse(((DbDataReader)sdrreader)[2].ToString());
salarypackagedetailsinfo.Amount = decimal.Parse(((DbDataReader)sdrreader)[3].ToString());
salarypackagedetailsinfo.Narration = ((DbDataReader)sdrreader)[4].ToString();
salarypackagedetailsinfo.ExtraDate = DateTime.Parse(((DbDataReader)sdrreader)[5].ToString());
salarypackagedetailsinfo.Extra1 = ((DbDataReader)sdrreader)[6].ToString();
salarypackagedetailsinfo.Extra2 = ((DbDataReader)sdrreader)[7].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
base.sqlcon.Close();
}
return(salarypackagedetailsinfo);
}
public void SalaryPackageDetailsEdit(SalaryPackageDetailsInfo salarypackagedetailsinfo)
{
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("SalaryPackageDetailsEdit", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam9 = new SqlParameter();
sprmparam9 = sccmd.Parameters.Add("@salaryPackageDetailsId", SqlDbType.Decimal);
sprmparam9.Value = salarypackagedetailsinfo.SalaryPackageDetailsId;
sprmparam9 = sccmd.Parameters.Add("@salaryPackageId", SqlDbType.Decimal);
sprmparam9.Value = salarypackagedetailsinfo.SalaryPackageId;
sprmparam9 = sccmd.Parameters.Add("@payHeadId", SqlDbType.Decimal);
sprmparam9.Value = salarypackagedetailsinfo.PayHeadId;
sprmparam9 = sccmd.Parameters.Add("@amount", SqlDbType.Decimal);
sprmparam9.Value = salarypackagedetailsinfo.Amount;
sprmparam9 = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam9.Value = salarypackagedetailsinfo.Narration;
sprmparam9 = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
sprmparam9.Value = salarypackagedetailsinfo.ExtraDate;
sprmparam9 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam9.Value = salarypackagedetailsinfo.Extra1;
sprmparam9 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam9.Value = salarypackagedetailsinfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
base.sqlcon.Close();
}
}
