/// <summary> /// Function to insert values to SalaryPackageDetails Table /// </summary> /// <param name="salarypackagedetailsinfo"></param> /// <returns></returns> public bool SalaryPackageDetailsAdd(SalaryPackageDetailsInfo salarypackagedetailsinfo) { bool isSave = false; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("SalaryPackageDetailsAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@salaryPackageId", SqlDbType.Decimal); sprmparam.Value = salarypackagedetailsinfo.SalaryPackageId; sprmparam = sccmd.Parameters.Add("@payHeadId", SqlDbType.Decimal); sprmparam.Value = salarypackagedetailsinfo.PayHeadId; sprmparam = sccmd.Parameters.Add("@amount", SqlDbType.Decimal); sprmparam.Value = salarypackagedetailsinfo.Amount; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = salarypackagedetailsinfo.Narration; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = salarypackagedetailsinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = salarypackagedetailsinfo.Extra2; int inValue = sccmd.ExecuteNonQuery(); if (inValue > 0) { isSave = true; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return(isSave); }
/// <summary> /// Function to get particular values from SalaryPackageDetails table based on the parameter /// </summary> /// <param name="salaryPackageDetailsId"></param> /// <returns></returns> public SalaryPackageDetailsInfo SalaryPackageDetailsView(decimal salaryPackageDetailsId) { SalaryPackageDetailsInfo salarypackagedetailsinfo = new SalaryPackageDetailsInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("SalaryPackageDetailsView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@salaryPackageDetailsId", SqlDbType.Decimal); sprmparam.Value = salaryPackageDetailsId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { salarypackagedetailsinfo.SalaryPackageDetailsId = decimal.Parse(sdrreader[0].ToString()); salarypackagedetailsinfo.SalaryPackageId = decimal.Parse(sdrreader[1].ToString()); salarypackagedetailsinfo.PayHeadId = decimal.Parse(sdrreader[2].ToString()); salarypackagedetailsinfo.Amount = decimal.Parse(sdrreader[3].ToString()); salarypackagedetailsinfo.Narration = sdrreader[4].ToString(); salarypackagedetailsinfo.ExtraDate = DateTime.Parse(sdrreader[5].ToString()); salarypackagedetailsinfo.Extra1 = sdrreader[6].ToString(); salarypackagedetailsinfo.Extra2 = sdrreader[7].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return(salarypackagedetailsinfo); }
/// <summary> /// Function to Update values in SalaryPackageDetails Table /// </summary> /// <param name="salarypackagedetailsinfo"></param> public void SalaryPackageDetailsEdit(SalaryPackageDetailsInfo salarypackagedetailsinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("SalaryPackageDetailsEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@salaryPackageDetailsId", SqlDbType.Decimal); sprmparam.Value = salarypackagedetailsinfo.SalaryPackageDetailsId; sprmparam = sccmd.Parameters.Add("@salaryPackageId", SqlDbType.Decimal); sprmparam.Value = salarypackagedetailsinfo.SalaryPackageId; sprmparam = sccmd.Parameters.Add("@payHeadId", SqlDbType.Decimal); sprmparam.Value = salarypackagedetailsinfo.PayHeadId; sprmparam = sccmd.Parameters.Add("@amount", SqlDbType.Decimal); sprmparam.Value = salarypackagedetailsinfo.Amount; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = salarypackagedetailsinfo.Narration; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = salarypackagedetailsinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = salarypackagedetailsinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = salarypackagedetailsinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }