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);
}
}
}
