private void insertPackage(string[] pids, string fbId, string username, string[] photos, string packName, DateTime now)
{
//insert package
using (var dbcon = new TourCrowDBEntities())
{
var pack_insert_query = new PACKAGE {
UserFBID = fbId, Date = now, Title = packName
};
dbcon.PACKAGEs.Add(pack_insert_query);
dbcon.SaveChanges();
//( packName.ToString() == null ? Convert.ToString(DateTime.Now) : packName.ToString() )
//get package id
var get_packid = from pckid in dbcon.PACKAGEs
where pckid.UserFBID == fbId.ToString()
select pckid.PackageID;
var packid = get_packid.AsEnumerable().LastOrDefault();
for (int i = 0, j = 0; i < pids.Count() && j < photos.Count(); i++, j++)
{
var userpack_insert_query = new USER_PACKAGE
{
PackageID = Convert.ToInt32(packid),
PlaceID = pids[i],
PhotoKey = photos[i]
};
dbcon.USER_PACKAGE.Add(userpack_insert_query);
dbcon.SaveChanges();
}
}
}
private void AddNewPackage(int idjob)
{
PACKAGE p;
using (CWMEntities cwm = new CWMEntities(EnCon))
{
foreach (ListItem c in chblPrice.Items)
{
if (c.Selected)
{
p = new PACKAGE();
p.IDJOB = idjob;
p.IDPRICE = int.Parse(c.Value);
if ((int)Session["special"] == 0)
{
p.COST = GetCost(c.Value);
}
else
{
p.COST = 0;
}
cwm.AddToPACKAGE(p);
}
}
cwm.SaveChanges();
}
//CrystalReport1 cr = new CrystalReport1();
//cr.SetDataSource(
}
/// <summary>
/// Добавить XML-пакет в список
/// </summary>
/// <param name="dtPackage">Метка даты/времени получения XML-пакета</param>
/// <param name="xmlDoc">XML-документ</param>
/// <returns>Признак выполнения метода</returns>
private int addPackage(DateTime dtPackage, XmlDocument xmlDoc)
{
int iRes = 0;
PACKAGE package;
try {
// добавить текущий пакет
_listPackage.Add(package = new PACKAGE(dtPackage, xmlDoc));
Logging.Logg().Debug(MethodBase.GetCurrentMethod(), string.Format(@"добавлен пакет [{0}]", dtPackage), Logging.INDEX_MESSAGE.NOT_SET);
s_Statistic.SetAt(STATISTIC.INDEX_ITEM.DATETIME_PACKAGE_LAST_RECIEVED, package.m_dtRecieved);
s_Statistic.SetAt(STATISTIC.INDEX_ITEM.LENGTH_PACKAGE_LAST_RECIEVED, package.m_xmlSource.InnerXml.Length);
s_Statistic.Counter(STATISTIC.INDEX_ITEM.COUNT_PACKAGE_RECIEVED);
if (package.m_state == PACKAGE.STATE.PARSED)
{
s_Statistic.Counter(STATISTIC.INDEX_ITEM.COUNT_PACKAGE_PARSED);
}
else
{
;
}
} catch (Exception e) {
iRes = -1;
Logging.Logg().Exception(e, string.Format(@"Добавление пакета дата/время получения={0} и статистики для него", dtPackage), Logging.INDEX_MESSAGE.NOT_SET);
}
return(iRes);
}
public ActionResult DeleteConfirmed(string id)
{
PACKAGE package = db.PACKAGEs.Find(id);
db.PACKAGEs.Remove(package);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /PACKAGEAdmin/Details/5
public ActionResult Details(string id = null)
{
PACKAGE package = db.PACKAGEs.Find(id);
if (package == null)
{
return(HttpNotFound());
}
return(View(package));
}
/// <summary>
/// Create a new PACKAGE object.
/// </summary>
/// <param name="id">Initial value of ID.</param>
/// <param name="iDJOB">Initial value of IDJOB.</param>
/// <param name="iDPRICE">Initial value of IDPRICE.</param>
/// <param name="cOST">Initial value of COST.</param>
public static PACKAGE CreatePACKAGE(int id, int iDJOB, int iDPRICE, int cOST)
{
PACKAGE pACKAGE = new PACKAGE();
pACKAGE.ID = id;
pACKAGE.IDJOB = iDJOB;
pACKAGE.IDPRICE = iDPRICE;
pACKAGE.COST = cOST;
return(pACKAGE);
}
public ActionResult Edit(PACKAGE package)
{
if (ModelState.IsValid)
{
db.Entry(package).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(package));
}
public ActionResult Create(PACKAGE package)
{
if (ModelState.IsValid)
{
db.PACKAGEs.Add(package);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(package);
}
public ActionResult Create(PACKAGE package)
{
if (ModelState.IsValid)
{
db.PACKAGEs.Add(package);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(package));
}
/// <summary>
/// Добавить XML-пакет в список
/// </summary>
/// <param name="dtPackage">Метка даты/времени получения XML-пакета</param>
/// <param name="xmlDoc">XML-документ</param>
/// <returns>Признак выполнения метода</returns>
private int addPackage(DateTime dtPackage, XmlDocument xmlDoc)
{
int iRes = 0;
PACKAGE package;
// определить лимит даты/времени хранения пакетов времени выполнения
DateTime dtLimit = dtPackage - TS_HISTORY_RUNTIME;
//список индексов элементов(пакетов) для удаления
List <int> listIndxToRemove = new List <int>();
for (int i = 0; i < _listPackage.Count; i++)
{
if ((dtLimit - _listPackage[i].m_dtRecieved).TotalSeconds > 0)
{
listIndxToRemove.Add(i);
}
else
{
;
}
}
// удалить пакеты дата/время получения которых больше, чем "лимит"
listIndxToRemove.ForEach(indx => {
Logging.Logg().Debug(MethodBase.GetCurrentMethod(), string.Format(@"удален пакет {0}", _listPackage[indx].m_dtRecieved), Logging.INDEX_MESSAGE.NOT_SET);
_listPackage.RemoveAt(indx);
});
// добавить текущий пакет (даже, если он не удовлетворяет критерию "лимит")
try {
_listPackage.Add(package = new PACKAGE(dtPackage, xmlDoc));
s_Statistic.SetAt(STATISTIC.INDEX_ITEM.DATETIME_PACKAGE_LAST_RECIEVED, package.m_dtRecieved);
s_Statistic.SetAt(STATISTIC.INDEX_ITEM.LENGTH_PACKAGE_LAST_RECIEVED, package.m_tableValues.Rows.Count);
s_Statistic.Counter(STATISTIC.INDEX_ITEM.COUNT_PACKAGE_RECIEVED);
if (package.m_state == PACKAGE.STATE.PARSED)
{
s_Statistic.Counter(STATISTIC.INDEX_ITEM.COUNT_PACKAGE_PARSED);
}
else
{
;
}
} catch (Exception e) {
iRes = -1;
Logging.Logg().Exception(e, string.Format(@"Добавление пакета дата/время получения={0} и статистики для него", dtPackage), Logging.INDEX_MESSAGE.NOT_SET);
}
return(iRes);
}
private void AddNewPackage(int idjob)
{
PACKAGE p;
using (CWMEntities cwm = new CWMEntities(EnCon))
{
foreach (ListItem c in chblPrice.Items)
{
if (c.Selected)
{
p = new PACKAGE();
p.IDJOB = idjob;
p.IDPRICE = int.Parse(c.Value);
if (ddlSpecial.Text == "НЕТ")
{
p.COST = GetCost(c.Value);
}
else
{
p.COST = 0;
}
cwm.AddToPACKAGE(p);
}
}
DeletedServices = Session["delp"] as List <int>;
foreach (int i in DeletedServices)
{
p = new PACKAGE();
p.IDJOB = idjob;
p.IDPRICE = int.Parse(i.ToString());
if (ddlSpecial.Text == "НЕТ")
{
p.COST = GetCost(i.ToString());
}
else
{
p.COST = 0;
}
p.DELETED = true;
cwm.AddToPACKAGE(p);
}
cwm.SaveChanges();
}
}
// =========================================== INSERT =============================================
public void Insert(string data1, int data2)
{
PACKAGE call = new PACKAGE();
{
call.NAME = data1;
call.PRICE = data2;
};
try
{
context.PACKAGES.Add(call);
var result = context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
MessageBox.Show(ex.StackTrace);
System.Console.Write(ex.InnerException);
}
}
public static extern PACKAGE base64encode(PACKAGE src);
public static extern PACKAGE desdecode(PACKAGE key, PACKAGE encrypted);
public static extern PACKAGE hashkey(PACKAGE src);
public static extern PACKAGE desencode(PACKAGE key, PACKAGE src);
public static extern PACKAGE dhexchange(PACKAGE key);
public static extern PACKAGE dhsecret(PACKAGE key, PACKAGE src);
public static extern PACKAGE hmac_hash(PACKAGE key, PACKAGE src);
public static extern PACKAGE hmac64(PACKAGE key1, PACKAGE key2);
public static extern PACKAGE hexdecode(PACKAGE encrypted);
public static extern PACKAGE hexencode(PACKAGE src);
public ActionResult Edit(PACKAGE package)
{
if (ModelState.IsValid)
{
db.Entry(package).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(package);
}
public static extern PACKAGE base64decode(PACKAGE encrypted);
/// <summary>
///
/// </summary>
/// <syntax>
/// Объявление-контейнера
/// : [ Спецификатор-контейнера ] unit Имя-контейнера [ FormalGenerics ]
/// { Директива-контейнера }
/// is
/// Тело-контейнера
/// [ invariant Список-предикатов ]
/// end
///
/// Спецификатор-контейнера
/// : ref | val | concurrent | abstract
///
/// Имя-контейнера
/// : Составное-имя
///
/// Директива-контейнера
/// : Директива-наследования
/// | Директива-использования
///
/// Директива-наследования
/// : extend Базовый-контейнер { , Базовый-контейнер }
///
/// Базовый-контейнер
/// : [ ~ ] UnitTypeName
///
/// Тело-контейнера
/// : { Объявление }
/// </syntax>
/// <returns></returns>
public static void parse(bool hidden, bool final, bool abstr, iSCOPE context)
{
Debug.Indent();
Debug.WriteLine("Entering UNIT.parse");
bool ref_val = false; // unit is reference by default
bool concurrent = false;
UNIT unit = null;
Token token = get();
Token begin = token;
TokenCode code = TokenCode.Unit;
switch (token.code)
{
case TokenCode.Ref:
ref_val = true;
forget();
code = getUnitKeyword();
break;
case TokenCode.Val:
ref_val = false;
forget();
code = getUnitKeyword();
break;
case TokenCode.Abstract:
abstr = true;
forget();
code = getUnitKeyword();
break;
case TokenCode.Concurrent:
concurrent = true;
forget();
code = getUnitKeyword();
break;
case TokenCode.Unit:
code = TokenCode.Unit;
forget();
break;
case TokenCode.Package:
code = TokenCode.Package;
forget();
break;
}
// 1. Unit header
token = expect(TokenCode.Identifier);
Token compoundName = IDENTIFIER.parseCompoundName(token);
if (code == TokenCode.Package)
{
if (!ENTITY.options.optConfig)
{
warning(token, "no-config");
unit = new UNIT(compoundName.image, ref_val, abstr, concurrent);
}
else
{
unit = new PACKAGE(compoundName.image, ref_val, abstr, concurrent);
}
}
else
{
unit = new UNIT(compoundName.image, ref_val, abstr, concurrent);
}
Debug.WriteLine("======================" + compoundName.image);
unit.parent = context.self;
unit.setSpecs(hidden, final);
Context.enter(unit);
// 2. Generic parameters
token = get();
if (token.code == TokenCode.LBracket)
{
forget();
while (true)
{
var generic = FORMAL_GENERIC.parse(unit);
unit.add(generic);
token = get();
switch (token.code)
{
case TokenCode.Comma:
case TokenCode.Semicolon: forget(); continue;
case TokenCode.RBracket: forget(); goto Finish;
default: { /* Syntax error */ break; }
}
}
Finish:
;
}
// Possible unit alias
token = get();
if (token.code == TokenCode.Alias)
{
forget();
token = expect(TokenCode.Identifier);
unit.alias = new IDENTIFIER(token);
}
// 3. Unit directives: inheritance
token = get();
if (token.code == TokenCode.Extend)
{
forget();
while (true)
{
PARENT parent = PARENT.parse(unit);
if (parent == null) /* Syntax error */ break {
;
}
unit.add(parent);
token = get();
switch (token.code)
{
case TokenCode.Comma:
case TokenCode.Semicolon:
case TokenCode.EOL:
forget();
continue;
default:
goto Use;
}
}
}
/// <summary>
/// There are no comments for PACKAGE in the schema.
/// </summary>
public void AddToPACKAGE(PACKAGE pACKAGE)
{
base.AddObject("PACKAGE", pACKAGE);
}
public static extern PACKAGE hmac_sha1(PACKAGE src);
public static extern void pfree(PACKAGE src);
