public ActionResult DeleteConfirmed(int id)
{
VipolnennieUslugi vipolnennieUslugi = db.VipolnennieUslugis.Find(id);
db.VipolnennieUslugis.Remove(vipolnennieUslugi);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Date,AdresId,UslugaId,StoimostNaM2,StoimostNaMonth")] VipolnennieUslugi vipolnennieUslugi)
{
if (ModelState.IsValid)
{
db.Entry(vipolnennieUslugi).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AdresId = new SelectList(db.Adres, "Id", "Adress", vipolnennieUslugi.AdresId);
ViewBag.UslugaId = new SelectList(db.Usluga, "Id", "Name", vipolnennieUslugi.UslugaId);
return(View(vipolnennieUslugi));
}
// GET: VipolnennieUslugis/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VipolnennieUslugi vipolnennieUslugi = db.VipolnennieUslugis.Find(id);
if (vipolnennieUslugi == null)
{
return(HttpNotFound());
}
return(View(vipolnennieUslugi));
}
// GET: VipolnennieUslugis/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VipolnennieUslugi vipolnennieUslugi = db.VipolnennieUslugis.Find(id);
if (vipolnennieUslugi == null)
{
return(HttpNotFound());
}
ViewBag.AdresId = new SelectList(db.Adres, "Id", "Adress", vipolnennieUslugi.AdresId);
ViewBag.UslugaId = new SelectList(db.Usluga, "Id", "Name", vipolnennieUslugi.UslugaId);
return(View(vipolnennieUslugi));
}
// GET: VipolnennieUslugis/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VipolnennieUslugi vipolnennieUslugi = db.VipolnennieUslugis.Where(x => x.Id == id).Include(v => v.Adres).Include(f => f.Usluga).First();//db.VipolnennieUslugis.Find(id);
if (vipolnennieUslugi == null)
{
return(HttpNotFound());
}
// vipolnennieUslugi.
// ViewBag.AdresId = new SelectList(db.Adres, "Id", "Adress", vipolnennieUslugi.AdresId);
// ViewBag.UslugaId = new SelectList(db.Usluga, "Id", "Name", vipolnennieUslugi.UslugaId);
return(View(vipolnennieUslugi));
}
// [HttpPost]
public ActionResult IndexPoDomamPartial(string Year)
{
string GEU = "";
string Month = "";
if (Year == null)
{
Year = DateTime.Now.Year.ToString();
Month = DateTime.Now.Month.ToString();
GEU = "";
if (HttpContext.Request.Cookies["Month"] != null)
{
Month = HttpContext.Request.Cookies["Month"].Value;
}
}
else
{
string[] YM = Year.Split(';');
Month = YM[1];
GEU = YM[2];
Year = YM[0];
HttpContext.Response.Cookies["Month"].Value = Month;
HttpContext.Response.Cookies["Month"].Expires = DateTime.Now.AddDays(1);
}
int M = 0;
Obratno(Month, out M);
int Y = Convert.ToInt16(Year);
Month = M.ToString();
List <VipolnennieUslugi> vipolnennieUslugis = new List <VipolnennieUslugi>();
if (M < 13)
{
vipolnennieUslugis = db.VipolnennieUslugis.Where(x => x.Date.Year == Y && x.Date.Month == M).Include(v => v.Adres).Include(v => v.Usluga).ToList();
}
else
{
vipolnennieUslugis = db.VipolnennieUslugis.Where(x => x.Date.Year == Y).Include(v => v.Adres).Include(v => v.Usluga).ToList();
}
if (GEU != "")
{
vipolnennieUslugis = vipolnennieUslugis.Where(z => z.Adres.GEU.Equals(GEU)).ToList();
}
List <VipolnennieUslugi> vu = new List <VipolnennieUslugi>();
List <int> NU = new List <int>();
List <string> NUString = new List <string>();
string adr = "";
int nu = 0;
string nustring = "";
List <List <string> > Mass = new List <List <string> >();
List <Adres> MasAdr = vipolnennieUslugis.Select(r => r.Adres).Distinct().ToList();
List <string> MasUslugiNames = vipolnennieUslugis.Select(r => r.Usluga.Name).Distinct().ToList();
List <string> Summ = new List <string>();
decimal SummaRub = 0;
foreach (Adres A in MasAdr)
{
decimal summarub = 0;
List <string> s = vipolnennieUslugis.Where(u => u.Adres.Adress == A.Adress).GroupBy(x => x.Usluga.Name).Select(x => x.Key + "= " + x.Sum(y => y.StoimostNaMonth)).ToList();
// = vipolnennieUslugis.Where(u=>u.Adres.Adress==A.Adress).OrderBy(x=>x.Usluga.Name).Select(t => t.Usluga.Name+"= "+t.StoimostNaMonth.ToString()).ToList();
summarub = vipolnennieUslugis.Where(u => u.Adres.Adress == A.Adress).Sum(x => x.StoimostNaMonth);
Summ.Add(summarub.ToString());
SummaRub += summarub;
int col = vipolnennieUslugis.Where(u => u.Adres.Adress == A.Adress).Count();
s.Insert(0, col.ToString());
Mass.Add(s);
}
ViewBag.Mass = Mass;
ViewBag.Summ = Summ;
ViewBag.SummaRub = SummaRub;
foreach (VipolnennieUslugi v in vipolnennieUslugis)
{
if (v.Adres.Adress.Equals(adr) == false)
{
NU.Add(nu);
NUString.Add(nustring);
if (v.StoimostNaM2 + v.StoimostNaMonth != 0)
{
nustring = v.Usluga.Name + ";";
nu = 1;
}
else
{
nustring = "";
nu = 0;
}
}
bool go = false;
VipolnennieUslugi VU = new VipolnennieUslugi();
VU = v;
foreach (VipolnennieUslugi vv in vu)
{
if (vv.Adres.Equals(v.Adres) == true)//если такой адрес уже есть в выборке
{
if (v.StoimostNaM2 + v.StoimostNaMonth != 0)
{
nustring += v.Usluga.Name + ";";
nu++;
}
go = true;
}
}
if (!go)
{
adr = VU.Adres.Adress;
vu.Add(VU);
}
}
NU.Add(nu);
NUString.Add(nustring);
ViewBag.NUString = NUString; //названия услуг через ;
ViewBag.NumUslug = NU; //количество услуг
return(View(vu.ToList()));
}
