public int LoadStartStatusPID(string entityprefix, int defaultB02ID) { BO.COM.GetInteger c = _db.Load <BO.COM.GetInteger>("SELECT b02ID as Value FROM b02Status WHERE b02StartFlag=1 AND b02Entity like @prefix", new { prefix = entityprefix }); if (c == null || c.Value == 0) { return(defaultB02ID); } return(c.Value); }
public bool UpdateCloudID(int intP28ID, string strCloudID) { if (string.IsNullOrEmpty(strCloudID) == false) { BO.COM.GetInteger c = _db.Load <BO.COM.GetInteger>("select p28ID as Value FROM p28Company WHERE p28CloudID=@cloudid AND p28ID<>@pid", new { cloudid = strCloudID, pid = intP28ID }); if (c != null) { _mother.CurrentUser.AddMessage("Zadané cloud-id je již obsazenou jiným subjektem."); return(false); } } if (strCloudID == "-1") { strCloudID = null; } return(_db.RunSql("UPDATE p28Company SET p28CloudID=@cloudid WHERE p28ID=@pid", new { cloudid = strCloudID, pid = intP28ID })); }