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