public ActionResult searchJson(string term, int?birds)
{
Cuatro_Caminos_BDEntities bd = new Cuatro_Caminos_BDEntities();
var r = bd.Списки_людей
.Select(e => new { id = e.Код, value = e.Фамилия + " " + e.Имя + " " + e.Отчество })
.Where(e => e.value.Contains(term));
//var result = db.kullanicis
// .Where(x => x.adi.Contains(term) || x.soyAdi.Contains(term))
// .Select(x => new { id = x.id, value = x.adi });
return(Json(r, JsonRequestBehavior.AllowGet));
}
public void SaveVisit(int group, FormCollection collection)
{
int id = 0;
Visits visits;
Cuatro_Caminos_BDEntities cuatroCaminosBdEntities = new Cuatro_Caminos_BDEntities();
int count = collection.GetValues("People").Count();
for (int i = 0; i < count; i++)
{
id = Int32.Parse(collection.GetValues("People").GetValue(i).ToString());
if (Int32.Parse(collection["Radio" + id]) != 3)
{
visits = new Visits();
visits.DataTimeRec = DateTime.Now;
visits.DataTimePay = collection["DataTimePay"] != null?DateTime.Parse(collection["DataTimePay"]) : DateTime.Now;
// visits.DataTimePay = DateTime.Parse(collection["DataTimePay"]);
visits.GroupId = group;
visits.LoginRecId = 151;
visits.PeopleId = id;
// visits.Freezing = false;
visits.Value = Int32.Parse(collection["Radio" + id]);
visits.Comments = collection["Coomment" + id];
// visits.Value = 1;
// visits.Comments = "2";
cuatroCaminosBdEntities.Visits.AddObject(visits);
// ModelState.AddModelError("", " radio: " + collection["Radio" + id] + " Комментарий: " + collection["Coomment" + id]);
}
// ModelState.AddModelError("", " Get: " + collection.Get(i) + " GetKey: " + collection.GetKey(i) + " radio: " + idPeoole);
}
cuatroCaminosBdEntities.SaveChanges();
}
public IEnumerable <SummVisitAndPay> GetSumm(int?months = null, int?gruppa = 0)
{
Cuatro_Caminos_BDEntities _cuatroCaminosBdEntities = new Cuatro_Caminos_BDEntities();
DateTime dateTime2012 = DateTime.Parse("01.01.2011", CultureInfo.CreateSpecificCulture("ru-RU"));
// dateTime2012 = DateTime.Now.AddYears(0);
IEnumerable <SummVisitAndPay> summListTemp = _cuatroCaminosBdEntities.Оплата
// .Where(e=>e.Месяц == id && e.Название_танца==1)
.Where(e => e.Дата_оплаты > dateTime2012 && e.Сумма > 0)
// .Where(e => e.Название_танца == gruppa)
.GroupBy(e => e.Код_Ученика)
.Select(
e =>
new SummVisitAndPay()
{
Name = new List_IdAndName {
Id = e.Key
},
SummPay = e.Sum(a => a.Сумма),
}
)
.ToList();
IEnumerable <SummVisitAndPay> summList = summListTemp
.Join(_cuatroCaminosBdEntities.Списки_людей,
summList1 => summList1.Name.Id,
people => people.Код,
(summList1, people) => new SummVisitAndPay()
{
Name = new List_IdAndName
{
Id = summList1.Name.Id,
Names = people.Фамилия + " " + people.Имя
},
SummPay = summList1.SummPay
}
)
.ToList();
return(summList);
}
// private void ExportAsCSV(IEnumerable<Списки_людей> filterRecords)
private void ExportAsCSV()
{
Cuatro_Caminos_BDEntities bd = new Cuatro_Caminos_BDEntities();
var sw = new StringWriter();
//write the header
sw.WriteLine(String.Format("{0},{1},{2},{3}", 1, 2, 2, 4));
//write every subscriber to the file
// var resourceManager = new ResourceManager(typeof(CMSMessages));
foreach (Списки_людей record in bd.Списки_людей)
{
sw.WriteLine(String.Format("{0},{1},{2},{3}", "тест", record.ФИО, record.Телефон, record.Пол));
}
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename=adressenbestand.csv");
Response.ContentType = "text/csv";
Response.Write(sw);
Response.End();
}
/// <summary>
/// Определение последних цен
/// </summary>
/// <param name="group">Id группы</param>
/// <returns>цена абонемента</returns>
public PriceClass(int group) : this()
{
_caminosBdEntities = new Cuatro_Caminos_BDEntities();
_group = group;
}
