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