private List <SqlParameter> GetUpdateParam(ProductPreOrderUpdate preorder)
{
var cmdparams = new List <SqlParameter>();
cmdparams.Add(SafeSQL.CreateInputParam("@SysId", SqlDbType.UniqueIdentifier, preorder.SysId));
cmdparams.Add(SafeSQL.CreateInputParam("@EventId", SqlDbType.UniqueIdentifier, preorder.EventId));
cmdparams.Add(SafeSQL.CreateInputParam("@ProductId", SqlDbType.Int, preorder.ProductId));
cmdparams.Add(SafeSQL.CreateInputParam("@PreOrderQuantity", SqlDbType.Int, preorder.PreOrderQuantity));
cmdparams.Add(SafeSQL.CreateInputParam("@PreOrderStatus", SqlDbType.Int, preorder.PreOrderStatus));
return(cmdparams);
}
private ProductPreOrderUpdate MapProductPreOrderUpdate(Guid eventId, int pid)
{
var productPreorder = new ProductPreOrderUpdate();
productPreorder.ProductId = pid;
productPreorder.PreOrderQuantity = int.Parse(txtAddPreOrderQuantity.Text);
productPreorder.PreOrderStatus = int.Parse(ddlAddPreOrderStatus.SelectedValue);
productPreorder.SysId = Guid.NewGuid();
productPreorder.EventId = eventId;
return(productPreorder);
}
public List <UpdateDetails> GetBulkUpdate(Guid eventId)
{
var sql = @"SELECT ProductId, PreorderQuantity, convert(int, PreOrderStatus) As PreOrderStatus FROM [ScheduleEvent].[dbo].ProductPreOrderUpdate 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 preorder = new ProductPreOrderUpdate();
preorder.ProductId = int.Parse(dr["ProductId"].ToString());
preorder.PreOrderQuantity = int.Parse(dr["PreOrderQuantity"].ToString());
preorder.PreOrderStatus = int.Parse(dr["PreOrderStatus"].ToString());
list.Add(preorder);
}
return(list);
}
