public void GetExcel()
{
List <Agentii_Table> allCust = new List <Agentii_Table>();
using (Agentii2Entities25 dc = new Agentii2Entities25())
{
allCust = dc.Agentii_Table.ToList();
}
WebGrid grid = new WebGrid(source: allCust, canPage: false, canSort: false);
string gridData = grid.GetHtml(
columns: grid.Columns(
grid.Column("Agentie", "Agentie"),
grid.Column("Intrare", "Intrare"),
grid.Column("Iesire", "Iesire"),
grid.Column("Explicatii", "Expicatii"),
grid.Column("Operator", "Operator"),
grid.Column("DataOra", "Data_Ora"),
grid.Column("Sold", "Sold"),
grid.Column("UltimaOp", "UltimaOp"),
grid.Column("Zile", "Zile")
)
).ToString();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Agentii.xls");
Response.ContentType = "application/vnd.ms-excel"; //excel
Response.Write(gridData);
Response.End();
}
public List <Agentii_Table> GetTables(string search, string sort, string sortdir, int skip, int pageSize, out int totalRecord)
{
using (Agentii2Entities25 dc = new Agentii2Entities25())
{
var v = (from a in dc.Agentii_Table
where
a.Agentie.Contains(search) ||
a.Intrare.Contains(search) ||
a.Iesire.Contains(search) ||
a.Explicatii.Contains(search) ||
a.Operator.Contains(search) ||
a.DataOra.Contains(search) ||
a.Sold.Contains(search) ||
a.UltimaOp.Contains(search) ||
a.Zile.Contains(search)
select a
);
totalRecord = v.Count();
v = v.OrderBy(sort + " " + sortdir); //linq.dynamic
if (pageSize > 0)
{
v = v.Skip(skip).Take(pageSize);
}
return(v.ToList());
}
}
public void GetExcel()
{
List <Membrii> allCust = new List <Membrii>();
using (Agentii2Entities25 dc = new Agentii2Entities25())
{
allCust = dc.Membriis.ToList();
}
WebGrid grid = new WebGrid(source: allCust, canPage: false, canSort: false);
string gridData = grid.GetHtml(
columns: grid.Columns(
grid.Column("ID_Username", "Username"),
grid.Column("Nume", "Nume"),
grid.Column("Prenume", "Prenume"),
grid.Column("Email", "Email"),
grid.Column("Parola", "Parola"),
grid.Column("ID_NumeFunctie", "NumeFunctie")
)
).ToString();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Membrii.xls");
Response.ContentType = "application/vnd.ms-excel"; //excel
Response.Write(gridData);
Response.End();
}
public ActionResult SaveData(List <Agentii_Table> Agentii_Table)
{
bool status = false;
if (ModelState.IsValid)
{
using (Agentii2Entities25 dc = new Agentii2Entities25())
{
foreach (var i in Agentii_Table)
{
dc.Agentii_Table.Add(i);
}
dc.SaveChanges();
status = true;
Console.WriteLine(status);
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public List <Membrii> GetTables(string search, string sort, string sortdir, int skip, int pageSize, out int totalRecord)
{
using (Agentii2Entities25 dc = new Agentii2Entities25())
{
var v = (from a in dc.Membriis
where
a.Nume.Contains(search) ||
a.Prenume.Contains(search) ||
a.Email.Contains(search) ||
a.ID_NumeFunctie.Contains(search) ||
a.ID_Username.Contains(search)
select a
);
totalRecord = v.Count();
v = v.OrderBy(sort + " " + sortdir); //linq.dynamic
if (pageSize > 0)
{
v = v.Skip(skip).Take(pageSize);
}
return(v.ToList());
}
}
