public static bool IsUniqueRecord(CtVet2 tmp)
{
if (tmp == null)
{
return(false);
}
using (SqlConnection _conn = new SqlConnection(spDAL.connStr))
{
string q = "SELECT COUNT(ID) as kolvo FROM ctVET2 " +
"WHERE (repPer = @repPer and KIDdiv=@KIDDiv " +
"and KIDspc=@KIDspc and KIDdtp=@KIDdtp and " +
"KIDro=@KIDro and dtObs=@dtObs)";
var param = new
{
KIDro = tmp.KIDro,
repPer = tmp.repPer,
KIDdiv = tmp.KIDdiv,
KIDspc = tmp.KIDspc,
KIDdtp = tmp.KIDdtp,
dtObs = tmp.dtObs,
};
int count = _conn.QueryFirstOrDefault <int>(q, param);
if (count == 0)
{
return(true);
}
else
{
return(false);
}
}
}
public static void Add(CtVet2 tmp)
{
if (tmp == null)
{
return;
}
using (SqlConnection _conn = new SqlConnection(spDAL.connStr))
{
string q = "INSERT INTO ctVet2 " +
"(KIDro,repPer,KIDdiv,KIDspc,KIDdtp," +
"dtObs,nA,nD,Notes) " +
"VALUES " +
"(@KIDro,@repPer,@KIDdiv,@KIDspc,@KIDdtp,@dtObs,@nA,@nD," +
"@Notes)";
var param = new
{
KIDro = tmp.KIDro,
repPer = tmp.repPer,
KIDdiv = tmp.KIDdiv,
KIDspc = tmp.KIDspc,
KIDdtp = tmp.KIDdtp,
dtObs = tmp.dtObs,
nA = tmp.nA,
nD = tmp.nD,
Notes = tmp.Notes
};
_conn.Execute(q, param);
_conn.Close();
}
}
public IActionResult Edit(Guid id)
{
if (id == null)
{
return(NotFound());
}
CtVet2 tmp = CtVet2DAL.GetById(id);
if (tmp == null)
{
return(NotFound());
}
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.repPerList = CtVet2DAL.RepPerListList(Y, M);
ViewBag.KIDdivList = spDAL.KIDdivList(KIDro);
ViewBag.KIDspcList = spDAL.KIDspcList();
ViewBag.KIDdtpList = spDAL.KIDdtpList();
ViewBag.Page = "CtVet2";
return(View(tmp));
}
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.repPerList = CtVet2DAL.RepPerListList(Y, M);
ViewBag.KIDdivList = spDAL.KIDdivList(KIDro);
ViewBag.KIDspcList = spDAL.KIDspcList();
ViewBag.KIDdtpList = spDAL.KIDdtpList();
string pg;
if (DateTime.Today.Month > 6)
{
pg = "2";
}
else
{
pg = "1";
}
CtVet2 tmp = new CtVet2
{
KIDro = User.Claims.ToList().FirstOrDefault(x => x.Type == "KIDro").Value,
repPer = DateTime.Today.Year + "/" + pg
//new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1)
};
ViewBag.Page = "CtVet2";
return(View(tmp));
}
public static CtVet2 GetById(Guid id)
{
using (SqlConnection _conn = new SqlConnection(spDAL.connStr))
{
//CtVet2 tmp = _conn.QueryFirstOrDefault<CtVet2>("SELECT * FROM ctVet2 WHERE ID=@idd",
// new {idd = id});
var idd = id;
CtVet2 tmp = _conn.Get <CtVet2>(idd);
tmp.KIDdivDisplay = spDAL.KIDdivName(tmp.KIDdiv);
tmp.KIDspcDisplay = spDAL.KIDspcName(tmp.KIDspc);
tmp.KIDdtpDisplay = spDAL.KIDdtpName(tmp.KIDdtp);
tmp.repPer = tmp.repPer.Trim();
return(tmp);
}
}
public IActionResult Delete(Guid id)
{
if (id == null)
{
return(NotFound());
}
CtVet2 tmp = CtVet2DAL.GetById(id);
if (tmp == null)
{
return(NotFound());
}
ViewBag.Page = "CtVet2";
return(View(tmp));
}
public IActionResult Edit(Guid id, [Bind] CtVet2 tmp)
{
if (id == null)
{
return(NotFound());
}
if (ModelState.IsValid)
{
//if(BioPrepDAL.IsUniqueRecord(objBioPrep))
CtVet2DAL.Update(tmp);
return(RedirectToAction("Index"));
}
ViewBag.Page = "CtVet2";
return(View(tmp));
}
public IActionResult Create([Bind] CtVet2 tmp)
{
if (ModelState.IsValid)
{
if (CtVet2DAL.IsUniqueRecord(tmp))
{
CtVet2DAL.Add(tmp);
}
else
{
TempData["EM"] = "Такая запись уже существует";
};
return(RedirectToAction("Index"));
}
ViewBag.Page = "CtVet2";
return(View(tmp));
}
public static void Update(CtVet2 tmp)
{
if (tmp is null)
{
return;
}
using (SqlConnection _conn = new SqlConnection(spDAL.connStr))
{
string q = "UPDATE ctVET2 SET " +
"KIDro=@KIDro," +
"repPer=@repPer," +
"KIDdiv=@KIDdiv," +
"KIDspc=@KIDspc," +
"KIDdtp=@KIDdtp," +
"dtObs=@dtObs," +
"nA=@nA," +
"nD=@nD," +
"Notes=@Notes " +
"WHERE ID=@ID";
var param = new
{
KIDro = tmp.KIDro,
repPer = tmp.repPer,
KIDdiv = tmp.KIDdiv,
KIDspc = tmp.KIDspc,
KIDdtp = tmp.KIDdtp,
dtObs = tmp.dtObs,
nA = tmp.nA,
nD = tmp.nD,
Notes = tmp.Notes,
ID = tmp.ID
};
_conn.Execute(q, param);
_conn.Close();
}
}
