public IdentityCategory GetById(int Id) { var info = new IdentityCategory(); var sqlCmd = @"Category_GetById"; var parameters = new Dictionary <string, object> { { "@Id", Id } }; try { using (var conn = new SqlConnection(_connectionString)) { using (var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, parameters)) { if (reader.Read()) { info = ExtractCategoryData(reader); } } } } catch (Exception ex) { var strError = "Failed to execute M_Category_GetById. Error: " + ex.Message; throw new CustomSQLException(strError); } return(info); }
public bool Update(IdentityCategory identity) { //Common syntax var sqlCmd = @"M_Category_Update"; //For parameters var parameters = new Dictionary <string, object> { { "@Id", identity.Id }, { "@Name", identity.Name }, { "@Code", identity.Code }, { "@Icon", identity.Icon }, { "@UrlFriendly", identity.UrlFriendly }, { "@LastUpdatedBy", identity.LastUpdatedBy }, { "@Status", identity.Status } }; try { using (var conn = new SqlConnection(_connectionString)) { MsSqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, sqlCmd, parameters); } } catch (Exception ex) { var strError = "Failed to execute M_Category_Update. Error: " + ex.Message; throw new CustomSQLException(strError); } return(true); }
public int Insert(IdentityCategory identity) { //Common syntax var sqlCmd = @"M_Category_Insert"; var newId = 0; //For parameters var parameters = new Dictionary <string, object> { { "@Name", identity.Name }, { "@Code", identity.Code }, { "@Icon", identity.Icon }, { "@UrlFriendly", identity.UrlFriendly }, { "@CreatedBy", identity.CreatedBy }, { "@Status", identity.Status } }; try { using (var conn = new SqlConnection(_connectionString)) { var returnObj = MsSqlHelper.ExecuteScalar(conn, CommandType.StoredProcedure, sqlCmd, parameters); newId = Convert.ToInt32(returnObj); } } catch (Exception ex) { var strError = "Failed to execute M_Category_Insert. Error: " + ex.Message; throw new CustomSQLException(strError); } return(newId); }
public IdentityCategory GetDetail(int Id) { var info = new IdentityCategory(); var sqlCmd = @"M_Category_GetDetail"; var parameters = new Dictionary <string, object> { { "@Id", Id } }; try { using (var conn = new SqlConnection(_connectionString)) { using (var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, parameters)) { //Get base info if (reader.Read()) { info = ExtractCategoryData(reader); } //Get data for all languages if (reader.NextResult()) { while (reader.Read()) { var langItem = new IdentityCategoryLang(); langItem.Id = Utils.ConvertToInt32(reader["Id"]); langItem.LangCode = reader["LangCode"].ToString(); langItem.Name = reader["Name"].ToString(); langItem.UrlFriendly = reader["UrlFriendly"].ToString(); langItem.CategoryId = Utils.ConvertToInt32(reader["CategoryId"]); info.LangList.Add(langItem); } } } } } catch (Exception ex) { var strError = "Failed to execute M_Category_GetDetail. Error: " + ex.Message; throw new CustomSQLException(strError); } return(info); }
private IdentityCategory ExtractCategoryData(IDataReader reader) { var record = new IdentityCategory(); //Seperate properties record.Id = Utils.ConvertToInt32(reader["Id"]); record.Name = reader["Name"].ToString(); record.Code = reader["Code"].ToString(); record.Icon = reader["Icon"].ToString(); record.UrlFriendly = reader["UrlFriendly"].ToString(); record.CreatedBy = reader["CreatedBy"].ToString(); record.CreatedDate = reader["CreatedDate"] == DBNull.Value ? null : (DateTime?)reader["CreatedDate"]; record.LastUpdated = reader["LastUpdated"] == DBNull.Value ? null : (DateTime?)reader["LastUpdated"]; record.LastUpdatedBy = reader["LastUpdatedBy"].ToString(); record.Status = Utils.ConvertToInt32(reader["Status"]); return(record); }
public List <IdentityCategory> GetAll(IdentityCategory filter, int currentPage, int pageSize) { //Common syntax var sqlCmd = @"M_Category_GetByPage"; List <IdentityCategory> listData = null; //For paging int offset = (currentPage - 1) * pageSize; //For parameters var parameters = new Dictionary <string, object> { { "@Keyword", filter.Keyword }, { "@Status", filter.Status }, { "@Offset", offset }, { "@PageSize", pageSize }, }; try { using (var conn = new SqlConnection(_connectionString)) { using (var reader = MsSqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, sqlCmd, parameters)) { listData = ParsingListCategoryFromReader(reader); } } } catch (Exception ex) { var strError = "Failed to execute M_Category_GetByPage. Error: " + ex.Message; throw new CustomSQLException(strError); } return(listData); }
public bool Update(IdentityCategory identity) { return(myRepository.Update(identity)); }
public int Insert(IdentityCategory identity) { return(myRepository.Insert(identity)); }
public List <IdentityCategory> GetAll(IdentityCategory filter, int currentPage, int pageSize) { return(myRepository.GetAll(filter, currentPage, pageSize)); }
public MappedIdentity(IdentityCategory identityCategory) { this.Type = identityCategory; }
public MappedIdentity(IdentityCategory identityCategory) { this.Type = identityCategory; }