public void GetExcel()
{
List <Membrii> allCust = new List <Membrii>();
using (ArtClubEntities21 dc = new ArtClubEntities21())
{
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 List <Resurse> GetTables(string search, string sort, string sortdir, int skip, int pageSize, out int totalRecord)
{
using (ArtClubEntities21 dc = new ArtClubEntities21())
{
var v = (from a in dc.Resurses
where
a.ID_NumeResursa.Contains(search) ||
a.ID_Locatie.Contains(search) ||
a.CostZi.Contains(search) ||
a.ID_Status.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 List <Membrii> GetTables(string search, string sort, string sortdir, int skip, int pageSize, out int totalRecord)
{
using (ArtClubEntities21 dc = new ArtClubEntities21())
{
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());
}
}
public ActionResult SaveData(List <Membrii> Membrii)
{
bool status = false;
if (ModelState.IsValid)
{
using (ArtClubEntities21 dc = new ArtClubEntities21())
//using()
{
foreach (var i in Membrii)
{
dc.Membriis.Add(i);
}
dc.SaveChanges();
status = true;
Console.WriteLine(status);
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public List <Eveniment> GetTables(string search, string sort, string sortdir, int skip, int pageSize, out int totalRecord)
{
using (ArtClubEntities21 dc = new ArtClubEntities21())
{
var v = (from a in dc.Eveniments
where
a.ID_NumeEveniment.Contains(search) ||
a.ID_NumeResursa.Contains(search) ||
a.NumarZile.Contains(search) ||
a.ID_Data.Contains(search) ||
a.Ora.Contains(search) ||
a.ID_TipPlata.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());
}
}
