public static LocaleStringResourceCollection Search(SearchFilter SearchKey) { LocaleStringResourceCollection collection = new LocaleStringResourceCollection(); using (var reader = SqlHelper.ExecuteReader("DNHLocaleStringResource_Search", SearchFilterManager.SqlSearchParam(SearchKey))) { while (reader.Read()) { LocaleStringResource obj = new LocaleStringResource(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static LocaleStringResource GetItemByID(int LocaleStringResourceID, int CompanyID) { LocaleStringResource item = new LocaleStringResource(); var sqlParams = new SqlParameter[] { new SqlParameter("@LocaleStringResourceID", LocaleStringResourceID), new SqlParameter("@CompanyID", CompanyID), }; using (var reader = SqlHelper.ExecuteReader("LocaleStringResource_GetByID", sqlParams)) { while (reader.Read()) { item = GetItemFromReader(reader); } } return(item); }
public static LocaleStringResource AddItem(LocaleStringResource model) { int result = 0; try { using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "LocaleStringResource_Add", CreateSqlParameter(model))) { while (reader.Read()) { result = (int)reader[0]; } } } catch (Exception ObjEx) { } return(GetItemByID(result, model.CompanyID)); }
public static LocaleStringResourceCollection GetAllItem(int CompanyID) { LocaleStringResourceCollection collection = new LocaleStringResourceCollection(); var sqlParams = new SqlParameter[] { new SqlParameter("@CompanyID", CompanyID), }; using (var reader = SqlHelper.ExecuteReader("LocaleStringResource_GetAll", sqlParams)) { while (reader.Read()) { LocaleStringResource obj = new LocaleStringResource(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }