public ActionResult Zalozky()
{
using (HlidacStatu.Lib.Data.DbEntities db = new HlidacStatu.Lib.Data.DbEntities())
{
var bookmarks = db.Bookmark
.AsNoTracking()
.Where(m => m.UserId == User.Identity.Name)
.OrderByDescending(m => m.Created)
.ToArray();
return(View(bookmarks));
}
}
public ActionResult SubjektHlidac(string Id, FormCollection form)
{
bool existing = false;
string wd_id = form["wd_id"];
int wdId;
string subject = form["subjekt"];
using (HlidacStatu.Lib.Data.DbEntities db = new HlidacStatu.Lib.Data.DbEntities())
{
string id = this.User.Identity.GetUserId();
HlidacStatu.Lib.Data.WatchDog wd = null;
if (!string.IsNullOrEmpty(wd_id) && int.TryParse(wd_id, out wdId))
{
wd = WatchDog.Load(wdId);
existing = wd != null;
}
string query = "";
if (string.IsNullOrEmpty(form["ico"]) && wd != null)
{
wd.Delete();
return(RedirectToAction("Watchdogs", "Manage"));
}
else if (string.IsNullOrEmpty(form["ico"]))
{
return(Redirect("/Subjekt/" + id));
}
query = form["ico"].Split(',').Select(m => "ico:" + m).Aggregate((f, s) => f + " OR " + s);
if (wd == null)
{
wd = new HlidacStatu.Lib.Data.WatchDog();
}
wd.Created = DateTime.Now;
wd.UserId = id;
wd.StatusId = 1;
wd.SearchTerm = query;
wd.SearchRawQuery = "icoVazby:" + form["ico"];
wd.PeriodId = Convert.ToInt32(form["period"]);
wd.FocusId = Convert.ToInt32(form["focus"]);
wd.Name = Devmasters.TextUtil.ShortenText(form["wdname"], 50);
wd.Save();
return(RedirectToAction("Watchdogs", "Manage"));
}
}
private static OsobaEvent CreateEvent(OsobaEvent osobaEvent, string user, DbEntities db)
{
if (osobaEvent.OsobaId == 0 && string.IsNullOrWhiteSpace(osobaEvent.Ico))
{
throw new Exception("Cant attach event to a person or to a company since their reference is empty");
}
osobaEvent.Organizace = ParseTools.NormalizaceStranaShortName(osobaEvent.Organizace);
osobaEvent.Created = DateTime.Now;
db.OsobaEvent.Add(osobaEvent);
db.SaveChanges();
if (osobaEvent.OsobaId > 0)
{
Osoby.GetById.Get(osobaEvent.OsobaId).FlushCache();
}
Audit.Add(Audit.Operations.Update, user, osobaEvent, null);
return(osobaEvent);
}
public static HlidacStatu.Lib.OCR.Api.Result AddNewTask(ItemToOcrType itemType, string itemId, string itemSubType = null, HlidacStatu.Lib.OCR.Api.Client.TaskPriority priority = OCR.Api.Client.TaskPriority.Standard)
{
using (DbEntities db = new DbEntities())
{
ItemToOcrQueue i = new ItemToOcrQueue();
i.created = DateTime.Now;
i.itemId = itemId;
i.itemType = itemType.ToString();
i.itemSubType = itemSubType;
i.priority = (int)OCR.Api.Client.TaskPriority.Standard;
db.ItemToOcrQueue.Add(i);
db.SaveChanges();
return(new OCR.Api.Result()
{
IsValid = OCR.Api.Result.ResultStatus.InQueueWithCallback,
Id = "uknown"
});
}
}
public static Audit Add <T>(Operations operation, string user, string ipAddress, T newObj, T prevObj)
where T : IAuditable
{
using (DbEntities db = new DbEntities())
{
var a = new Audit();
a.date = DateTime.Now;
a.objectId = newObj?.ToAuditObjectId();
a.objectType = newObj?.ToAuditObjectTypeName();
a.operation = operation.ToString();
a.IP = ipAddress;
a.userId = user ?? "";
a.valueBefore = prevObj?.ToAuditJson() ?? null;
a.valueAfter = newObj?.ToAuditJson() ?? null;
db.Audit.Add(a);
db.SaveChanges();
return(a);
}
}
public ActionResult NasiPolitici_GetList()
{
if (!Framework.ApiAuth.IsApiAuth(this)
.Authentificated)
{
Response.StatusCode = 401;
return(Json(ApiResponseStatus.ApiUnauthorizedAccess, JsonRequestBehavior.AllowGet));
}
else
{
using (var db = new HlidacStatu.Lib.Data.DbEntities())
{
string sql = @"
select distinct os.NameId, os.Jmeno, os.Prijmeni
, os.JmenoAscii, os.PrijmeniAscii, year(os.Narozeni) RokNarozeni, year(os.Umrti) RokUmrti
, FIRST_VALUE(oes.organizace) OVER(partition by oes.osobaid order by oes.datumod desc) Aktpolstr
, oec.pocet
from Osoba os
left join OsobaEvent oes on os.InternalId = oes.OsobaId and oes.AddInfo in (N'člen strany',N'předseda strany',N'místopředseda strany') and oes.Type = 7
left join (select COUNT(pk) pocet, OsobaId from OsobaEvent group by osobaid) oec on oec.OsobaId = os.InternalId
where os.Status = 3";
var result = db.Database.SqlQuery <FindPersonDTO>(sql)
.Select(r => new
{
id = r.NameId,
name = r.Jmeno,
surname = r.Prijmeni,
asciiName = r.JmenoAscii,
asciiSurname = r.PrijmeniAscii,
birthYear = r.RokNarozeni,
deathYear = r.RokUmrti,
currentParty = r.Aktpolstr,
eventCount = r.Pocet
});
string osoby = JsonConvert.SerializeObject(result);
return(Content(osoby, "application/json"));
}
}
}
public static Audit Add(Operations operation, string user, string ipAddress,
string objectId, string objectType,
string newObjSer, string prevObjSer)
{
using (DbEntities db = new DbEntities())
{
var a = new Audit();
a.date = DateTime.Now;
a.objectId = objectId;
a.objectType = objectType;
a.operation = operation.ToString();
a.IP = ipAddress;
a.userId = user ?? "";
a.valueBefore = prevObjSer;
a.valueAfter = newObjSer ?? "";
db.Audit.Add(a);
db.SaveChanges();
return(a);
}
}
public bool IsInRole(string role)
{
using (DbEntities db = new DbEntities())
{
//var roleId = db.AspNetRoles.Where(m => m.Name == role).FirstOrDefault();
string roleId = null;
using (Devmasters.Core.PersistLib p = new Devmasters.Core.PersistLib())
{
var res = p.ExecuteScalar(Devmasters.Core.Util.Config.GetConfigValue("CnnString"),
System.Data.CommandType.Text, "select id from aspnetroles where name = @role",
new System.Data.IDataParameter[] { new System.Data.SqlClient.SqlParameter("role", role) });
if (Devmasters.Core.PersistLib.IsNull(res))
{
return(false);
}
}
return(db.AspNetUserRoles.Any(m => m.UserId == this.Id && m.RoleId == roleId));
}
}
private static IQueryable <ItemToOcrQueue> CreateQuery(DbEntities db, ItemToOcrType?itemType, string itemSubType)
{
IQueryable <ItemToOcrQueue> sql = null;
sql = db.ItemToOcrQueue
.Where(m => m.done.Equals(null) &&
m.started.Equals(null));
if (itemType != null)
{
sql = sql.Where(m => m.itemType == itemType.ToString());
}
if (!string.IsNullOrEmpty(itemSubType))
{
sql = sql.Where(m => m.itemSubType == itemSubType);
}
return(sql);
}
private static List <Autocomplete> LoadPeople()
{
List <Autocomplete> results = new List <Autocomplete>();
using (DbEntities db = new DbEntities())
{
Devmasters.Batch.Manager.DoActionForAll <Osoba>(db.Osoba
.Where(o => o.Status == (int)Osoba.StatusOsobyEnum.Politik ||
o.Status == (int)Osoba.StatusOsobyEnum.Sponzor),
o =>
{
var synonyms = new Autocomplete[2];
synonyms[0] = new Autocomplete()
{
Id = $"osobaid:{o.NameId}",
Text = $"{o.Prijmeni} {o.Jmeno}{AppendTitle(o.TitulPred, o.TitulPo)}",
Priority = o.Status == (int)Osoba.StatusOsobyEnum.Politik ? 2 : 0,
Type = o.StatusOsoby().ToNiceDisplayName(),
ImageElement = $"<img src='{o.GetPhotoUrl(false)}' />",
Description = InfoFact.RenderInfoFacts(
o.InfoFacts().Where(i => i.Level != InfoFact.ImportanceLevel.Stat).ToArray(),
2, true, false, "", "{0}", false)
};
synonyms[1] = (Autocomplete)synonyms[0].MemberwiseClone();
synonyms[1].Text = $"{o.Jmeno} {o.Prijmeni}{AppendTitle(o.TitulPred, o.TitulPo)}";
lock (_loadPlock)
{
results.Add(synonyms[0]);
results.Add(synonyms[1]);
}
return(new Devmasters.Batch.ActionOutputData());
}
, true
);
}
return(results);
}
private static Sponzoring FindDuplicate(Sponzoring sponzoring, DbEntities db)
{
// u sponzoringu nekontrolujeme organizaci, ani rok, protože to není historicky konzistentní
var result = db.Sponzoring.Where(s => s.Id == sponzoring.Id).FirstOrDefault();
if (result != null)
{
return(result);
}
return(db.Sponzoring
.Where(s =>
s.IcoDarce == sponzoring.IcoDarce &&
s.IcoPrijemce == sponzoring.IcoPrijemce &&
s.OsobaIdDarce == sponzoring.OsobaIdDarce &&
s.OsobaIdPrijemce == sponzoring.OsobaIdPrijemce &&
s.Typ == sponzoring.Typ &&
s.Hodnota == sponzoring.Hodnota &&
s.DarovanoDne == sponzoring.DarovanoDne
)
.FirstOrDefault());
}
public static InvoiceItems.ShopItem?GetCurrentOrderForUser(string userId)
{
DateTime now = DateTime.Now.Date;
DateTime now_30 = DateTime.Now.Date.AddDays(-30);
using (DbEntities db = new DbEntities())
{
var items = db.Invoices
.Where(m => m.ID_Customer == userId && (m.Status == 3 || m.Created > now_30))
.Join(db.InvoiceItems.Where(ii => ii.Expires > now),
inv => inv.ID,
ii => ii.ID_Invoice, (inv, ii) => ii)
.OrderByDescending(ii => ii.ID_ShopItem);
if (items.Count() > 0)
{
return((InvoiceItems.ShopItem)items.First().ID_ShopItem);
}
else
{
return(null);
}
}
}
public static void ResetTask(int taskItemId, bool decreasePriority = true)
{
using (DbEntities db = new DbEntities())
{
ItemToOcrQueue i = db.ItemToOcrQueue.Where(m => m.pk == taskItemId).FirstOrDefault();
if (i != null)
{
i.done = null;
i.started = null;
i.success = null;
i.result = null;
if (decreasePriority)
{
i.priority--;
if (i.priority < 1)
{
i.priority = 1;
}
}
db.SaveChanges();
}
}
}
public static void AddOrUpdate(
int osobaId, string dcerinkaIco,
int kod_angm, string funkce, decimal?share, DateTime?fromDate, DateTime?toDate, string zdroj = ""
)
{
using (Lib.Data.DbEntities db = new DbEntities())
{
var existing = db.OsobaVazby
.Where(m =>
m.OsobaID == osobaId &&
m.VazbakICO == dcerinkaIco &&
m.DatumOd == fromDate &&
m.DatumDo == toDate
)
.FirstOrDefault();
if (existing == null)
{
existing = db.OsobaVazby
.Where(m =>
m.OsobaID == osobaId &&
m.VazbakICO == dcerinkaIco &&
m.DatumOd == fromDate
)
.FirstOrDefault();
}
if (existing != null)
{
//update
existing.TypVazby = kod_angm;
existing.PojmenovaniVazby = funkce;
if (existing.podil != share)
{
existing.podil = share;
}
if (existing.DatumOd != fromDate)
{
existing.DatumOd = fromDate;
}
if (existing.DatumDo != toDate)
{
existing.DatumDo = toDate;
}
existing.LastUpdate = DateTime.Now;
}
else //new
{
OsobaVazby af = new OsobaVazby();
af.OsobaID = osobaId;
af.VazbakICO = dcerinkaIco;
af.DatumOd = fromDate;
af.DatumDo = toDate;
af.TypVazby = kod_angm;
af.PojmenovaniVazby = funkce;
af.podil = share;
af.LastUpdate = DateTime.Now;
db.OsobaVazby.Add(af);
}
db.SaveChanges();
}
}
public static void AddOrUpdate(
int osobaId, int vazbakOsobaId,
int kod_angm, string funkce, decimal?share, DateTime?fromDate, DateTime?toDate, string zdroj = ""
)
{
using (Lib.Data.DbEntities db = new DbEntities())
{
var existing = db.OsobaVazby
.Where(m =>
m.OsobaID == osobaId &&
m.VazbakOsobaId == vazbakOsobaId &&
m.DatumOd == fromDate &&
m.DatumDo == toDate
)
.FirstOrDefault();
if (existing == null)
{
existing = db.OsobaVazby
.Where(m =>
m.OsobaID == osobaId &&
m.VazbakOsobaId == vazbakOsobaId &&
m.DatumOd == fromDate
)
.FirstOrDefault();
}
if (existing != null)
{
//update
existing.TypVazby = kod_angm;
existing.PojmenovaniVazby = funkce;
if (existing.podil != share)
{
existing.podil = share;
}
if (existing.DatumOd != fromDate)
{
existing.DatumOd = fromDate;
}
if (existing.DatumDo != toDate)
{
existing.DatumDo = toDate;
}
existing.LastUpdate = DateTime.Now;
}
else //new
{
OsobaVazby af = new OsobaVazby();
af.OsobaID = osobaId;
af.VazbakICO = "";
af.VazbakOsobaId = vazbakOsobaId;
af.DatumOd = fromDate;
af.DatumDo = toDate;
af.TypVazby = kod_angm;
af.PojmenovaniVazby = funkce;
af.podil = share;
af.LastUpdate = DateTime.Now;
db.OsobaVazby.Add(af);
}
try
{
db.SaveChanges();
}
catch (Exception e)
{
HlidacStatu.Util.Consts.Logger.Error("", e);
throw;
}
}
}
private static Sponzoring CreateSponzoring(Sponzoring sponzoring, string user, DbEntities db)
{
if (sponzoring.OsobaIdDarce == 0 &&
string.IsNullOrWhiteSpace(sponzoring.IcoDarce))
{
throw new Exception("Cant attach sponzoring to a person or to a company since their reference is empty");
}
sponzoring.Created = DateTime.Now;
sponzoring.Edited = DateTime.Now;
sponzoring.UpdatedBy = user;
db.Sponzoring.Add(sponzoring);
db.SaveChanges();
Audit.Add(Audit.Operations.Create, user, sponzoring, null);
return(sponzoring);
}
public ActionResult Watchdogs(string id, string wid, string disable, string enable, string delete)
{
string currWDtype = null;
if (!string.IsNullOrEmpty(id))
{
if (WatchdogTypes.Any(w => w.ToLower() == id.ToLower()))
{
currWDtype = id;
}
}
//if (currWDtypes == null)
// currWDtypes = WatchdogTypes;
List <WatchDog> wds = new List <WatchDog>();
using (HlidacStatu.Lib.Data.DbEntities db = new HlidacStatu.Lib.Data.DbEntities())
{
string userid = this.User.Identity.GetUserId();
if (!string.IsNullOrEmpty(wid))
{
int watchdogid = Convert.ToInt32(wid);
HlidacStatu.Lib.Data.WatchDog wd;
wd = db.WatchDogs
.Where(m => m.Id == watchdogid && m.UserId == userid)
.FirstOrDefault();
if (wd == null)
{
return(View("Error404"));
}
else
{
if (disable == "1")
{
wd.StatusId = 0;
wd.Save();
}
if (enable == "1")
{
wd.StatusId = 1;
wd.Save();
}
if (delete == "1")
{
wd.Delete();
}
return(RedirectToAction("Watchdogs"));
}
}
else
{
wds.AddRange(
db.WatchDogs.AsNoTracking()
.Where(m =>
(m.dataType == currWDtype || currWDtype == null) &&
m.UserId == userid)
);
}
}
return(View(wds));
}
private static Sponzoring UpdateSponzoring(Sponzoring sponzoringToUpdate, Sponzoring sponzoring, string user, DbEntities db)
{
var sponzoringOriginal = sponzoringToUpdate.ShallowCopy();
if (!string.IsNullOrWhiteSpace(sponzoring.IcoDarce))
{
sponzoringToUpdate.IcoDarce = sponzoring.IcoDarce;
}
if (sponzoring.OsobaIdDarce > 0)
{
sponzoringToUpdate.OsobaIdDarce = sponzoring.OsobaIdDarce;
}
sponzoringToUpdate.Edited = DateTime.Now;
sponzoringToUpdate.UpdatedBy = user;
sponzoringToUpdate.DarovanoDne = sponzoring.DarovanoDne;
sponzoringToUpdate.Hodnota = sponzoring.Hodnota;
sponzoringToUpdate.IcoPrijemce = sponzoring.IcoPrijemce;
sponzoringToUpdate.OsobaIdPrijemce = sponzoring.OsobaIdPrijemce;
sponzoringToUpdate.Popis = sponzoring.Popis;
sponzoringToUpdate.Typ = sponzoring.Typ;
sponzoringToUpdate.Zdroj = sponzoring.Zdroj;
db.SaveChanges();
Audit.Add <Sponzoring>(Audit.Operations.Update, user, sponzoringToUpdate, sponzoringOriginal);
return(sponzoringToUpdate);
}
protected static UserOptions Get(string userId, ParameterType option, int?languageid)
{
var r = new DbEntities().UserOption_Get((int)option, userId, languageid);
return((UserOptions)r.FirstOrDefault());
}
public ActionResult AddWd(string query, string dataType, string name, int period, int focus)
{
using (HlidacStatu.Lib.Data.DbEntities db = new HlidacStatu.Lib.Data.DbEntities())
{
if (string.IsNullOrEmpty(query))
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
string id = this.User.Identity.GetUserId();
var dt = dataType;
HlidacStatu.Lib.Data.WatchDog wd = new HlidacStatu.Lib.Data.WatchDog();
wd.Created = DateTime.Now;
wd.UserId = id;
wd.StatusId = 1;
wd.SearchTerm = query;
wd.PeriodId = period;
wd.FocusId = focus;
wd.Name = Devmasters.TextUtil.ShortenText(name, 50);
if (dt.ToLower() == typeof(Smlouva).Name.ToLower())
{
wd.dataType = typeof(Smlouva).Name;
}
else if (dt.ToLower() == typeof(VerejnaZakazka).Name.ToLower())
{
wd.dataType = typeof(VerejnaZakazka).Name;
}
else if (dt.ToLower() == typeof(Lib.Data.Insolvence.Rizeni).Name.ToLower())
{
wd.dataType = typeof(Lib.Data.Insolvence.Rizeni).Name;
}
else if (dt.ToLower().StartsWith(typeof(HlidacStatu.Lib.Data.External.DataSets.DataSet).Name.ToLower()))
{
var dataSetId = dt.Replace("DataSet.", "");
if (HlidacStatu.Lib.Data.External.DataSets.DataSet.ExistsDataset(dataSetId) == false)
{
HlidacStatu.Util.Consts.Logger.Error("AddWd - try to hack, wrong dataType = " + dataType + "." + dataSetId);
throw new ArgumentOutOfRangeException("AddWd - try to hack, wrong dataType = " + dataType + "." + dataSetId);
}
wd.dataType = typeof(HlidacStatu.Lib.Data.External.DataSets.DataSet).Name + "." + dataSetId;
}
else if (dt == WatchDog.AllDbDataType)
{
wd.dataType = dt;
}
else
{
HlidacStatu.Util.Consts.Logger.Error("AddWd - try to hack, wrong dataType = " + dataType);
throw new ArgumentOutOfRangeException("AddWd - try to hack, wrong dataType = " + dataType);
}
if (!db.WatchDogs
.Any(m => m.dataType == wd.dataType && m.UserId == id && m.SearchTerm == query))
{
wd.Save();
}
//var lastOrder = HlidacStatu.Lib.Data.Invoices.GetCurrentOrderForUser(this.User.Identity.GetUserId());
//if (lastOrder.HasValue == false && focus == 1)
// return Json("2", JsonRequestBehavior.AllowGet);
return(Json("1", JsonRequestBehavior.AllowGet));
}
}
private static void _SendWatchDogs(string datatype, string[] ids, string userid, string date, string specificemail, bool forceSend = false, Expression <Func <WatchDog, bool> > predicate = null)
{
HlidacStatu.Util.Consts.Logger.Info("Starting SendWatchDogs type:" + datatype);
IEnumerable <int> watchdogs = null;
using (Lib.Data.DbEntities db = new DbEntities())
{
var data = db.WatchDogs.AsNoTracking()
.Where(m => m.StatusId > 0);
if (!string.IsNullOrEmpty(userid))
{
data = data.Where(m => m.UserId == userid);
}
if (!string.IsNullOrEmpty(datatype))
{
data = data.Where(m => m.dataType == datatype);
}
if (predicate != null)
{
data = data.Where(predicate);
}
if (ids != null)
{
data = data.Where(m => ids.Contains(m.Id.ToString()));
}
watchdogs = data
.Select(m => m.Id)
.ToArray();
}
System.Collections.Concurrent.ConcurrentBag <string> alreadySendInfo = new System.Collections.Concurrent.ConcurrentBag <string>();
try
{
Devmasters.Core.Batch.Manager.DoActionForAll <int, object>(watchdogs,
(wdid, obj) =>
{
string log = "";
var mainWatchdog = WatchDog.Load(wdid);
var mainWDBs = WatchDog.GetWatchDogBase(mainWatchdog);
var notifResult = true;
foreach (var wdb in mainWDBs)
{
HlidacStatu.Util.Consts.Logger.Debug($"Starting watchdog {wdb.ToString()}");
var mainDatatype = wdb.OrigWD.dataType;
var user = wdb.OrigWD.User();
if (user == null) //is not confirmed
{
var uuser = wdb.OrigWD.UnconfirmedUser();
wdb.OrigWD.DisableWDBySystem(DisabledBySystemReasons.NoConfirmedEmail,
alreadySendInfo.Contains(uuser.Id)
);
alreadySendInfo.Add(uuser.Id);
break; //exit for
}
if (user != null && wdb.OrigWD.StatusId > 0) //check again, some of them could change to disabled
{
try
{
notifResult = notifResult | _processIndividualWD(wdb, date, null, specificemail, forceSend);
}
catch (Exception e)
{
HlidacStatu.Util.Consts.Logger.Error("WatchDog search error", e);
log += "WatchDog search error " + e.ToString();
//throw;
}
}
}
if (notifResult && date == null && forceSend == false)
{
DateTime toDate = WatchDogProcessor.DefaultRoundWatchdogTime(mainWatchdog.Period, DateTime.Now);
if (mainWatchdog.LastSearched.HasValue == false || mainWatchdog.LastSearched < toDate)
{
mainWatchdog.LastSearched = toDate;
}
mainWatchdog.RunCount++;
var latestRec = toDate;
if (mainWatchdog.LatestRec.HasValue == false)
{
mainWatchdog.LatestRec = latestRec;
}
else if (latestRec > mainWatchdog.LatestRec)
{
mainWatchdog.LatestRec = latestRec;
}
mainWatchdog.LastSent = mainWatchdog.LastSearched;
mainWatchdog.Save();
}
return(new Devmasters.Core.Batch.ActionOutputData()
{
CancelRunning = false, Log = log
});
},
null,
HlidacStatu.Util.Consts.outputWriter.OutputWriter,
HlidacStatu.Util.Consts.progressWriter.ProgressWriter,
System.Diagnostics.Debugger.IsAttached ? false : true);
}
catch (Exception e)
{
HlidacStatu.Util.Consts.Logger.Fatal($"Watchdoga DoActionForAll error", e);
}
}
public ActionResult Watchdog(string _id, string _dataid, string dataType = "VerejnaZakazka", string query = null, string expiration = null)
{
string id = _id;
string dataid = _dataid;
id = id.ToLower();
var apiAuth = Framework.ApiAuth.IsApiAuth(this,
parameters: new Framework.ApiCall.CallParameter[] {
new Framework.ApiCall.CallParameter("id", id),
new Framework.ApiCall.CallParameter("query", query),
new Framework.ApiCall.CallParameter("expiration", expiration)
});
if (!apiAuth.Authentificated)
{
//Response.StatusCode = 401;
return(Json(ApiResponseStatus.ApiUnauthorizedAccess, JsonRequestBehavior.AllowGet));
}
else
{
if (apiAuth.ApiCall.User != "*****@*****.**" &&
apiAuth.ApiCall.User != "*****@*****.**"
)
{
return(Json(ApiResponseStatus.ApiUnauthorizedAccess, JsonRequestBehavior.AllowGet));
}
var wdName = WatchDog.APIID_Prefix + dataid;
using (HlidacStatu.Lib.Data.DbEntities db = new HlidacStatu.Lib.Data.DbEntities())
{
switch (id.ToLower())
{
case "add":
var expirDate = Devmasters.DT.Util.ToDateTime(expiration, "yyyy-MM-ddTHH:mm:ss");
if (string.IsNullOrEmpty(query))
{
return(Json(ApiResponseStatus.Error(-99, "No query"), JsonRequestBehavior.AllowGet));
}
var wd2 = db.WatchDogs.AsNoTracking().Where(m => m.Name == wdName).FirstOrDefault();
if (wd2 != null)
{
wd2.SearchTerm = query;
wd2.Expires = expirDate;
wd2.Save();
}
else
{
var dt = dataType;
HlidacStatu.Lib.Data.WatchDog wd = new HlidacStatu.Lib.Data.WatchDog();
wd.Created = DateTime.Now;
wd.UserId = apiAuth.ApiCall.UserId;
wd.StatusId = 1;
wd.SearchTerm = query;
wd.PeriodId = 2; //daily
wd.FocusId = 0;
wd.Name = wdName;
wd.Expires = expirDate;
wd.SpecificContact = "HTTPPOSTBACK";
if (dt.ToLower() == typeof(Smlouva).Name.ToLower())
{
wd.dataType = typeof(Smlouva).Name;
}
else if (dt.ToLower() == typeof(VerejnaZakazka).Name.ToLower())
{
wd.dataType = typeof(VerejnaZakazka).Name;
}
else if (dt.ToLower().StartsWith(typeof(HlidacStatu.Lib.Data.External.DataSets.DataSet).Name.ToLower()))
{
var dataSetId = dt.Replace("DataSet.", "");
if (HlidacStatu.Lib.Data.External.DataSets.DataSet.ExistsDataset(dataSetId) == false)
{
HlidacStatu.Util.Consts.Logger.Error("AddWd - try to hack, wrong dataType = " + dataType + "." + dataSetId);
throw new ArgumentOutOfRangeException("AddWd - try to hack, wrong dataType = " + dataType + "." + dataSetId);
}
wd.dataType = typeof(HlidacStatu.Lib.Data.External.DataSets.DataSet).Name + "." + dataSetId;
}
else if (dt == WatchDog.AllDbDataType)
{
wd.dataType = dt;
}
else
{
HlidacStatu.Util.Consts.Logger.Error("AddWd - try to hack, wrong dataType = " + dataType);
throw new ArgumentOutOfRangeException("AddWd - try to hack, wrong dataType = " + dataType);
}
wd.Save();
}
break;
case "delete":
case "disable":
case "get":
case "enable":
var wd1 = db.WatchDogs.AsNoTracking().Where(m => m.Name == wdName).FirstOrDefault();
if (wd1 == null)
{
return(Json(ApiResponseStatus.Error(-404, "Watchdog not found"), JsonRequestBehavior.AllowGet));
}
if (id == "delete")
{
wd1.Delete();
return(Json(new { Ok = true }, JsonRequestBehavior.AllowGet));
}
if (id == "disable")
{
wd1.StatusId = 0;
}
if (id == "delete")
{
wd1.StatusId = 1;
}
if (id == "get")
{
return(Content(Newtonsoft.Json.JsonConvert.SerializeObject(new { id = wd1.Name.Replace("APIID:", ""), expiration = wd1.Expires, query = wd1.SearchTerm }), "text/json"));
}
wd1.Save();
break;
default:
break;
}
}
return(Json(new { Ok = true }, JsonRequestBehavior.AllowGet));
}
}
private static OsobaEvent UpdateEvent(OsobaEvent eventToUpdate, OsobaEvent osobaEvent, string user, DbEntities db)
{
if (eventToUpdate is null)
{
throw new ArgumentNullException(nameof(eventToUpdate), "Argument can't be null");
}
if (osobaEvent is null)
{
throw new ArgumentNullException(nameof(osobaEvent), "Argument can't be null");
}
if (db is null)
{
throw new ArgumentNullException(nameof(db), "Argument can't be null");
}
var eventOriginal = eventToUpdate.ShallowCopy();
if (!string.IsNullOrWhiteSpace(osobaEvent.Ico))
{
eventToUpdate.Ico = osobaEvent.Ico;
}
if (osobaEvent.OsobaId > 0)
{
eventToUpdate.OsobaId = osobaEvent.OsobaId;
}
eventToUpdate.DatumOd = osobaEvent.DatumOd;
eventToUpdate.DatumDo = osobaEvent.DatumDo;
eventToUpdate.Organizace = ParseTools.NormalizaceStranaShortName(osobaEvent.Organizace);
eventToUpdate.AddInfoNum = osobaEvent.AddInfoNum;
eventToUpdate.AddInfo = osobaEvent.AddInfo;
eventToUpdate.Title = osobaEvent.Title;
eventToUpdate.Type = osobaEvent.Type;
eventToUpdate.Zdroj = osobaEvent.Zdroj;
eventToUpdate.Status = osobaEvent.Status;
eventToUpdate.CEO = osobaEvent.CEO;
eventToUpdate.Created = DateTime.Now;
db.SaveChanges();
if (osobaEvent.OsobaId > 0)
{
Osoby.GetById.Get(osobaEvent.OsobaId).FlushCache();
}
Audit.Add(Audit.Operations.Update, user, eventToUpdate, eventOriginal);
return(eventToUpdate);
}
public static Invoices CreateNew(
Lib.Data.InvoiceItems.ShopItem sluzba,
string adresa,
string mesto,
string jmenoFirmy,
string ICO,
string jmenoOsoby,
string DIC,
string PSC,
string userId,
string username,
bool sendEmail = true
)
{
using (Lib.Data.DbEntities db = new DbEntities())
{
var obj = new Lib.Data.Invoices();
obj.Address = adresa;
obj.City = mesto;
obj.Company = jmenoFirmy;
obj.CompanyID = ICO;
obj.Country = "CZ";
obj.Created = DateTime.Now;
obj.FirstName = jmenoOsoby;
obj.InvoiceNumber = (db.Invoices.Count() + 1).ToString();
obj.Status = (int)Lib.Data.Invoices.InvoiceStatus.New;
obj.Text = "Služby serveru HlidacStatu.cz";
obj.VatID = DIC;
obj.Zip = PSC;
obj.ID_Customer = userId;
var ii = new InvoiceItems()
{
ID_ShopItem = (int)sluzba,
Expires = DateTime.Now.AddYears(1),
Name = "HlidacStatu.cz - " + sluzba.ToNiceDisplayName(),
Invoices = obj,
VAT = 1.21m,
Created = DateTime.Now,
};
switch (sluzba)
{
case Lib.Data.InvoiceItems.ShopItem.Zakladni:
ii.Price = 14900;
break;
case Lib.Data.InvoiceItems.ShopItem.Kompletni:
ii.Price = 29900;
break;
case Lib.Data.InvoiceItems.ShopItem.NGO:
default:
ii.Price = 0;
break;
}
obj.InvoiceItems = new InvoiceItems[] { ii };
db.Invoices.Add(obj);
db.InvoiceItems.Add(ii);
if (sendEmail)
{
try
{
using (MailMessage msg = new MailMessage("*****@*****.**", "*****@*****.**"))
{
using (SmtpClient smtp = new SmtpClient())
{
msg.Subject = "Objednavka " + sluzba.ToNiceDisplayName();
msg.Body = @"ico:" + ICO + "\n"
+ "firma:" + jmenoFirmy + "\n"
+ "jmeno:" + jmenoOsoby + "\n"
+ "email:" + username + "\n"
+ "userid:" + userId + "\n"
;
msg.BodyEncoding = System.Text.Encoding.UTF8;
msg.SubjectEncoding = System.Text.Encoding.UTF8;
HlidacStatu.Util.Consts.Logger.Info("Sending email to " + msg.To);
//msg.Bcc.Add("*****@*****.**");
smtp.Send(msg);
}
}
}
catch (Exception e)
{
HlidacStatu.Util.Consts.Logger.Error("Send email", e);
}
}
db.SaveChanges();
return(obj);
}
}