public void cargarGrid()
{
DataTable dt2 = new DataTable();
dt2.Columns.AddRange(new DataColumn[6] {
new DataColumn("Posi", typeof(string)),
new DataColumn("Sku", typeof(string)),
new DataColumn("Desc", typeof(string)),
new DataColumn("Cant", typeof(string)),
new DataColumn("Uni", typeof(string)),
new DataColumn("Esp", typeof(string)),
});
foreach (var item in ped.Items)
{
string Posi = item.Posicion;
string Sku = item.SKU;
string Desc = item.Descripcion;
string Cant = item.Cantidad;
string Uni = item.UNIDAD;
string Esp = item.Especial1;
dt2.Rows.Add(Posi, Sku, Desc, Cant, Uni, Esp);
}
GridItems.DataSource = dt2;
GridItems.DataBind();
}
protected void GridItems_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
DataTable data = (DataTable)Cache["data"];
GridItems.DataSource = data;
MediaGalleryItems.RecourdNumber = data.Rows.Count;
GridItems.PageIndex = e.NewPageIndex;
GridItems.DataBind();
}
private void fillComments()
{
DataTable dtTbl = new DataTable();
dtTbl = (new BL()).searchComments();
GridItems.PageSize = Convert.ToInt32(10);
GridItems.DataSource = dtTbl;
GridItems.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dtTbl = new DataTable();
dtTbl = (new BL()).searchComments();
GridItems.PageSize = Convert.ToInt32(10);
GridItems.DataSource = dtTbl;
GridItems.DataBind();
}
}
protected void GridItems_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
DataTable data = (DataTable)Cache["data"];
Item item = Helper.GetDatabase().GetItem(data.Rows[e.RowIndex]["ID"].ToString());
item.Delete();
data.Rows.RemoveAt(e.RowIndex);
Cache["data"] = data;
MediaGalleryItems.RecourdNumber = data.Rows.Count;
GridItems.DataSource = data;
GridItems.DataBind();
}
protected void ExportData(object sender, EventArgs e)
{
try
{
string h = txtHeight.Text;
Int32.TryParse(h, out Height);
string w = txtWidth.Text;
Int32.TryParse(w, out Width);
data = new DataTable();
Helper.SetDataTableColums(data, MediaGalleryItems.ExportedFields);
MediaGalleryItems.CSV.AppendLine(Helper.GetHeader(MediaGalleryItems.ExportedFields));
using (new SecurityDisabler())
{
Database masterDb = Helper.GetDatabase();
Item parent = masterDb.GetItem(txtStartPath.Text.Trim());
if (parent != null)
{
GetData(parent);
}
Cache["data"] = data;
GridItems.DataSource = data;
GridItems.DataBind();
Helper.CreateFile(MediaGalleryItems.CSV.ToString(), MediaGalleryItems.OutputName);
}
pnSuccess.Visible = true;
pnFailure.Visible = false;
}
catch (Exception ex)
{
pnSuccess.Visible = false;
pnFailure.Visible = true;
}
}
