public virtual OrderOptionStore UpdateOrderOptionStore(OrderOptionStore entity) { if (entity.IsTransient()) { return(entity); } OrderOptionStore other = GetOrderOptionStore(entity.OrderOptionId); if (entity.Equals(other)) { return(entity); } string sql = @"Update OrderOptionStore set [ID]=@ID , [StoreID]=@StoreID , [CreatedOn]=@CreatedOn where OrderOptionID=@OrderOptionID" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@OrderOptionID", entity.OrderOptionId) , new SqlParameter("@ID", entity.Id) , new SqlParameter("@StoreID", entity.StoreId) , new SqlParameter("@CreatedOn", entity.CreatedOn) }; SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray); return(GetOrderOptionStore(entity.OrderOptionId)); }
public virtual OrderOptionStore InsertOrderOptionStore(OrderOptionStore entity) { OrderOptionStore other = new OrderOptionStore(); other = entity; if (entity.IsTransient()) { string sql = @"Insert into OrderOptionStore ( [OrderOptionID] ,[ID] ,[StoreID] ,[CreatedOn] ) Values ( @OrderOptionID , @ID , @StoreID , @CreatedOn ); Select scope_identity()" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@OrderOptionID", entity.OrderOptionId) , new SqlParameter("@ID", entity.Id) , new SqlParameter("@StoreID", entity.StoreId) , new SqlParameter("@CreatedOn", entity.CreatedOn) }; var identity = SqlHelper.ExecuteScalar(this.ConnectionString, CommandType.Text, sql, parameterArray); if (identity == DBNull.Value) { throw new DataException("Identity column was null as a result of the insert operation."); } return(GetOrderOptionStore(Convert.ToInt32(identity))); } return(entity); }
public virtual OrderOptionStore OrderOptionStoreFromDataRow(DataRow dr) { if (dr == null) { return(null); } OrderOptionStore entity = new OrderOptionStore(); entity.Id = (System.Int32)dr["ID"]; entity.OrderOptionId = (System.Int32)dr["OrderOptionID"]; entity.StoreId = (System.Int32)dr["StoreID"]; entity.CreatedOn = (System.DateTime)dr["CreatedOn"]; return(entity); }
public OrderOptionStore InsertOrderOptionStore(OrderOptionStore entity) { return(_iOrderOptionStoreRepository.InsertOrderOptionStore(entity)); }
public OrderOptionStore UpdateOrderOptionStore(OrderOptionStore entity) { return(_iOrderOptionStoreRepository.UpdateOrderOptionStore(entity)); }
public virtual OrderOptionStore DeleteOrderOptionStore(OrderOptionStore entity) { this.DeleteOrderOptionStore(entity.OrderOptionId); return(entity); }