private List <SqlParameter> GetUpdateParam(ProductSortUpdate productSort) { var cmdparams = new List <SqlParameter>(); cmdparams.Add(SafeSQL.CreateInputParam("@SysId", SqlDbType.UniqueIdentifier, productSort.SysId)); cmdparams.Add(SafeSQL.CreateInputParam("@EventId", SqlDbType.UniqueIdentifier, productSort.EventId)); cmdparams.Add(SafeSQL.CreateInputParam("@ProductId", SqlDbType.Int, productSort.ProductId)); cmdparams.Add(SafeSQL.CreateInputParam("@ProductSort", SqlDbType.Int, productSort.ProductSort)); return(cmdparams); }
private ProductSortUpdate MapProductSortUpdate(Guid eventId, int pid) { var productSort = new ProductSortUpdate(); productSort.ProductId = pid; productSort.ProductSort = int.Parse(txtAddSort.Text); productSort.SysId = Guid.NewGuid(); productSort.EventId = eventId; return(productSort); }
public List <UpdateDetails> GetBulkUpdate(Guid eventId) { var sql = @"SELECT* FROM [ScheduleEvent].[dbo].ProductSortUpdate WHERE EventId = @EventId AND Status=1"; var cmd = new SqlCommand { CommandText = sql }; cmd.Parameters.Add(SafeSQL.CreateInputParam("@EventId", SqlDbType.UniqueIdentifier, eventId)); var dt = SqlDbmanager.queryBySql(cmd); var list = new List <UpdateDetails>(); foreach (DataRow dr in dt.Rows) { var sort = new ProductSortUpdate(); sort.ProductId = int.Parse(dr["ProductId"].ToString()); sort.ProductSort = int.Parse(dr["ProductSort"].ToString()); list.Add(sort); } return(list); }