public IActionResult Record(Models.o51RecordViewModel v)
{
if (ModelState.IsValid)
{
BO.o51Tag c = new BO.o51Tag();
if (v.Rec.pid > 0)
{
c = Factory.o51TagBL.Load(v.Rec.pid);
}
c.o53ID = v.Rec.o53ID;
c.o51Code = v.Rec.o51Code;
c.o51Name = v.Rec.o51Name;
c.o51Ordinary = v.Rec.o51Ordinary;
c.o51IsColor = v.Rec.o51IsColor;
c.o51BackColor = v.Rec.o51BackColor;
c.o51ForeColor = v.Rec.o51ForeColor;
c.ValidUntil = v.Toolbar.GetValidUntil(c);
c.ValidFrom = v.Toolbar.GetValidFrom(c);
v.Rec.pid = Factory.o51TagBL.Save(c);
if (v.Rec.pid > 0)
{
v.SetJavascript_CallOnLoad(v.Rec.pid);
return(View(v));
}
}
RefreshState(ref v);
this.Notify_RecNotSaved();
return(View(v));
}
public int Save(BO.o51Tag rec)
{
if (rec.o51Name.Contains(","))
{
_mother.CurrentUser.AddMessage("Název položky kategorie nesmí obsahovat čárku.");
return(0);
}
if (rec.o51Name.Length > 30)
{
_mother.CurrentUser.AddMessage("V názvu položky kategorie může být maximálně 30 znaků.");
return(0);
}
if (GetList(new BO.myQuery("o51Tag")).Where(p => p.pid != rec.pid && p.o51Name.ToLower() == rec.o51Name.Trim().ToLower()).Count() > 0)
{
_mother.CurrentUser.AddMessage("Položka kategorie s tímto názvem již existuje.");
return(0);
}
var p = new DL.Params4Dapper();
p.AddInt("pid", rec.o51ID);
if (rec.j02ID_Owner == 0)
{
rec.j02ID_Owner = _db.CurrentUser.j02ID;
}
p.AddInt("j02ID_Owner", rec.j02ID_Owner, true);
p.AddInt("o53ID", rec.o53ID, true);
p.AddString("o51Name", rec.o51Name);
p.AddString("o51Code", rec.o51Code);
p.AddInt("o51Ordinary", rec.o51Ordinary);
p.AddBool("o51IsColor", rec.o51IsColor);
if (rec.o51IsColor == false)
{
rec.o51ForeColor = "";
rec.o51BackColor = "";
}
p.AddString("o51ForeColor", rec.o51ForeColor);
p.AddString("o51BackColor", rec.o51BackColor);
int intPID = _db.SaveRecord("o51Tag", p.getDynamicDapperPars(), rec);
var pars = new Dapper.DynamicParameters();
pars.Add("userid", _db.CurrentUser.pid);
pars.Add("pid", intPID, System.Data.DbType.Int32);
pars.Add("err_ret", "", System.Data.DbType.String, System.Data.ParameterDirection.Output);
_db.RunSp("o51_after_save", ref pars);
return(intPID);
}
