/// <summary>
/// Page Load Event, pulls Customer data from QuickBooks using SDK and Binds it to Grid
/// </summary>
/// <param name="sender">Sender of the event.</param>
/// <param name="e">Event Args.</param>
protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.Session.Keys.Count > 0)
{
realmId = HttpContext.Current.Session["realm"].ToString();
accessToken = HttpContext.Current.Session["accessToken"].ToString();
accessTokenSecret = HttpContext.Current.Session["accessTokenSecret"].ToString();
consumerKey = ConfigurationManager.AppSettings["consumerKey"].ToString(CultureInfo.InvariantCulture);
consumerSecret = ConfigurationManager.AppSettings["consumerSecret"];
dataSourcetype = HttpContext.Current.Session["dataSource"].ToString().ToLower() == "qbd" ? IntuitServicesType.QBD : IntuitServicesType.QBO;
OAuthRequestValidator oauthValidator = new OAuthRequestValidator(accessToken, accessTokenSecret, consumerKey, consumerSecret);
ServiceContext context = new ServiceContext(oauthValidator, realmId, dataSourcetype);
DataServices commonService = new DataServices(context);
try
{
switch(dataSourcetype)
{
case IntuitServicesType.QBD:
var qbdCustomerQuery = new Intuit.Ipp.Data.Qbd.CustomerQuery();
qbdCustomerQuery.ItemElementName = Intuit.Ipp.Data.Qbd.ItemChoiceType4.StartPage;
qbdCustomerQuery.Item = "1";
qbdCustomerQuery.ChunkSize = "10";
var qbdCustomers = qbdCustomerQuery.ExecuteQuery<Intuit.Ipp.Data.Qbd.Customer>(context).ToList();
grdQuickBooksCustomers.DataSource = qbdCustomers;
break;
case IntuitServicesType.QBO:
var qboCustomer = new Intuit.Ipp.Data.Qbo.Customer();
var qboCustomers = commonService.FindAll(qboCustomer, 1, 10).ToList();
grdQuickBooksCustomers.DataSource = qboCustomers;
break;
}
grdQuickBooksCustomers.DataBind();
if (grdQuickBooksCustomers.Rows.Count > 0)
{
GridLocation.Visible = true;
MessageLocation.Visible = false;
}
else
{
GridLocation.Visible = false;
MessageLocation.Visible = true;
}
}
catch (Intuit.Ipp.Exception.InvalidTokenException)
{
//Remove the Oauth access token from the OauthAccessTokenStorage.xml
OauthAccessTokenStorageHelper.RemoveInvalidOauthAccessToken(Session["FriendlyEmail"].ToString(), Page);
Session["show"] = true;
Response.Redirect("~/Default.aspx");
}
}
}
/// <summary>
/// Page Load Event, pulls Customer data from QuickBooks using SDK and Binds it to Grid
/// </summary>
/// <param name="sender">Sender of the event.</param>
/// <param name="e">Event Args.</param>
protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.Session.Keys.Count > 0)
{
String realmId = HttpContext.Current.Session["realm"].ToString();
String accessToken = HttpContext.Current.Session["accessToken"].ToString();
String accessTokenSecret = HttpContext.Current.Session["accessTokenSecret"].ToString();
String consumerKey = ConfigurationManager.AppSettings["consumerKey"].ToString(CultureInfo.InvariantCulture);
String consumerSecret = ConfigurationManager.AppSettings["consumerSecret"].ToString(CultureInfo.InvariantCulture);
IntuitServicesType intuitServiceType = (IntuitServicesType)HttpContext.Current.Session["intuitServiceType"];
OAuthRequestValidator oauthValidator = new OAuthRequestValidator(accessToken, accessTokenSecret, consumerKey, consumerSecret);
ServiceContext context = new ServiceContext(oauthValidator, realmId, intuitServiceType);
DataServices commonService = new DataServices(context);
try
{
switch(intuitServiceType )
{
case IntuitServicesType.QBO:
Intuit.Ipp.Data.Qbo.Customer qboCustomer = new Intuit.Ipp.Data.Qbo.Customer();
IEnumerable<Intuit.Ipp.Data.Qbo.Customer> qboCustomers = commonService.FindAll(qboCustomer, 1, 10) as IEnumerable<Intuit.Ipp.Data.Qbo.Customer>;
grdQuickBooksCustomers.DataSource = qboCustomers;
break;
case IntuitServicesType.QBD:
//FindAll() is a GET operation for QBD, so we need to use the respective Query object instead to POST the start page and records per page (ChunkSize).
Intuit.Ipp.Data.Qbd.CustomerQuery qbdCustomerQuery = new Intuit.Ipp.Data.Qbd.CustomerQuery();
qbdCustomerQuery.ItemElementName = Intuit.Ipp.Data.Qbd.ItemChoiceType4.StartPage;
qbdCustomerQuery.Item = "1";
qbdCustomerQuery.ChunkSize = "10";
IEnumerable<Intuit.Ipp.Data.Qbd.Customer> qbdCustomers = qbdCustomerQuery.ExecuteQuery<Intuit.Ipp.Data.Qbd.Customer>(context) as IEnumerable<Intuit.Ipp.Data.Qbd.Customer>;
grdQuickBooksCustomers.DataSource = qbdCustomers;
break;
default:
throw new Exception("Data Source not defined.");
}
grdQuickBooksCustomers.DataBind();
if (grdQuickBooksCustomers.Rows.Count > 0)
{
GridLocation.Visible = true;
MessageLocation.Visible = false;
}
else
{
GridLocation.Visible = false;
MessageLocation.Visible = true;
}
}
catch
{
throw;
}
}
}
/// <summary>
/// Creates an instance of JobProductVm with given model, parent and data service
/// </summary>
/// <param name="model"></param>
/// <param name="parentVm"></param>
/// <param name="jobDataService"></param>
public JobProductVm(Model.Product model, ProductGroupVm parentVm, DataServices.JobDataService jobDataService)
: base(model, parentVm)
{
CreateNewJob = new Commands.Command
(vm =>
{
var job = Soheil.Core.ViewModels.PP.Editor.PPEditorJob.CreateForProduct(model, jobDataService);
((Soheil.Core.ViewModels.PP.Editor.JobEditorVm)vm).JobList.Add(job);
}
);
}
public static PPEditorJob CreateForProduct(Model.Product productModel, DataServices.JobDataService jobDataService)
{
return new PPEditorJob(new Model.Job
{
Code = productModel.Code,
Deadline = DateTime.Now.AddMonths(1),
FPC = productModel.DefaultFpc,
ProductRework = productModel.MainProductRework,
Quantity = 0,
ReleaseTime = DateTime.Now,
Weight = 1,
}, jobDataService);
}
/// <summary>
/// Creates an instance of JobProductGroupVm with given model and data service
/// </summary>
/// <param name="model">products and product reworks of this model are also in use</param>
/// <param name="jobDataService"></param>
public JobProductGroupVm(Model.ProductGroup model, DataServices.JobDataService jobDataService)
{
if (model == null) return;
_id = model.Id;
Name = model.Name;
Code = model.Code;
foreach (var p_model in model.Products)
{
var p = new JobProductVm(p_model, this, jobDataService);
Products.Add(p);
}
}
public ConnectorVm(Model.Connector model, StateVm start, StateVm end, DataServices.ConnectorDataService connectorDataService, bool isLoose = false)
{
Model = model;
Start = start;
End = end;
IsLoose = isLoose;
DeleteCommand = new Commands.Command(o =>
{
if(Model != null)
connectorDataService.DeleteModel(Model);
if (ConnectorRemoved != null)
ConnectorRemoved();
});
}
public PPEditorJob(Model.Job model, DataServices.JobDataService jobDataService)
{
_jobDataService = jobDataService;
Replications.Add(model);
Deadline = model.Deadline;
ReleaseDT = model.ReleaseTime;
Code = model.Code;
Quantity = model.Quantity;
Weight = model.Weight;
Description = model.Description;
FpcId = model.FPC.Id;
Product = new ProductVm(model.ProductRework.Product, null);
ProductRework = new ProductReworkVm(model.ProductRework, Product);
initializeCommands();
}
public ActionResult Details(string Id)
{
DetailViewModel model = new DetailViewModel(Id);
// set counter property for popu
SetViewedProductCounter();
// check cookie if has AssistKey, use to add to facet, else generate new
string _assistKey = null;
var hasCookiedKey = GetCookie("Canvas.Ecomm.AssistKey");
if (hasCookiedKey != null)
{
_assistKey = hasCookiedKey;
}
else
{
_assistKey = RandomStrings(6);
SetCookie("Canvas.Ecomm.AssistKey", _assistKey, false);
}
var existingProducts = GetCookie("Canvas.Ecomm.Products");
if (existingProducts != null)
{
existingProducts = existingProducts.Trim() + "," + model.Product.SKU;
SetCookie("Canvas.Ecomm.Products", existingProducts, true);
}
else
{
existingProducts = model.Product.SKU;
SetCookie("Canvas.Ecomm.Products", existingProducts, true);
}
//set xconnect custom facet with product info, using AssistKey
// Save product viewed to xconnect facet
//find record
//if exists, increment view count
//else add to data
var uniqueId = string.Format("{0}-{1}-{2}", _assistKey, model.Product.ID, model.Product.SKU);
if (DataServices.Exists(uniqueId))
{
var drX = DataServices.Find(uniqueId);
drX.EngagementScore = drX.EngagementScore + 1;
DataServices.Update(drX);
}
else
{
var dr = new DataRecord {
ID = uniqueId, AssistKey = _assistKey, Product = model.Product, EngagementScore = 1
};
DataServices.Add(dr);
}
return(View(model));
}
public DataServices getDataService()
{
if (qbds == null)
{
qbds = new DataServices(getServiceContext());
}
return qbds;
}
private static string GetMapInfoFromService(String servicename, String serviceitem, String serviceparams)
{
return(DataServices.CallService(servicename, serviceitem, serviceparams));
}
public EmployeesController(DataServices services)
{
_services = services;
}
private void fillJeDetailHead(string docNum, int RowNum)
{
txDS.Value = "0.00";
txCS.Value = "0.00";
txDD.Value = "";
txDN.Value = "";
txRem.Value = "";
txRef1.Value = "";
txRef2.Value = "";
txPJ.Value = "";
txCJ.Value = "";
dtDet.Rows.Clear();
string jeType = "PP";
if (optPP.Selected)
{
jeType = "PP";
}
if (optPC.Selected)
{
jeType = "PC";
}
if (optC.Selected)
{
jeType = "C";
}
try
{
if (jeType == "C")
{
btPost.Item.Enabled = false;
}
else
{
btPost.Item.Enabled = true;
}
}
catch { }
if (RowNum > 0)
{
txRem.Value = Convert.ToString(dtHead.GetValue("cRemarks", RowNum - 1));
txRef1.Value = Convert.ToString(dtHead.GetValue("cNum", RowNum - 1));
txPJ.Value = Convert.ToString(dtHead.GetValue("cPostedJE", RowNum - 1));
txCJ.Value = Convert.ToString(dtHead.GetValue("cCanceledJE", RowNum - 1));
oForm.DataSources.UserDataSources.Item("txDD").ValueEx = Convert.ToDateTime(dtHead.GetValue("cDate", RowNum - 1)).ToString("yyyyMMdd");
}
chkPost.Checked = false;
dtPendingJEs.Rows.Clear();
DataServices ds = new DataServices(Program.strConMena);
string strSelect = " Select MenaCode as lineType ,acctCode,acctName,debit ,credit , project ,ocr1 ,ocr2 ,ocr3 ,ocr4 ,ocr5 from [dbo].[JE_PRL_getJEDetRows]('" + docNum + "') ";
dtDet.Rows.Clear();
System.Data.DataTable dtRows = ds.getDataTable(strSelect, "Filling Detail");
if (dtRows != null && dtRows.Rows.Count > 0)
{
int i = 0;
double debit = 0.00;
double credit = 0.00;
foreach (DataRow dr in dtRows.Rows)
{
double lineDebit = 0.00;
double lineCredit = 0.00;
lineDebit = Convert.ToDouble(dr["debit"].ToString());
lineCredit = Convert.ToDouble(dr["credit"].ToString());
debit += lineDebit;
credit += lineCredit;
dtDet.Rows.Add(1);
dtDet.SetValue("cNum", i, i.ToString());
dtDet.SetValue("cType", i, Convert.ToString(dr["lineType"].ToString()));
dtDet.SetValue("cCode", i, Convert.ToString(Program.objHrmsUI.getAcctSys(dr["lineType"].ToString().Replace("-", ""))));
dtDet.SetValue("cName", i, Convert.ToString(Program.objHrmsUI.getAcctName(dr["lineType"].ToString().Replace("-", ""))));
dtDet.SetValue("cDebit", i, Convert.ToString(dr["debit"].ToString()));
dtDet.SetValue("cCredit", i, Convert.ToString(dr["credit"].ToString()));
dtDet.SetValue("cProject", i, Convert.ToString(dr["project"].ToString()));
dtDet.SetValue("cOcr1", i, Convert.ToString(dr["ocr1"].ToString()));
dtDet.SetValue("cOcr2", i, Convert.ToString(dr["ocr2"].ToString()));
dtDet.SetValue("cOcr3", i, Convert.ToString(dr["ocr3"].ToString()));
dtDet.SetValue("cOcr4", i, Convert.ToString(dr["ocr4"].ToString()));
dtDet.SetValue("cOcr5", i, Convert.ToString(dr["ocr5"].ToString()));
i++;
}
mtDet.LoadFromDataSource();
txDS.Value = debit.ToString();
txCS.Value = credit.ToString();
}
mtDet.LoadFromDataSource();
}
private async Task <IEnumerable <ElementDto> > InitElements()
{
IEnumerable <ElementDto> value = await DataServices.GetHelperDataServices().GetAsyncHelper <ElementDto>(GenericSql.ElementsSummaryQuery);
return(value);
}
public MappedWriteHandler(DataServices dataServices)
{
this.dataServices = dataServices;
}
public ModerationServices(DataServices dataServices)
{
_dataServices = dataServices;
}
private Tuple <string, string> PostObjectHandler(string synapsenamespace, string synapseentityname, string data, dynamic connectionObj = null, dynamic transactionObj = null)
{
//27Feb2020-RK
//RMF1 - Remove Feature- check if all relations have a key column value supplied in the post request
//RMF1
//DataTable dtRel = SynapseEntityHelperServices.GetEntityRelations(synapsenamespace, synapseentityname);
string keyAttribute = SynapseEntityHelperServices.GetEntityKeyAttribute(synapsenamespace, synapseentityname);
StringBuilder sb = new StringBuilder();
//dynamic dObj = JObject.Parse(data);
var dataDict = JsonConvert.DeserializeObject <Dictionary <string, object> >(data);
StringBuilder sbCols = new StringBuilder();
StringBuilder sbParams = new StringBuilder();
var paramList = new List <KeyValuePair <string, object> >();
string keyValue = "";
// int iRelationMatches = 0;
int iKeyMatches = 0;
var count = dataDict.Count();
//RK: 08012019 set_createdby : userid from access token
#region set_createdby
var useridClaim = User.FindFirst(_configuration["SynapseCore:Settings:TokenUserIdClaimType"]);
var userid = "unknown";
if (useridClaim != null)
{
userid = useridClaim.Value;
}
else if (dataDict.ContainsKey("_createdby"))
{
userid = Convert.ToString(dataDict["_createdby"]);
}
//check if dataDict has _createdby key
if (dataDict.ContainsKey("_createdby"))
{
//update they key value to userid from toke
dataDict["_createdby"] = userid;
}
else
{
//add _createdby key and set value to userid from token
dataDict.Add("_createdby", userid);
}
#endregion
foreach (KeyValuePair <string, object> item in dataDict)
{
//Count if Key Attribute matches item.Key
var a = item.Key;
var b = a;
if (keyAttribute == item.Key)
{
keyValue = item.Value.ToString();
iKeyMatches++;
}
//Count all Key Columns
//RMF1
/* foreach (DataRow row in dtRel.Rows)
* {
* sb.Append(row[0].ToString() + ",");
* if (item.Key == row[0].ToString())
* {
* iRelationMatches++;
* }
* }*/
if (item.Value != null)
{
sbCols.Append(item.Key + ",");
sbParams.Append("@p_" + item.Key + ",");
paramList.Insert(0, new KeyValuePair <string, object>("p_" + item.Key, item.Value));
}
else //Check it is not a key or relation column that is null
{
if (keyAttribute == item.Key)
{
throw new InterneuronBusinessException(errorCode: 400, errorMessage: "No value supplied for Key Attribute: " + keyAttribute, "Client Error");
}
//Relations
//RMF1
/* foreach (DataRow row in dtRel.Rows)
* {
* if (item.Key == row[0].ToString())
* {
* throw new InterneuronBusinessException(errorCode: 400, errorMessage: "No values supplpied for relation: " + item.Key, "Client Error");
*
* }
* }*/
}
}
//RMF1
/*if (iRelationMatches < dtRel.Rows.Count)
* {
* throw new InterneuronBusinessException(errorCode: 400, errorMessage: "Not all relations have values specified.Please ensure that you have values are specified for all of the following fields: " + StringManipulationServices.TrimEnd(sb.ToString(), ","), "Client Error");
*
* }*/
if (iKeyMatches < 1)
{
throw new InterneuronBusinessException(errorCode: 400, errorMessage: "No value supplied for Key Attribute: " + keyAttribute, "Client Error");
}
string strCols = "INSERT INTO entitystore." + synapsenamespace + "_" + synapseentityname + "(" +
sbCols.ToString().TrimEnd(',') +
") ";
string strParams = " VALUES (" +
sbParams.ToString().TrimEnd(',') +
") RETURNING _sequenceid;";
var sql = strCols + strParams;
DataSet ds = new DataSet();
ds = DataServices.DataSetFromSQL(sql, paramList, existingCon: connectionObj);
DataTable dt = ds.Tables[0];
int id = System.Convert.ToInt32(dt.Rows[0][0].ToString());
//Delete all occurances from entitystorematerialised
string sqlDelete = "DELETE FROM entitystorematerialised." + synapsenamespace + "_" + synapseentityname + " WHERE " + keyAttribute + " = @keyValue;";
var paramListDelete = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("keyValue", keyValue)
};
DataServices.executeSQLStatement(sqlDelete, paramListDelete, existingCon: connectionObj);
//Get all the entity's columns
string entityCols = "";
string sqlEntityCols = "SELECT entitysettings.getentityattributestring(@synapsenamespace, @synapseentityname, 1)";
var paramListEntityCols = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("synapsenamespace", synapsenamespace),
new KeyValuePair <string, object>("synapseentityname", synapseentityname)
};
DataSet dsEntityCols = new DataSet();
dsEntityCols = DataServices.DataSetFromSQL(sqlEntityCols, paramListEntityCols, existingCon: connectionObj);
DataTable dtEntityCols = dsEntityCols.Tables[0];
entityCols = dtEntityCols.Rows[0][0].ToString();
//Insert the newly inserted record into the materialised entity
string sqlMaterialisedInsert = string.Empty;
if (connectionObj == null)
{
sqlMaterialisedInsert = "INSERT INTO entitystorematerialised." + synapsenamespace + "_" + synapseentityname + "(" +
entityCols +
") "
+
" SELECT " +
entityCols +
" FROM entityview." + synapsenamespace + "_" + synapseentityname
+ " WHERE " + keyAttribute + " = @keyValue;";
}
else
{
sqlMaterialisedInsert = "INSERT INTO entitystorematerialised." + synapsenamespace + "_" + synapseentityname + "(" +
entityCols +
") "
+
" SELECT " +
entityCols +
" FROM entityview." + synapsenamespace + "_" + synapseentityname
+ " WHERE " + keyAttribute + " = @keyValue RETURNING *;";
}
var paramListMaterialisedInsert = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("keyValue", keyValue)
};
//DataServices.executeSQLStatement(sqlMaterialisedInsert, paramListMaterialisedInsert, existingCon: connectionObj);
var insertedDataInMaterial = string.Empty;
if (connectionObj == null)
{
DataServices.executeSQLStatement(sqlMaterialisedInsert, paramListMaterialisedInsert);
}
else
{
DataSet dsMaterilaized = DataServices.DataSetFromSQL(sqlMaterialisedInsert, paramListMaterialisedInsert, existingCon: connectionObj);
insertedDataInMaterial = DataServices.ConvertDataTabletoJSONString(dsMaterilaized.Tables[0]);
}
//Get the return object
//return GetReturnObjectByID(synapsenamespace, synapseentityname, id);
string returnedData = string.Empty;
if (connectionObj == null)
{
returnedData = GetReturnObjectByID(synapsenamespace, synapseentityname, id);
}
return(new Tuple <string, string>(returnedData, insertedDataInMaterial));
}
public string GetListByPost(string synapsenamespace, string synapseentityname, string returnsystemattributes, string orderby, string limit, string offset, string filter, [FromBody] string data)
{
dynamic results = JsonConvert.DeserializeObject <dynamic>(data);
string filters = results[0].filters.ToString();
StringBuilder filtersToApplySB = new StringBuilder();
filtersToApplySB.Append(" WHERE 1 = 1 ");
JArray obj = Newtonsoft.Json.JsonConvert.DeserializeObject <JArray>(filters);
foreach (var filterApplied in obj)
{
filtersToApplySB.Append(" AND (" + (string)filterApplied["filterClause"] + ")");
}
string filtersSQL = filtersToApplySB.ToString();
string filterparams = results[1].filterparams.ToString();
var paramListFromPost = new List <KeyValuePair <string, object> >();
JArray objParams = Newtonsoft.Json.JsonConvert.DeserializeObject <JArray>(filterparams);
foreach (var paramApplied in objParams)
{
if (paramApplied["paramValue"].Type == JTokenType.Date)
{
var temp = (DateTime)paramApplied["paramValue"];
var value = temp.ToString("yyyy-MM-ddTHH:mm:ss");
paramListFromPost.Insert(0, new KeyValuePair <string, object>((string)paramApplied["paramName"], value));
}
else
{
paramListFromPost.Insert(0, new KeyValuePair <string, object>((string)paramApplied["paramName"], (string)paramApplied["paramValue"]));
}
}
string limitString = "";
if (!string.IsNullOrEmpty(limit))
{
limitString = " LIMIT " + limit;
}
string orderBySting = "";
if (!string.IsNullOrEmpty(orderby))
{
orderBySting = " ORDER BY " + orderby;
}
string offsetString = "";
if (!string.IsNullOrEmpty(offset))
{
offsetString = " OFFSET " + offset;
}
if (string.IsNullOrWhiteSpace(returnsystemattributes))
{
returnsystemattributes = "0";
}
string fieldList = SynapseEntityHelperServices.GetEntityAttributes(synapsenamespace, synapseentityname, returnsystemattributes);
if (string.IsNullOrEmpty(fieldList))
{
fieldList = " * ";
}
//Stub for later use
string filterString = "";
if (!string.IsNullOrEmpty(filter))
{
filterString = " AND " + filter;
}
string sql = "SELECT * FROM (SELECT " + fieldList + " FROM entitystorematerialised." + synapsenamespace + "_" + synapseentityname + " WHERE 1=1 " + filterString + orderBySting + limitString + offsetString + ") entview " + filtersSQL + ";";
DataSet ds = new DataSet();
ds = DataServices.DataSetFromSQL(sql, paramListFromPost);
DataTable dt = ds.Tables[0];
var json = DataServices.ConvertDataTabletoJSONString(dt);
return(json);
}
public App()
{
DialogService.Init(this);
NavigationService.Init(this);
DataServices.Init(true);
}
// move to the master view model or to a data layer
private async Task AssistQueryRequestHandlerDo(string assistTableName, string assistQuery)
{
IHelperDataServices helperDataServices = DataServices.GetHelperDataServices();
object currentView = null;
IMapper mapper = MapperField.GetMapper();
var assistDataService = DataServices.GetAssistDataServices();
var resultData = await assistDataService.Mapper.ExecuteAssistGeneric(assistTableName.ToUpper(), assistQuery);
switch (assistTableName)
{
case "TIPOCOMI":
{
BrokerTypeDto = (IEnumerable <CommissionTypeViewObject>)(resultData);
break;
}
case "PAIS":
{
IEnumerable <CountryViewObject> countryDtos = (IEnumerable <CountryViewObject>)(resultData);
Country = countryDtos;
currentView = countryDtos;
break;
}
case "PROVINCIA":
{
Province = (IEnumerable <ProvinceViewObject>)resultData;
break;
}
case "PROVINCE_BRANCHES":
{
var provDtos = (IEnumerable <ProvinceViewObject>)resultData;
currentView = provDtos;
break;
}
case "POBLACIONES":
{
var prov = (IEnumerable <CityViewObject>)resultData;
CityDto = prov;
currentView = CityDto;
break;
}
case "PRODUCTS":
{
IEnumerable <ProductsViewObject> productDto = (IEnumerable <ProductsViewObject>)(resultData);
Products = productDto;
currentView = productDto;
break;
}
case "VENDEDOR":
{
IEnumerable <ResellerViewObject> vendedorDto = (IEnumerable <ResellerViewObject>)(resultData);
Vendedor = vendedorDto;
currentView = Vendedor;
break;
}
case "MARKET_ASSIST":
{
IEnumerable <MarketViewObject> mercadoDtos = (IEnumerable <MarketViewObject>)(resultData);
Mercado = mercadoDtos;
currentView = Mercado;
break;
}
case "BUSINESS_ASSIST":
{
IEnumerable <BusinessViewObject> negocios = (IEnumerable <BusinessViewObject>)(resultData);
Negocio = negocios;
currentView = Negocio;
break;
}
case "CLIENT_ASSIST_COMI":
{
ClientOne = (IEnumerable <ClientViewObject>)(resultData);
currentView = ClientOne;
break;
}
case "CHANNEL_TYPE":
{
IEnumerable <ChannelViewObject> cli = (IEnumerable <ChannelViewObject>)(resultData);
Canal = cli;
currentView = Canal;
break;
}
case "TIPOCOMISION":
{
IEnumerable <CommissionTypeViewObject> cli = (IEnumerable <CommissionTypeViewObject>)(resultData);
TipoComission = cli;
currentView = TipoComission;
break;
}
case "OFFICE_ZONE_ASSIST":
{
IEnumerable <ZonaOfiViewObject> cli = (IEnumerable <ZonaOfiViewObject>)(resultData);
Offices = cli;
currentView = Offices;
break;
}
case "CLIENT_BUDGET":
{
IEnumerable <BudgetKeyViewObject> cli = (IEnumerable <BudgetKeyViewObject>)(resultData);
Clavepto = cli;
currentView = Clavepto;
break;
}
case "ORIGIN_ASSIST":
{
IEnumerable <OrigenViewObject> cli = (IEnumerable <OrigenViewObject>)(resultData);
Origen = cli;
currentView = Origen;
break;
}
case "IDIOMAS":
{
IEnumerable <LanguageViewObject> cli = (IEnumerable <LanguageViewObject>)(resultData);
Language = cli;
currentView = Language;
break;
}
}
UpdateCollections(currentView, assistTableName, ref _leftObservableCollection);
LeftValueCollection = _leftObservableCollection;
}
public ActionResult LoadObjectGrid(string objecttypeid, string roleid)
{
string sql = "";
if (objecttypeid == "1")
{
sql = @"SELECT roleprevilage_id as id,applicationname as name,permission_type
FROM rbac.roleprevilages rp join entitystorematerialised.meta_application a on a.application_id = rp.objectid
join rbac.premissions p on p.permission_id=rp.permissionid
inner join rbac.objecttypes ot on ot.objecttypeid=rp.objecttypeid where objecttype='Application'";
}
else if (objecttypeid == "2")
{
sql = @"SELECT roleprevilage_id as id,modulename as name,permission_type
FROM rbac.roleprevilages rp join entitystorematerialised.meta_module a on a.module_id=rp.objectid
join rbac.premissions p on p.permission_id=rp.permissionid
inner join rbac.objecttypes ot on ot.objecttypeid=rp.objecttypeid where objecttype='Module'";
}
else if (objecttypeid == "3")
{
sql = @"SELECT roleprevilage_id as id,actionname as name,permission_type
FROM rbac.roleprevilages rp join rbac.action a on a.action_id=rp.objectid
join rbac.premissions p on p.permission_id=rp.permissionid
inner join rbac.objecttypes ot on ot.objecttypeid=rp.objecttypeid where objecttype='Action'";
}
else if (objecttypeid == "4")
{
sql = @"SELECT roleprevilage_id as id,entityname as name,permission_type
FROM rbac.roleprevilages rp join entitysettings.entitymanager a on a.entityid=rp.objectid
join rbac.premissions p on p.permission_id=rp.permissionid
inner join rbac.objecttypes ot on ot.objecttypeid=rp.objecttypeid where objecttype='Entity'";
}
else if (objecttypeid == "5")
{
sql = @"SELECT roleprevilage_id as id,listname as name ,permission_type
FROM rbac.roleprevilages rp join listsettings.listmanager a on a.list_id=rp.objectid
join rbac.premissions p on p.permission_id=rp.permissionid
inner join rbac.objecttypes ot on ot.objecttypeid=rp.objecttypeid where objecttype='List'";
}
else if (objecttypeid == "6")
{
sql = @"SELECT roleprevilage_id as id,personaname as name,permission_type
FROM rbac.roleprevilages rp join entitystorematerialised.meta_persona a on a.persona_id=rp.objectid
join rbac.premissions p on p.permission_id=rp.permissionid
inner join rbac.objecttypes ot on ot.objecttypeid=rp.objecttypeid where objecttype='Persona'";
}
DataSet ds = DataServices.DataSetFromSQL(sql + " and roleid='" + roleid + "' order by name");
List <RollGridModel> ObjList = new List <RollGridModel>();
foreach (DataRow row in ds.Tables[0].Rows)
{
ObjList.Add(new RollGridModel()
{
objectname = row["name"].ToString(),
permission_type = row["permission_type"].ToString(),
roleprevilage_id = row["id"].ToString()
});
}
return(Json(JsonConvert.SerializeObject(ObjList)));
}
/// <summary>
/// Initializes this <see cref="LocalOutputAdapter"/>.
/// </summary>
/// <exception cref="ArgumentException"><b>InstanceName</b> is missing from the <see cref="AdapterBase.Settings"/>.</exception>
public override void Initialize()
{
base.Initialize();
Dictionary<string, string> settings = Settings;
string setting;
ulong badDataMessageInterval;
// Validate settings.
if (!settings.TryGetValue("instanceName", out m_instanceName) || string.IsNullOrWhiteSpace(m_instanceName))
m_instanceName = Name.ToLower();
// Track instance in static dictionary
Instances[InstanceName] = this;
if (!settings.TryGetValue("archivePath", out m_archivePath))
m_archivePath = FilePath.GetAbsolutePath(FilePath.AddPathSuffix("Archive"));
if (settings.TryGetValue("refreshMetadata", out setting) || settings.TryGetValue("autoRefreshMetadata", out setting))
m_autoRefreshMetadata = setting.ParseBoolean();
if (settings.TryGetValue("badDataMessageInterval", out setting) && ulong.TryParse(setting, out badDataMessageInterval))
m_badDataMessageInterval = badDataMessageInterval;
//if (settings.TryGetValue("useNamespaceReservation", out setting))
// m_useNamespaceReservation = setting.ParseBoolean();
//else
// m_useNamespaceReservation = false;
// Initialize metadata file.
m_instanceName = m_instanceName.ToLower();
m_archive.MetadataFile.FileName = Path.Combine(m_archivePath, m_instanceName + "_dbase.dat");
m_archive.MetadataFile.PersistSettings = true;
m_archive.MetadataFile.SettingsCategory = m_instanceName + m_archive.MetadataFile.SettingsCategory;
m_archive.MetadataFile.FileAccessMode = FileAccess.ReadWrite;
m_archive.MetadataFile.Initialize();
// Initialize state file.
m_archive.StateFile.FileName = Path.Combine(m_archivePath, m_instanceName + "_startup.dat");
m_archive.StateFile.PersistSettings = true;
m_archive.StateFile.SettingsCategory = m_instanceName + m_archive.StateFile.SettingsCategory;
m_archive.StateFile.FileAccessMode = FileAccess.ReadWrite;
m_archive.StateFile.Initialize();
// Initialize intercom file.
m_archive.IntercomFile.FileName = Path.Combine(m_archivePath, "scratch.dat");
m_archive.IntercomFile.PersistSettings = true;
m_archive.IntercomFile.SettingsCategory = m_instanceName + m_archive.IntercomFile.SettingsCategory;
m_archive.IntercomFile.FileAccessMode = FileAccess.ReadWrite;
m_archive.IntercomFile.Initialize();
// Initialize data archive file.
m_archive.FileName = Path.Combine(m_archivePath, m_instanceName + "_archive.d");
m_archive.FileSize = 100;
m_archive.CompressData = false;
m_archive.PersistSettings = true;
m_archive.SettingsCategory = m_instanceName + m_archive.SettingsCategory;
m_archive.RolloverStart += m_archive_RolloverStart;
m_archive.RolloverComplete += m_archive_RolloverComplete;
m_archive.RolloverException += m_archive_RolloverException;
m_archive.DataReadException += m_archive_DataReadException;
m_archive.DataWriteException += m_archive_DataWriteException;
m_archive.OffloadStart += m_archive_OffloadStart;
m_archive.OffloadComplete += m_archive_OffloadComplete;
m_archive.OffloadException += m_archive_OffloadException;
m_archive.OrphanDataReceived += m_archive_OrphanDataReceived;
m_archive.FutureDataReceived += m_archive_FutureDataReceived;
m_archive.OutOfSequenceDataReceived += m_archive_OutOfSequenceDataReceived;
m_archive.Initialize();
// Provide web service support.
m_dataServices = new DataServices();
m_dataServices.AdapterCreated += DataServices_AdapterCreated;
m_dataServices.AdapterLoaded += DataServices_AdapterLoaded;
m_dataServices.AdapterUnloaded += DataServices_AdapterUnloaded;
m_dataServices.AdapterLoadException += AdapterLoader_AdapterLoadException;
// Provide metadata sync support.
m_metadataProviders = new MetadataProviders();
m_metadataProviders.AdapterCreated += MetadataProviders_AdapterCreated;
m_metadataProviders.AdapterLoaded += MetadataProviders_AdapterLoaded;
m_metadataProviders.AdapterUnloaded += MetadataProviders_AdapterUnloaded;
m_metadataProviders.AdapterLoadException += AdapterLoader_AdapterLoadException;
// Provide archive replication support.
m_replicationProviders = new ReplicationProviders();
m_replicationProviders.AdapterCreated += ReplicationProviders_AdapterCreated;
m_replicationProviders.AdapterLoaded += ReplicationProviders_AdapterLoaded;
m_replicationProviders.AdapterUnloaded += ReplicationProviders_AdapterUnloaded;
m_replicationProviders.AdapterLoadException += AdapterLoader_AdapterLoadException;
}
public StoreController()
{
ds = DataServices.Instance;
}
protected Downloader(IReadOnlyList <string> testInfo, LevelTestingServer server, DataServices dataSvc)
{
DataSvc = dataSvc;
DateTime time = Convert.ToDateTime(testInfo[1]);
string title = testInfo[2].Substring(0, testInfo[2].IndexOf(" "));
DemoName = $"{time:MM_dd_yyyy}_{title}";
FtpPath = server.FtpPath;
LocalPath = $"{DataSvc.DemoPath}\\{time:yyyy}\\{time:MM} - " + $"{time:MMMM}\\{DemoName}";
WorkshopId = Regex.Match(testInfo[6], @"\d+$").Value;
}
public string GetObjectWithInsert(string synapsenamespace, string synapseentityname, string synapseattributename, string attributevalue, string keyvalue, string returnsystemattributes)
{
if (string.IsNullOrWhiteSpace(returnsystemattributes))
{
returnsystemattributes = "0";
}
if (string.IsNullOrWhiteSpace(keyvalue))
{
keyvalue = System.Guid.NewGuid().ToString();
}
string sqlCount = "SELECT COUNT(*) AS entityRecords FROM entitystorematerialised." + synapsenamespace + "_" + synapseentityname + " WHERE " + synapseattributename + " = @p_keyAttributeValue;";
var paramListCount = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("p_keyAttributeValue", attributevalue)
};
int iCount = 0;
DataSet dsCount = new DataSet();
try
{
dsCount = DataServices.DataSetFromSQL(sqlCount, paramListCount);
DataTable dt1 = dsCount.Tables[0];
iCount = System.Convert.ToInt32(dt1.Rows[0]["entityRecords"].ToString());
}
catch (Exception ex)
{
iCount = 0;
}
if (iCount == 0)
{
//insert to return row
string keyAttribute = SynapseEntityHelperServices.GetEntityKeyAttribute(synapsenamespace, synapseentityname);
StringBuilder sb = new StringBuilder();
StringBuilder sb_materialised = new StringBuilder();
var paramListInsert = new List <KeyValuePair <string, object> >();
var paramListInsert_materialised = new List <KeyValuePair <string, object> >();
if (keyAttribute == synapseattributename) //Only insert attributevalue
{
sb.Append("INSERT INTO entitystore." + synapsenamespace + "_" + synapseentityname);
sb.Append(" (" + keyAttribute + ")");
sb.Append(" VALUES (@keyvalue)");
paramListInsert = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("keyvalue", attributevalue)
};
sb_materialised.Append("INSERT INTO entitystorematerialised." + synapsenamespace + "_" + synapseentityname);
sb_materialised.Append(" (" + keyAttribute + ")");
sb_materialised.Append(" VALUES (@keyvalue)");
paramListInsert_materialised = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("keyvalue", attributevalue)
};
}
else
{
sb.Append("INSERT INTO entitystore." + synapsenamespace + "_" + synapseentityname);
sb.Append(" (" + keyAttribute + "," + synapseattributename + ")");
sb.Append(" VALUES (@keyvalue, @synapseattributevalue)");
paramListInsert = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("keyvalue", keyvalue),
new KeyValuePair <string, object>("synapseattributevalue", attributevalue)
};
sb_materialised.Append("INSERT INTO entitystorematerialised." + synapsenamespace + "_" + synapseentityname);
sb_materialised.Append(" (" + keyAttribute + "," + synapseattributename + ")");
sb_materialised.Append(" VALUES (@keyvalue, @synapseattributevalue)");
paramListInsert_materialised = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("keyvalue", keyvalue),
new KeyValuePair <string, object>("synapseattributevalue", attributevalue)
};
}
DataServices.executeSQLStatement(sb.ToString(), paramListInsert);
DataServices.executeSQLStatement(sb_materialised.ToString(), paramListInsert_materialised);
}
string fieldList = SynapseEntityHelperServices.GetEntityAttributes(synapsenamespace, synapseentityname, returnsystemattributes);
if (string.IsNullOrEmpty(fieldList))
{
fieldList = " * ";
}
string sql = "SELECT " + fieldList + " FROM entitystorematerialised." + synapsenamespace + "_" + synapseentityname + " WHERE " + synapseattributename + " = @p_keyAttributeValue LIMIT 1;";
var paramList = new List <KeyValuePair <string, object> >()
{
new KeyValuePair <string, object>("p_keyAttributeValue", attributevalue)
};
DataSet ds = new DataSet();
ds = DataServices.DataSetFromSQL(sql, paramList);
DataTable dt = ds.Tables[0];
var json = DataServices.ConvertDataTabletoJSONObject(dt);
return(json);
}
public void CreateAssessment()
{
var services = new DataServices();
services.CreateAssessment("testAssessment");
}
/// <summary>
/// Cập nhật những thay đổi
/// </summary>
/// <returns>Kết quả cập nhật có bao nhiêu dòng bị tác động</returns>
public int CapNhat()
{
DataServices.OpenConnection(true);
return(dataServices.ExecuteUpdate());
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public DataTable GetSchemaGENERAL_CALENDAR_MASTER()
{
return(DataServices.ExecuteDataTable(CommandType.Text, "SELECT * FROM GENERAL_CALENDAR_MASTER WHERE 1=0", null));
}
public static void Main()
{
string sel = "SELECT * FROM ROCKET";
DataServices.LendReader(sel, new BorrowReader(GetNames));
}
public void Setup()
{
_executor = SetupSqlQueryExecutor();
_budgetServices = DataServices.GetBudgetDataServices();
}
public TestCrudBookingService() : base()
{
_bookingDataService = DataServices.GetBookingDataService();
_mapper = MapperField.GetMapper();
}
public IActionResult SchemaExport()
{
string sql = @"SELECT entityid as id,entityname as name, synapsenamespacename as synamespace from entitysettings.entitymanager order by synamespace, name";
DataTable dt = new DataTable();
List <TreeViewNode> nodes = new List <TreeViewNode>();
dt = DataServices.DataSetFromSQL(sql).Tables[0];
try
{
dt = DataServices.DataSetFromSQL(sql).Tables[0];
nodes.Add(new TreeViewNode {
id = "1", parent = "#", text = "Entities"
});
nodes.Add(new TreeViewNode {
id = "2", parent = "#", text = "Baseview"
});
nodes.Add(new TreeViewNode {
id = "3", parent = "#", text = "Lists"
});
//Loop and add the Child Nodes.
foreach (DataRow item in dt.Rows)
{
TreeViewNode node = new TreeViewNode();
//node.text = item["name"].ToString();
node.text = item["synamespace"].ToString() + "_" + item["name"].ToString();
node.id = item["id"].ToString();
node.parent = "1";
nodes.Add(node);
}
}
catch (Exception ex)
{
}
sql = @"SELECT baseview_id as id,baseviewname as name, baseviewnamespace as nspace from listsettings.baseviewmanager order by nspace, baseviewname";
dt = new DataTable();
try
{
dt = DataServices.DataSetFromSQL(sql).Tables[0];
}
catch (Exception ex)
{
}
foreach (DataRow item in dt.Rows)
{
TreeViewNode node = new TreeViewNode();
//node.text = item["name"].ToString();
node.text = item["nspace"].ToString() + "_" + item["name"].ToString();
node.id = item["id"].ToString();
node.parent = "2";
nodes.Add(node);
}
sql = @"SELECT list_id as id,listname as name, listnamespace as lspace from listsettings.listmanager order by lspace, listname";
dt = new DataTable();
try
{
dt = DataServices.DataSetFromSQL(sql).Tables[0];
}
catch (Exception ex)
{
}
foreach (DataRow item in dt.Rows)
{
TreeViewNode node = new TreeViewNode();
//node.text = item["name"].ToString();
node.text = item["lspace"].ToString() + "_" + item["name"].ToString();
node.id = item["id"].ToString();
node.parent = "3";
nodes.Add(node);
}
ViewBag.Json = JsonConvert.SerializeObject(nodes);
return(View());
}
// TODO: using the configure
private async void AssistCommandHelper(object param)
{
IDictionary <string, string> values = param as Dictionary <string, string>;
string assistTableName = values != null && values.ContainsKey("AssistTable") ? values["AssistTable"] : null;
string assistQuery = values.ContainsKey("AssistQuery") ? values["AssistQuery"] : null;
/* ok now i have to handle the assist helper.
* The smartest thing is to detect the table from the query.
*/
var resultMap = await _assistDataService.Mapper.ExecuteAssistGeneric(assistTableName.ToUpper(), assistQuery);
IMapper mapper = MapperField.GetMapper();
IHelperDataServices helperDataServices = DataServices.GetHelperDataServices();
if (assistTableName != null)
{
assistTableName = assistTableName.ToUpper();
switch (assistTableName)
{
case "ACTIVEHI":
{
ActivityDtos = resultMap as IEnumerable <VehicleActivitiesDto>;
break;
}
case "PROPIE":
{
OwnerDtos = resultMap as IEnumerable <OwnerDto>;
break;
}
case "AGENTES":
{
AgentDtos = resultMap as IEnumerable <AgentDto>;
break;
}
case "ASSURANCE":
{
AssuranceDtos = resultMap as IEnumerable <SupplierSummaryDto>;
break;
}
case "ASSURANCE_1":
{
AssistancePolicyAssuranceDtos = resultMap as IEnumerable <SupplierSummaryDto>;
break;
}
case "ASSURANCE_2":
{
AdditionalAssuranceDtos = resultMap as IEnumerable <SupplierSummaryDto>;
break;
}
case "ASSURANCE_3":
{
AssistanceAssuranceDtos = resultMap as IEnumerable <SupplierSummaryDto>;
break;
}
case "ASSURANCE_AGENT":
{
AssuranceAgentDtos = resultMap as IEnumerable <SupplierSummaryDto>;
break;
}
case "PROVEE1":
{
BuyerSupplierDto = resultMap as IEnumerable <SupplierSummaryDto>;
break;
}
case "PROVEE2":
{
ProveeDto2 = resultMap as IEnumerable <SupplierSummaryDto>;
break;
}
case "CU1":
{
AccountDtos = resultMap as IEnumerable <AccountDto>;
break;
}
case "FORMAS":
{
PaymentFormDto = resultMap as IEnumerable <PaymentFormDto>;
break;
}
case "CLIENTES1":
{
ClientsDto = resultMap as IEnumerable <ClientSummaryExtended>;
break;
}
case "CLIENT_ASSIST":
{
ClientsDto = resultMap as IEnumerable <ClientSummaryExtended>;
break;
}
case "ACCOUNT_INMOVILIZADO":
{
AccountDtosImmobilized = resultMap as IEnumerable <AccountDto>;
break;
}
case "ACCOUNT_PAYMENT_ACCOUNT":
{
AccountDtoPaymentAccount = resultMap as IEnumerable <AccountDto>;
break;
}
case "ACCOUNT_PREVIUOS_PAYMENT":
{
AccountDtoPreviousRepayment = resultMap as IEnumerable <AccountDto>;
break;
}
case "ACCOUNT_ACCUMULATED_REPAYMENT":
{
AccountDtoAccmulatedRepayment = resultMap as IEnumerable <AccountDto>;
break;
}
case "POBLACIONES":
{
CityDto = resultMap as IEnumerable <CityDto>;
break;
}
case "OFICINA1":
{
OtherOffice1Dto = resultMap as IEnumerable <OfficeDtos>;
break;
}
case "OFICINA2":
{
OtherOffice2Dto = resultMap as IEnumerable <OfficeDtos>;
break;
}
case "OFICINA3":
{
OtherOffice3Dto = resultMap as IEnumerable <OfficeDtos>;
break;
}
case "COLORFL":
{
ColorDtos = resultMap as IEnumerable <ColorDto>;
break;
}
case "MARCAS":
{
BrandDtos = (IEnumerable <BrandVehicleDto>)resultMap;
break;
}
case "MODELO":
{
ModelDtos = resultMap as IEnumerable <ModelVehicleDto>;
break;
}
case "GRUPOS":
{
VehicleGroupDtos = resultMap as IEnumerable <VehicleGroupDto>;
break;
}
case "SITUATION":
{
CurrentSituationDto = resultMap as IEnumerable <CurrentSituationDto>;
break;
}
case "ROAD_TAXES_CITY":
{
RoadTaxesCityDto = resultMap as IEnumerable <CityDto>;
break;
}
case "ROAD_TAXES_ZONAOFI":
{
RoadTaxesOfficeZoneDto = resultMap as IEnumerable <ZonaOfiDto>;
break;
}
case "RESELLER_ASSIST":
{
ResellerDto = resultMap as IEnumerable <ResellerDto>;
break;
}
}
}
}
/// <summary>
/// Test wykonywany przy wywo³aniach metod Find.
/// </summary>
public void TestFinding()
{
DataServices.FindAll(typeof(Rocket));
DataServices.Find(typeof(Rocket), "Orbit");
}
public string postJe()
{
long jdtNum = 0;
int errnum = 0;
string errDesc = "";
string outStr = "";
string jeType = "PP";
if (optPP.Selected)
{
jeType = "PP";
}
if (optPC.Selected)
{
jeType = "PC";
}
if (optC.Selected)
{
jeType = "C";
}
if (!chkPost.Checked)
{
Program.objHrmsUI.oApplication.SetStatusBarMessage("You need to check the approved box before posting");
return("Error");
}
if (txRef1.Value == "")
{
Program.objHrmsUI.oApplication.SetStatusBarMessage("Select a transaction to post!");
return("Error");
}
SAPbobsCOM.JournalEntries vJE = (SAPbobsCOM.JournalEntries)Program.objHrmsUI.oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oJournalEntries);
string Remarks = txRem.Value.ToString();
DateTime postingDate = DateTime.ParseExact(txDD.Value, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None);
try
{
vJE.ReferenceDate = postingDate;
vJE.TaxDate = postingDate;
vJE.DueDate = postingDate;
if (Remarks.Length > 20)
{
vJE.Memo = Remarks.Substring(0, 20); // dgSales[3, i].Value.ToString().Substring(0, 20);
}
else
{
vJE.Memo = Remarks;
}
vJE.Reference = txRef1.Value;
vJE.Reference2 = txRef2.Value;
vJE.Reference3 = "PRL";
for (int i = 0; i < mtDet.RowCount; i++)
{
string codetype = dtDet.GetValue("cType", i);
string acctcode = dtDet.GetValue("cCode", i);
string acctname = dtDet.GetValue("cName", i);
string debit = Convert.ToString(dtDet.GetValue("cDebit", i));
string credit = Convert.ToString(dtDet.GetValue("cCredit", i));
string project = dtDet.GetValue("cProject", i);
string ocr1 = dtDet.GetValue("cOcr1", i);
string ocr2 = dtDet.GetValue("cOcr2", i);
string ocr3 = dtDet.GetValue("cOcr3", i);
string ocr4 = dtDet.GetValue("cOcr4", i);
string ocr5 = dtDet.GetValue("cOcr5", i);
if (codetype == "GL")
{
vJE.Lines.AccountCode = acctcode;
}
else
{
vJE.Lines.ShortName = acctcode;
}
if (jeType == "PP")
{
vJE.Lines.Credit = Convert.ToDouble(credit);
vJE.Lines.Debit = Convert.ToDouble(debit);
}
else
{
vJE.Lines.Credit = Convert.ToDouble(debit);
vJE.Lines.Debit = Convert.ToDouble(credit);
}
vJE.Lines.DueDate = postingDate;
vJE.Lines.ReferenceDate1 = postingDate;
vJE.Lines.TaxDate = postingDate;
vJE.Lines.Reference1 = vJE.Reference;
vJE.Lines.Reference2 = vJE.Reference2;
vJE.Lines.ProjectCode = project;
vJE.Lines.CostingCode = ocr1;
vJE.Lines.CostingCode2 = ocr2;
vJE.Lines.CostingCode3 = ocr3;
vJE.Lines.CostingCode4 = ocr4;
vJE.Lines.CostingCode5 = ocr5;
vJE.Lines.Add();
}
}
catch (Exception ex)
{
outStr = ex.Message;
}
if (vJE.Add() != 0)
{
int erroCode = 0;
string errDescr = "";
Program.objHrmsUI.oCompany.GetLastError(out erroCode, out errDescr);
outStr = "Error:" + errDescr + outStr;
Program.objHrmsUI.oApplication.SetStatusBarMessage(outStr);
}
else
{
outStr = Convert.ToString(Program.objHrmsUI.oCompany.GetNewObjectKey());
DataServices ds = new DataServices(Program.strConMena);
ds.ExecuteNonQuery("Exec [dbo].[JE_PRL_UpdatedPostedJE] '" + txRef1.Value + "','" + outStr + "','" + jeType + "' ");
Program.objHrmsUI.oApplication.SetStatusBarMessage("Journal Entry Created. JE # " + outStr, BoMessageTime.bmt_Medium, false);
iniUI();
}
return(outStr);
}
public Policy Mine(SessionActivity sessionActivity)
{
var dataService = new DataServices();
return(dataService.GetPolicy(sessionActivity));
}
public async void RetrieveDataAsync()
{
UserInfo = await DataServices.GetDataAsync();
}
private void exportBgWorker_DoWork(object sender, DoWorkEventArgs e)
{
MySqlConnection serverCon = null;
int affectedRows = 0;
log.AppendLine("Checking Server Connection...");
try
{
serverCon = new ConnectionManager(
Settings.Default.PushServer,
Settings.Default.PushServerDB,
Settings.Default.PushServerDBPort,
Settings.Default.PushServerDBUser,
Settings.Default.PushServerDBPassword).
getDBConnection();
log.AppendLine("Server Connection Confirmed...");
}
catch (Exception exp)
{
log.AppendLine("Unable to continue sync..." + exp.Message);
}
if (serverCon.State == ConnectionState.Open)
{
int batchSize = 1000;
try
{
//Determine total number of records pending..
log.AppendLine("Checking size of pending data for sync...");
int pendingDataSize = DataServices.GetAttendanceClockPendingSyncSize();
log.AppendLine("Total logs pending to by synchronised is:" + pendingDataSize);
if (pendingDataSize > 0)
{
//Continue to Process the Sync in Batch until the pending records are all sent to the server..
while (affectedRows < pendingDataSize)
{
attentanceLogs = DataServices.GetAttendanceClockPendingSync(batchSize, 0);
log.AppendLine("Loaded " + attentanceLogs.Count() + " Record... Synching.. ");
//Create an exit plan for this while loop...
if (attentanceLogs.Count < 1)
{
break;
}
List <string> processedIds = new List <string>();
foreach (AttendanceLog aLog in attentanceLogs)
{
if (BgWorker.CancellationPending)
{
e.Cancel = true;
}
int result = 0;
try
{
result = DataServices.LogAttendanceClock(aLog, serverCon);
}
catch (Exception exp)
{
log.AppendLine(exp.Message);
}
if (result > 0)
{
affectedRows += 1;
processedIds.Add(aLog.Id.ToString());
}
else
{
//For every record that is not added to the SErver,
//we need to reduce the size PendingDataSize to revent our loop from going infinite..
pendingDataSize -= 1;
}
}
//Update SyncStatus of Batch records for succesfully processed Ids on local DB
DataServices.UpdateAttendanceClockSyncStatus(processedIds.ToArray(), "1");
}
}
log.AppendLine("Completed. " + affectedRows + " Records was Synchronised to the server");
}
catch (Exception exp)
{
log.AppendLine(exp.Message);
}
}
}
public async void OnAssistCommand(object command)
{
var value = await DataServices.GetHelperDataServices().GetMappedAllAsyncHelper <LanguageViewObject, IDIOMAS>();
LanguageDto = value;
}
public TimerService(DiscordSocketClient client, ModerationServices mod, LevelTesting levelTesting, Random rand, DataServices dataServices)
{
_dataServices = dataServices;
_client = client;
_mod = mod;
_levelTesting = levelTesting;
_random = rand;
//Code inside this will fire ever {updateInterval} seconds
Timer = new Timer(_ =>
{
_levelTesting.Announce();
_levelTesting.CheckServerReservations();
_mod.Cycle();
ChangePlaying();
},
null,
TimeSpan.FromSeconds(_dataServices.StartDelay), // Time that message should fire after bot has started
TimeSpan.FromSeconds(_dataServices.UpdateInterval)); // Time after which message should repeat (`Timeout.Infinite` for no repeat)
}
/// <summary>
/// This method runs after inserting a setup before this block to declare the errors
/// </summary>
/// <param name="result">result of BlockDataService's special operation, containing error messages</param>
internal void InsertSetupBeforeCallback(DataServices.BlockDataService.InsertSetupBeforeBlockErrors result)
{
//exit if saved successfully
if (result.IsSaved) return;
//add the basic error message
Message.AddEmbeddedException("قادر به افزودن آماده سازی نمی باشد.\nبرخی از Taskهای بعدی در این ایستگاه قابل تغییر نیستند.");
foreach (var error in result.Errors)
{
switch (error.Item1)
{
case Soheil.Core.DataServices.BlockDataService.InsertSetupBeforeBlockErrors.ErrorSource.Task:
var task = TaskList.FirstOrDefault(x => x.Id == error.Item3);
if (task != null) task.Message.AddEmbeddedException(error.Item2);
else Message.AddEmbeddedException(error.Item2);
break;
case Soheil.Core.DataServices.BlockDataService.InsertSetupBeforeBlockErrors.ErrorSource.NPT:
var npt = Parent[this.RowIndex].NPTs.FirstOrDefault(x => x.Id == error.Item3);
if (npt != null) npt.Message.AddEmbeddedException(error.Item2);
else Message.AddEmbeddedException(error.Item2);
break;
case Soheil.Core.DataServices.BlockDataService.InsertSetupBeforeBlockErrors.ErrorSource.This:
Message.AddEmbeddedException(error.Item2);
break;
default:
break;
}
}
}
/// <summary>
/// Initializes this <see cref="LocalOutputAdapter"/>.
/// </summary>
public override void Initialize()
{
base.Initialize();
//const string errorMessage = "{0} is missing from Settings - Example: instanceName=default; ArchiveDirectories={{c:\\Archive1\\;d:\\Backups2\\}}; dataChannel={{port=9591; interface=0.0.0.0}}";
Dictionary<string, string> settings = Settings;
string setting;
// Validate settings.
if (!settings.TryGetValue("instanceName", out m_instanceName) || string.IsNullOrWhiteSpace(m_instanceName))
m_instanceName = Name;
// Track instance in static dictionary
Instances[InstanceName] = this;
if (!settings.TryGetValue("WorkingDirectory", out setting) || string.IsNullOrEmpty(setting))
setting = "Archive";
WorkingDirectory = setting;
if (settings.TryGetValue("ArchiveDirectories", out setting))
ArchiveDirectories = setting;
if (settings.TryGetValue("AttachedPaths", out setting))
AttachedPaths = setting;
if (!settings.TryGetValue("DataChannel", out m_dataChannel))
m_dataChannel = DefaultDataChannel;
double targetFileSize;
if (!settings.TryGetValue("TargetFileSize", out setting) || !double.TryParse(setting, out targetFileSize))
targetFileSize = DefaultTargetFileSize;
if (targetFileSize < 0.1D || targetFileSize > SI2.Tera)
targetFileSize = DefaultTargetFileSize;
if (!settings.TryGetValue("MaximumArchiveDays", out setting) || !int.TryParse(setting, out m_maximumArchiveDays))
m_maximumArchiveDays = DefaultMaximumArchiveDays;
if (!settings.TryGetValue("DirectoryNamingMode", out setting) || !Enum.TryParse(setting, true, out m_directoryNamingMode))
DirectoryNamingMode = DefaultDirectoryNamingMode;
// Handle advanced settings - there are hidden but available from manual entry into connection string
int stagingCount, diskFlushInterval, cacheFlushInterval;
if (!settings.TryGetValue("StagingCount", out setting) || !int.TryParse(setting, out stagingCount))
stagingCount = 3;
if (!settings.TryGetValue("DiskFlushInterval", out setting) || !int.TryParse(setting, out diskFlushInterval))
diskFlushInterval = 10000;
if (!settings.TryGetValue("CacheFlushInterval", out setting) || !int.TryParse(setting, out cacheFlushInterval))
cacheFlushInterval = 100;
// Establish archive information for this historian instance
m_archiveInfo = new HistorianServerDatabaseConfig(InstanceName, WorkingDirectory, true);
if ((object)m_archiveDirectories != null)
m_archiveInfo.FinalWritePaths.AddRange(m_archiveDirectories);
if ((object)m_attachedPaths != null)
m_archiveInfo.ImportPaths.AddRange(m_attachedPaths);
m_archiveInfo.TargetFileSize = (long)(targetFileSize * SI.Giga);
m_archiveInfo.DirectoryMethod = DirectoryNamingMode;
m_archiveInfo.StagingCount = stagingCount;
m_archiveInfo.DiskFlushInterval = diskFlushInterval;
m_archiveInfo.CacheFlushInterval = cacheFlushInterval;
// Provide web service support
m_dataServices = new DataServices();
m_dataServices.AdapterCreated += DataServices_AdapterCreated;
m_dataServices.AdapterLoaded += DataServices_AdapterLoaded;
m_dataServices.AdapterUnloaded += DataServices_AdapterUnloaded;
m_dataServices.AdapterLoadException += AdapterLoader_AdapterLoadException;
// Provide archive replication support
m_replicationProviders = new ReplicationProviders();
m_replicationProviders.AdapterCreated += ReplicationProviders_AdapterCreated;
m_replicationProviders.AdapterLoaded += ReplicationProviders_AdapterLoaded;
m_replicationProviders.AdapterUnloaded += ReplicationProviders_AdapterUnloaded;
m_replicationProviders.AdapterLoadException += AdapterLoader_AdapterLoadException;
if (MaximumArchiveDays > 0)
{
m_dailyTimer = new Timer(Time.SecondsPerDay * 1000.0D);
m_dailyTimer.AutoReset = true;
m_dailyTimer.Elapsed += m_dailyTimer_Elapsed;
m_dailyTimer.Enabled = true;
}
}
