public Customer Parse(CustomerCommand command) { return(new Customer() { TradingName = command.TradingName }); }
protected override CustomerCommand CreateCommand(DataCommandConfig commandConfig) { //1.创建 Connection 对象【需要从连接池中获取连接对象,此处后续优化】 //string strConn = ConfigurationManager.AppSettings["ConnectionString"]; var dbConfig = DataManager.DatabaseDictionary[commandConfig.DataSourceID]; string strConn = dbConfig.ConnectionString; MySqlConnection dbConnection = new MySqlConnection(strConn); //2.创建 Command 对象 MySqlCommand command = new MySqlCommand(commandConfig.CommandText, dbConnection); command.CommandType = CommandType.Text; //3.填充参数列表 foreach (ParameterConfig param in commandConfig.Parameters) { MySqlParameter parameter = command.CreateParameter(); parameter.ParameterName = param.Name; parameter.DbType = param.DBType; parameter.Size = param.Size == 0 ? 4 : param.Size; parameter.Direction = ParameterDirection.Input; //默认是输入参数 command.Parameters.Add(parameter); } CustomerCommand customerCmd = new CustomerCommand(command, DataBaseType.MySQL); return customerCmd; }
protected static CustomerDocument GetCustomerFromErpNext(string name) { var receiver = new CustomerCommand(name, $"{GetCustomerResourceServerAddress()}"); var customerDocument = receiver.Execute(); return(customerDocument.Data.Message); }
private CustomerDocument GetCustomerDetails(string customerName) { var receiver = new CustomerCommand(customerName, $"{GetResourceServerAddress()}"); var document = receiver.Execute(); return(document.Data.Message); }
public List <ReportDataModel> FetchAttendanceData(int churchId, DateTime startDate, DateTime endDate, List <int> mnList, List <int> gtList) { CustomerCommand command = _dataManager.CreateCustomerCommand("Dashboard.FetchAttendanceData"); command.SetParameterValue("@ChurchId", churchId); command.SetParameterValue("@StartDate", startDate); command.SetParameterValue("@EndDate", endDate); string whereStr_mn = "AND widgetItem.[UserWidgetItemID] IN (-999)"; string whereStr_gt = "AND widgetItem.[UserWidgetItemID] IN (-999)"; if (mnList != null && mnList.Count > 0) { whereStr_mn = string.Format("AND widgetItem.[UserWidgetItemID] IN ({0})", string.Join <int>(",", mnList)); } if (mnList != null && mnList.Count > 0) { whereStr_gt = string.Format("AND widgetItem.[UserWidgetItemID] IN ({0})", string.Join <int>(",", gtList)); } command.CommandText = command.CommandText.Replace("#WhereStr_mn#", whereStr_mn); command.CommandText = command.CommandText.Replace("#WhereStr_gt#", whereStr_gt); return(command.ExecuteCommandToEntitys <ReportDataModel>()); }
public ChurchModel FetchChurchInfomation(int churchId) { CustomerCommand command = _dataManager.CreateCustomerCommand("Church.FetchChurchInfomation"); command.SetParameterValue("@ChurchId", churchId); ChurchModel church = command.ExecuteCommandToEntity <ChurchModel>(); return(church); }
public static void Send(CustomerCommand CustomerCommand) { CloudStorageAccount storageAccount = CloudStorageAccount.Parse(_ConnectionString); CloudQueueClient queueClient = storageAccount.CreateCloudQueueClient(); CloudQueue queue = queueClient.GetQueueReference(CustomerCommand.QueueName); queue.CreateIfNotExistsAsync().Wait(); CloudQueueMessage message = new CloudQueueMessage(Newtonsoft.Json.JsonConvert.SerializeObject(CustomerCommand)); queue.AddMessageAsync(message); }
public IActionResult Post([FromBody] CustomerCommand command) { try { _customerAppService.Add_a_new_Customer(command); return(Ok("Customer added with success.")); } catch (System.Exception ex) { return(Problem(ex.Message)); } }
private void OnCmdConnect() { try { LogEntryView.ConnectionTest(); IsDbConnect = true; AddCommand.RaiseCanExecuteChanged(); LoadCommand.RaiseCanExecuteChanged(); ConnectCommand.RaiseCanExecuteChanged(); CustomerCommand.RaiseCanExecuteChanged(); LocationTreeCommand.RaiseCanExecuteChanged(); } catch (Exception ex) { MessageBox.Show( ex.Message); } }
public List <ReportDataModel> FetchAttributeData(int churchId, DateTime startDate, DateTime endDate, List <int> widgetItemIds) { CustomerCommand command = _dataManager.CreateCustomerCommand("Dashboard.FetchAttributeData"); command.SetParameterValue("@ChurchId", churchId); command.SetParameterValue("@StartDate", startDate); command.SetParameterValue("@EndDate", endDate); string whereStr = "AND widgetItem.[UserWidgetItemID] IN (-999)"; if (widgetItemIds != null && widgetItemIds.Count > 0) { whereStr = string.Format("AND widgetItem.[UserWidgetItemID] IN ({0})", string.Join <int>(",", widgetItemIds)); } command.CommandText = command.CommandText.Replace("#WhereStr#", whereStr); return(command.ExecuteCommandToEntitys <ReportDataModel>()); }
public List <string> SendContentMethod(List <string> strList, string targetId, CustomerCommand command, string message = null, string fromId = null) { SendContent CtoC = new SendContent() { Target = targetId, Message = PublicMethod.JsonSerialize <ReceiveModel>(new ReceiveModel() { Command = command, Message = message, FromId = fromId }), From = Connector.HubToken }; strList.Add(PublicMethod.JsonSerialize <SendContent>(CtoC)); return(strList); }
private void MainForm_Load(object sender, EventArgs e) { NetworkCredentials.Instance().NetworkDomain = Properties.Settings.Default.networkdomain; NetworkCredentials.Instance().NetworkUsername = Properties.Settings.Default.networkusername; NetworkCredentials.Instance().NetworkPassord = Properties.Settings.Default.networkpassword; //NetworkFileSystemUtilsProxy p = new NetworkFileSystemUtilsProxy(); //p.UncFileExist(@"\\DESKTOP-E9KNOCC\ciccio\ciccio.txt"); //initialize skinning properties barManager.ForceInitialize(); MyBarLocalizer.Active = new MyBarLocalizer(); SkinHelper.InitSkinPopupMenu(mPaintStyle); //initialize navigator _navUtil = new NavigationUtils(splitContainerControl.Panel2, this); //renders startup controls if (_customerId == "") { _navUtil.NavigateToStartupControl(Properties.Settings.Default.Main_StartCommand); } else { try { IOpenCommand cmd = new CustomerCommand(this); Hashtable h = new Hashtable(); h.Add("Id", _customerId); cmd.Execute(h); HistoryOfCommands.Instance().AddCommandToHistory(cmd); MemoryHelper.ReduceMemory(); } catch (Exception ex) { ErrorHandler.Show(ex); _navUtil.NavigateToStartupControl(Properties.Settings.Default.Main_StartCommand); } } //sets the caption text this.Text = "Gestionale appuntamenti - " + Properties.Settings.Default.Main_AppName; //sets the name of the current logged user string nome = ((User)(SecurityManager.Instance.CurrentUser)).Username; sItem.Caption = string.Format("Benvenuto: {0}!", nome); if (DataAccessServices.Instance().PersistenceFacade.DBType == DB.DBType.Access) { // barRipristina.Visibility = BarItemVisibility.Always;ù barButtonbackup.Visibility = BarItemVisibility.Always; UpdateLastBackInfo(); barBack.Visibility = BarItemVisibility.Always; } else { //barRipristina.Visibility = BarItemVisibility.Never; barButtonbackup.Visibility = BarItemVisibility.Never; barBack.Visibility = BarItemVisibility.Never; } //sets initial view splitContainerControl.Collapsed = Properties.Settings.Default.Main_PanelCollapsed; administration.Visible = !Properties.Settings.Default.Main_ShowOnlyAgendaFunctions; }
public async Task <IActionResult> InsertCustomerAsync([FromBody] CustomerCommand customerCommand) { await mediator.Send(customerCommand); return(NoContent()); }
public async Task <IActionResult> PostAsync(CustomerCommand data) { var result = await _mediatr.Send(data); return(Ok(result)); }