public static void Add(CtVet1d tmp) { if (tmp is null) { return; } string q = "INSERT INTO ctVet1d (repMO,KIDro,KIDdiv,dtObs,KIDdis," + "KIDtyp,area,measure,m2) VALUES (@repMO,@KIDro,@KIDdiv,@dtObs," + "@KIDdis,@KIDtyp,@area,@measure,@m2)"; var p = new { repMO = tmp.repMO, KIDro = tmp.KIDro, KIDdiv = tmp.KIDdiv, dtObs = tmp.dtObs, KIDdis = tmp.KIDdis, KIDtyp = tmp.KIDtyp, area = tmp.area, measure = tmp.measure, m2 = tmp.m2 }; using (SqlConnection _conn = new SqlConnection(spDAL.connStr)) { _conn.Execute(q, p); _conn.Close(); } }
public static void Update(CtVet1d tmp) { using (SqlConnection _conn = new SqlConnection(spDAL.connStr)) { string q = "UPDATE ctVet1d SET " + " KIDro=@KIDro,repMO=@repMO,KIDdiv=@KIDdiv," + " dtObs=@dtObs,KIDdis=@KIDdis,KIDtyp=@KIDtyp," + " area=@area,measure=@measure,m2=@m2 " + " WHERE Id=@idd"; var param = new { KIDro = tmp.KIDro, repMO = tmp.repMO, KIDdiv = tmp.KIDdiv, dtObs = tmp.dtObs, KIDdis = tmp.KIDdis, KIDtyp = tmp.KIDtyp, area = tmp.area, measure = tmp.measure, m2 = tmp.m2, idd = tmp.ID }; _conn.Execute(q, param); _conn.Close(); } }
public IActionResult Edit(Guid id) { int Y = Convert.ToInt32(User.Claims.ToList().FirstOrDefault(x => x.Type == "reportDtYear").Value); int M = Convert.ToInt32(User.Claims.ToList().FirstOrDefault(x => x.Type == "reportDtMonth").Value); string KIDro = User.Claims.ToList().FirstOrDefault(x => x.Type == "KIDro").Value; CtVet1d tmp = CtVet1dDAL.GetByID_CtVet1d(id); if (tmp == null) { return(NotFound()); } tmp.KIDdivDisplay = spDAL.KIDdivName(tmp.KIDdiv); tmp.KIDdisDisplay = spDAL.KIDdisName(tmp.KIDdis); tmp.KIDtypDisplay = spDAL.KIDtypName(tmp.KIDtyp); ViewBag.RepMoList = spDAL.RepMO1YearList(Y, M); ViewBag.KIDdivList = spDAL.KIDdivList(KIDro); ViewBag.KIDdisList = spDAL.KIDdisList(); ViewBag.KIDtypList = spDAL.KIDtypList(); ViewBag.Page = "ctVet1d"; return(View(tmp)); }
public IActionResult Edit(Guid id, [Bind] CtVet1d tmp) { if (id == null) { return(NotFound()); } if (ModelState.IsValid) { CtVet1dDAL.Update(tmp); return(RedirectToAction("Index")); } ViewBag.Page = "ctVet1d"; return(View(tmp)); }
public IActionResult Delete(Guid id) { if (id == null) { return(NotFound()); } CtVet1d tmp = CtVet1dDAL.GetByID_CtVet1d(id); if (tmp == null) { return(NotFound()); } ViewBag.Page = "CtVet1d"; return(View(tmp)); }
public IActionResult Create([Bind] CtVet1d tmp) { if (!ModelState.IsValid) { ViewBag.Page = "CtVet1d"; return(View(tmp)); } if (CtVet1dDAL.IsUniqueRecord(tmp)) { CtVet1dDAL.Add(tmp); } else { TempData["EM"] = "Такая запись уже существует"; }; return(RedirectToAction("Index")); }
public IActionResult Create() { int Y = Convert.ToInt32(User.Claims.ToList().FirstOrDefault(x => x.Type == "reportDtYear").Value); int M = Convert.ToInt32(User.Claims.ToList().FirstOrDefault(x => x.Type == "reportDtMonth").Value); string KIDro = User.Claims.ToList().FirstOrDefault(x => x.Type == "KIDro").Value; ViewBag.RepMoList = spDAL.RepMO1YearList(Y, M); ViewBag.KIDdivList = spDAL.KIDdivList(KIDro); ViewBag.KIDdisList = spDAL.KIDdisList(); ViewBag.KIDtypList = spDAL.KIDtypList(); CtVet1d tmp = new CtVet1d { KIDro = User.Claims.ToList().FirstOrDefault(x => x.Type == "KIDro").Value, repMO = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1), dtObs = DateTime.Today }; ViewBag.Page = "CtVet1d"; return(View(tmp)); }
public static bool IsUniqueRecord(CtVet1d tmp) { //проверка на существования аналогичной записи int count = 0; using (SqlConnection _conn_check = new SqlConnection(spDAL.connStr)) { count = _conn_check.QueryFirst <int>("SELECT COUNT(*) FROM CtVet1d WHERE (" + "repMO=@repMOP and KIDro=@KIDroP and KIDdiv=@KIDdivP and KIDdis=@KIDdisP" + " and dtObs=@dtObsP and KIDtyp=@KIDtypP)", new { repMOP = tmp.repMO, KIDroP = tmp.KIDro, KIDdivP = tmp.KIDdiv, KIDdisP = tmp.KIDdis, dtObsP = tmp.dtObs, KIDtypP = tmp.KIDtyp }); _conn_check.Close(); if (count == 0) { return(true); } else { return(false); } } }