public JsonResult update(int id, int idCategory, int idBrand, string codeUnit, string name, bool divisible,
string divisibleCodeUnit, int divisibleNumberParts, bool perishable, bool traceable,
string barcodeType, IList <ENProductProperty> listProperty, IList <ENProductProperty> listPropertyDelete)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspGEProductSearch_Result data = new uspGEProductSearch_Result();
data.idProduct = id;
data.idCategory = idCategory;
data.idBrand = idBrand;
data.codeUnit = codeUnit;
data.name = name;
data.divisible = divisible;
data.divisibleCodeUnit = divisibleCodeUnit;
data.divisibleNumberParts = divisibleNumberParts;
data.perishable = perishable;
data.traceable = traceable;
data.barcodeType = barcodeType;
DAProduct product = new DAProduct(PUser);
ENResult result = product.update(data, listProperty, listPropertyDelete);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult update(int id, int idStore, string name)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspTRCashSearch_Result data = new uspTRCashSearch_Result();
data.idCash = id;
data.idStore = idStore;
data.name = name;
DACash cash = new DACash(PUser);
ENResult result = cash.update(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult update(int idMovement, int idCash, int idSale, DateTime date, string movementType,
decimal amount, decimal amountOpening, decimal amountClosing, string concept)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspTRCashMovementSearch_Result data = new uspTRCashMovementSearch_Result();
data.idMovement = idMovement;
data.idCash = idCash;
data.idSale = idSale;
data.date = date;
data.movementType = movementType;
data.amount = amount;
data.amountOpening = amountOpening;
data.amountClosing = amountClosing;
data.concept = concept;
DACashMovement movement = new DACashMovement(PUser);
ENResult result = movement.update(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult update(int id, string name, string documentType, string documentNumber, string address,
string phoneNumber, string email, string contactPerson)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspPUSupplierSearch_Result data = new uspPUSupplierSearch_Result();
data.idSupplier = id;
data.name = name;
data.documentType = documentType;
data.documentNumber = documentNumber;
data.address = address;
data.phoneNumber = phoneNumber;
data.email = email;
data.contactPerson = contactPerson;
DASupplier supplier = new DASupplier(PUser);
ENResult result = supplier.update(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult update(decimal IGV, decimal percentageMinWholesalePrice, decimal percentageMinRetailPrice)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspGEGlobalParametersSearch_Result data = new uspGEGlobalParametersSearch_Result();
data.IGV = IGV;
data.percentageMinWholesalePrice = percentageMinWholesalePrice;
data.percentageMinRetailPrice = percentageMinRetailPrice;
DAGlobalParameters globalParameters = new DAGlobalParameters(PUser);
ENResult result = globalParameters.update(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult update(int idSale, string documentType, string documentNumber, DateTime date, string status)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspSASaleSearch_Result data = new uspSASaleSearch_Result();
data.idSale = idSale;
data.documentType = documentType;
data.documentNumber = documentNumber;
data.date = date;
data.status = status;
DASale sale = new DASale(PUser);
ENResult result = sale.update(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult update(int id, string name, string address, string processSale)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspGEStoreSearch_Result data = new uspGEStoreSearch_Result();
data.idStore = id;
data.name = name;
data.address = address;
data.processSale = processSale;
DAStore store = new DAStore(PUser);
ENResult result = store.update(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult update(int idProduct, decimal purchasePrice, decimal wholesalePrice, decimal wholesaleMinPrice,
decimal retailPrice, decimal retailMinPrice, decimal partPrice)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspGEProductPriceSearch_Result data = new uspGEProductPriceSearch_Result();
data.idProduct = idProduct;
data.purchasePrice = purchasePrice;
data.wholesalePrice = wholesalePrice;
data.wholesaleMinPrice = wholesaleMinPrice;
data.retailPrice = retailPrice;
data.retailMinPrice = retailMinPrice;
data.partPrice = partPrice;
DAProductPrice productPrice = new DAProductPrice(PUser);
ENResult result = productPrice.update(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult insert(int idStore, int idSupplier, string entryType, DateTime date, IList <ENEntryDetail> listDetail)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspWAEntrySearch_Result data = new uspWAEntrySearch_Result();
data.idStore = idStore;
data.idSupplier = idSupplier;
data.entryType = entryType;
data.date = date;
DAEntry entry = new DAEntry(PUser);
ENResult result = entry.insert(data, listDetail);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public IResult CreateResult(ENResult classID, int sourceID, int targetID, int skillResultID = 0, int skillID = 0, float[] param = null)
{
// 如果是长连接
if (ClientNet.Singleton.IsLongConnecting)
{
Actor actor = ActorManager.Singleton.Lookup(sourceID);
if (null != actor)
{
// 如果托管则 发送服务器 创建result的消息
if (actor.m_isDeposited)
{
MiniServer.Singleton.SendCreateResult_C2BS((int)classID, sourceID, targetID, skillResultID, skillID, param);
}
}
return(null);
}
IResult result = BattleFactory.Singleton.GetBattleContext().CreateResult((int)classID);
if (result == null)
{
Debug.LogWarning("result create fail, classID is " + classID.ToString());
}
else
{
result.SourceID = sourceID;
result.TargetID = targetID;
result.SkillResultID = skillResultID;
result.SkillID = skillID;
}
return(result);
}
public JsonResult PUnexpectedError(Exception ex)
{
ENResult result = new ENResult(2, ex.Message);
result.token = PCreateToken();
return(Json(result));
}
public JsonResult update(int id, int idProduct, string name, string abbreviation, bool required)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspGEProductPropertySearch_Result data = new uspGEProductPropertySearch_Result();
data.idProperty = id;
data.idProduct = idProduct;
data.name = name;
data.abbreviation = abbreviation;
data.required = required;
DAProductProperty property = new DAProductProperty(PUser);
ENResult result = property.update(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult update(string userName, int idProfile, int idStore, string name, string lastname)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspSEUserLogin_Result data = new uspSEUserLogin_Result();
data.userName = userName;
data.idProfile = idProfile;
data.idStore = idStore;
data.name = name;
data.lastname = lastname;
DAUser user = new DAUser(PUser);
ENResult result = user.update(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult login(string userName, string password)
{
try
{
DAUser user = new DAUser(PUser);
ENResult result = user.login(userName, password);
result.token = PCreateToken();
return(Json(result));
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public ENResult searchDetail(int idEntry)
{
try
{
using (erpStoreEntities db = new erpStoreEntities())
{
List <uspWAEntryDetailSearch_Result> detail = db.uspWAEntryDetailSearch(idEntry, PUser, PReturnCode, PReturnMessage).ToList();
ENResult propertyResult = searchDetailProperty(idEntry);
List <uspWAEntryDetailPropertySearch_Result> listProperty = (List <uspWAEntryDetailPropertySearch_Result>)propertyResult.result;
List <ENEntryDetail> listProduct = new List <ENEntryDetail>();
for (int i = 0; i < detail.Count; i++)
{
ENEntryDetail temp = new ENEntryDetail();
temp.idEntry = detail[i].idEntry;
temp.idProduct = (int)detail[i].idProduct;
temp.idEntryDetail = detail[i].idEntryDetail;
temp.name = detail[i].name;
temp.perishable = (bool)detail[i].perishable;
temp.quantity = detail[i].quantity;
temp.purchasePrice = detail[i].purchasePrice;
if (detail[i].dueDate != null)
{
temp.dueDate = (DateTime)detail[i].dueDate;
}
List <ENEntryDetailProperty> tempListProperty = new List <ENEntryDetailProperty>();
List <uspWAEntryDetailPropertySearch_Result> tempListPropertySelect = listProperty.Where(row => row.idEntry == temp.idEntry && row.idEntryDetail == temp.idEntryDetail).ToList();
for (int j = 0; j < tempListPropertySelect.Count; j++)
{
ENEntryDetailProperty tempProperty = new ENEntryDetailProperty();
tempProperty.idEntry = tempListPropertySelect[j].idEntry;
tempProperty.idEntryDetail = tempListPropertySelect[j].idEntryDetail;
tempProperty.idProduct = tempListPropertySelect[j].idProduct;
tempProperty.idProperty = tempListPropertySelect[j].idProperty;
tempProperty.value = tempListPropertySelect[j].value;
tempProperty.name = tempListPropertySelect[j].name;
tempListProperty.Add(tempProperty);
}
temp.listDetailProperty = tempListProperty;
listProduct.Add(temp);
}
return(new ENResult(Convert.ToInt32(PReturnCode.Value), Convert.ToString(PReturnMessage.Value), listProduct));
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult search()
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
DAStore store = new DAStore(PUser);
ENResult result = store.search();
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult search(int idProduct)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
DAProductProperty property = new DAProductProperty(PUser);
ENResult result = property.search(idProduct);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult insert(string documentType, string documentNumber, DateTime date, int ticket, string status, Array detail)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspSASaleSearch_Result data = new uspSASaleSearch_Result();
data.documentType = documentType;
data.documentNumber = documentNumber;
data.date = date;
data.ticket = ticket;
data.status = status;
List <uspSASaleDetailSearch_Result> saleDetail = new List <uspSASaleDetailSearch_Result>();
for (int i = 0; i < detail.Length; i++)
{
if (detail != null)
{
saleDetail[i].idSale = data.idSale;
saleDetail[i].idProduct = Convert.ToInt32(detail);
saleDetail[i].quantity = Convert.ToInt32(detail);
saleDetail[i].unitPrice = Convert.ToDecimal(detail);
saleDetail[i].partSale = Convert.ToBoolean(detail);
}
}
DASale sale = new DASale(PUser);
ENResult result = sale.insert(data, saleDetail);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult updatePassword(string userName, string passNew)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspSEUserLogin_Result data = new uspSEUserLogin_Result();
data.userName = userName;
DAUser user = new DAUser(PUser);
ENResult result = user.updatePassword(data, passNew);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult delete(int id)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspGEStoreSearch_Result data = new uspGEStoreSearch_Result();
data.idStore = id;
DAStore store = new DAStore(PUser);
ENResult result = store.delete(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult insert(string name)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspSEProfileSearch_Result data = new uspSEProfileSearch_Result();
data.name = name;
DAProfile profile = new DAProfile(PUser);
ENResult result = profile.insert(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult delete(string code)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspSEActionSearch_Result data = new uspSEActionSearch_Result();
data.code = code;
DAAction action = new DAAction(PUser);
ENResult result = action.delete(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult update(int id, string name)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspGEBrandSearch_Result data = new uspGEBrandSearch_Result();
data.idBrand = id;
data.name = name;
DABrand brand = new DABrand(PUser);
ENResult result = brand.update(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult delete(int idProduct, string productBarcode)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspGEProductBarcodeSearch_Result data = new uspGEProductBarcodeSearch_Result();
data.idProduct = idProduct;
data.barcode = productBarcode;
DAProductBarcode barcode = new DAProductBarcode(PUser);
ENResult result = barcode.delete(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult insert(int idProfile, string code)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspSEProfileActionSearch_Result data = new uspSEProfileActionSearch_Result();
data.idProfile = idProfile;
data.code = code;
DAProfileAction profileAction = new DAProfileAction(PUser);
ENResult result = profileAction.insert(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult delete(int idMovement, int idCash)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspTRCashMovementSearch_Result data = new uspTRCashMovementSearch_Result();
data.idMovement = idMovement;
data.idCash = idCash;
DACashMovement movement = new DACashMovement(PUser);
ENResult result = movement.delete(data);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
public JsonResult update(string codeOld, string codeNew, string name)
{
try
{
if (PValidateHeader(Request.Headers["Authorization"].ToString()))
{
uspGEUnitSearch_Result data = new uspGEUnitSearch_Result();
data.codeUnit = codeOld;
data.name = name;
DAUnit unit = new DAUnit(PUser);
ENResult result = unit.update(data, codeNew);
result.token = PCreateToken();
return(Json(result));
}
else
{
return(PSecurityError());
}
}
catch (Exception ex)
{
return(PUnexpectedError(ex));
}
}
