public static HR_ProvidentFundSetup GetHR_ProvidentFundSetupByProvidentFundSetupID(int ProvidentFundSetupID)
{
HR_ProvidentFundSetup hR_ProvidentFundSetup = new HR_ProvidentFundSetup();
SqlHR_ProvidentFundSetupProvider sqlHR_ProvidentFundSetupProvider = new SqlHR_ProvidentFundSetupProvider();
hR_ProvidentFundSetup = sqlHR_ProvidentFundSetupProvider.GetHR_ProvidentFundSetupByProvidentFundSetupID(ProvidentFundSetupID);
return hR_ProvidentFundSetup;
}
public static int InsertHR_ProvidentFundSetup(HR_ProvidentFundSetup hR_ProvidentFundSetup)
{
SqlHR_ProvidentFundSetupProvider sqlHR_ProvidentFundSetupProvider = new SqlHR_ProvidentFundSetupProvider();
return sqlHR_ProvidentFundSetupProvider.InsertHR_ProvidentFundSetup(hR_ProvidentFundSetup);
}
public bool UpdateHR_ProvidentFundSetup(HR_ProvidentFundSetup hR_ProvidentFundSetup)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_ProvidentFundSetup", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ProvidentFundSetupID", SqlDbType.Int).Value = hR_ProvidentFundSetup.ProvidentFundSetupID;
cmd.Parameters.Add("@ServiceLenStartYear", SqlDbType.Int).Value = hR_ProvidentFundSetup.ServiceLenStartYear;
cmd.Parameters.Add("@ServiceLenEndYear", SqlDbType.Int).Value = hR_ProvidentFundSetup.ServiceLenEndYear;
cmd.Parameters.Add("@FundTypeID", SqlDbType.Int).Value = hR_ProvidentFundSetup.FundTypeID;
cmd.Parameters.Add("@FundPercentForEmp", SqlDbType.Float).Value = hR_ProvidentFundSetup.FundPercentForEmp;
cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = string.Empty; //hR_ProvidentFundSetup.ExtraField1;
cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = string.Empty; //hR_ProvidentFundSetup.ExtraField2;
cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = string.Empty; //hR_ProvidentFundSetup.ExtraField3;
cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = string.Empty; //hR_ProvidentFundSetup.ExtraField4;
cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = string.Empty; //hR_ProvidentFundSetup.ExtraField5;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_ProvidentFundSetup.ModifiedBy;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_ProvidentFundSetup.ModifiedDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public static bool UpdateHR_ProvidentFundSetup(HR_ProvidentFundSetup hR_ProvidentFundSetup)
{
SqlHR_ProvidentFundSetupProvider sqlHR_ProvidentFundSetupProvider = new SqlHR_ProvidentFundSetupProvider();
return sqlHR_ProvidentFundSetupProvider.UpdateHR_ProvidentFundSetup(hR_ProvidentFundSetup);
}
public HR_ProvidentFundSetup GetHR_ProvidentFundSetupFromReader(IDataReader reader)
{
try
{
HR_ProvidentFundSetup hR_ProvidentFundSetup = new HR_ProvidentFundSetup
(
DataAccessObject.IsNULL<int>(reader["ProvidentFundSetupID"]),
DataAccessObject.IsNULL<int>(reader["ServiceLenStartYear"]),
DataAccessObject.IsNULL<int>(reader["ServiceLenEndYear"]),
DataAccessObject.IsNULL<int>(reader["FundTypeID"]),
DataAccessObject.IsNULL<double>(reader["FundPercentForEmp"]),
DataAccessObject.IsNULL<string>(reader["ExtraField1"]),
DataAccessObject.IsNULL<string>(reader["ExtraField2"]),
DataAccessObject.IsNULL<string>(reader["ExtraField3"]),
DataAccessObject.IsNULL<string>(reader["ExtraField4"]),
DataAccessObject.IsNULL<string>(reader["ExtraField5"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"])
);
return hR_ProvidentFundSetup;
}
catch (Exception ex)
{
return null;
}
}
