// accepts new customer object public void AddCustomer(CustomerEntity customer) { customer.CustomerId = (int)(from b in customerData.Descendants("customer") orderby (int)b.Element("id") descending select (int)b.Element("id")).FirstOrDefault() + 1; customerData.Root.Add(new XElement("customer", new XElement("id", customer.CustomerId), new XElement("name", customer.CustomerName), new XElement("address", customer.CustomerAddress))); customerData.Save(filePath); }
// accepts modified customer object public void EditCustomer(CustomerEntity customer) { XElement customerExisting = customerData.Root.Elements("customer").Where(i => (int)i.Element("id") == customer.CustomerId).FirstOrDefault(); customerExisting.SetElementValue("name", customer.CustomerName); customerExisting.SetElementValue("address", customer.CustomerAddress); customerData.Save(filePath); }
private Customer Map(CustomerEntity entity) { var model = new Customer { Id = entity.Id, DisplayName = entity.DisplayName }; return model; }
public void StoreData() { var storage = new AzureTableStorageProvider(); const string tableName = "people"; storage.CreateTable(tableName); // Create a new customer entity var customer1 = new CustomerEntity("Harp", "Walter") { Email = "*****@*****.**", PhoneNumber = "425-555-0101" }; // Add the new customer to the people table storage.AddObject(tableName, customer1); // Commit the operation to the table service storage.Commit(); //storage.GetObject(); }
static void Main(string[] args) { // Retrieve the storage account from the connection string. CloudStorageAccount storageAccount = CloudStorageAccount.Parse("DefaultEndpointsProtocol=https;AccountName=aayazokulu;AccountKey=vcGOIzfmMjrj+lEBE+MADWNHYlR8MyFHChD2/0OSqmWDUzvaYt1G1CIBz9BhM9azTxftEH4KalvUpbgwn1IF8w=="); // Create the table client. CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); // Create the CloudTable object that represents the "people" table. CloudTable table = tableClient.GetTableReference("people"); // Create a new customer entity. CustomerEntity customer1 = new CustomerEntity("Harp", "Walter"); customer1.Email = "*****@*****.**"; customer1.PhoneNumber = "425-555-0101"; // Create the TableOperation that inserts the customer entity. TableOperation insertOperation = TableOperation.Insert(customer1); // Execute the insert operation. table.Execute(insertOperation); }
public static bool InsertEntityToAzureTable(string tableName, CustomerEntity entity) { System.Diagnostics.Trace.TraceInformation(string.Format("Date = {0}, AzureTableOperation.InsertEntityToAzureTable is Called", DateTime.Now)); // Retrieve the storage account from the connection string. CloudStorageAccount storageAccount = CloudStorageAccount.Parse(GetStorageConnectionString()); // Create the table client. CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); // Create the CloudTable object that represents the "people" table. CloudTable table = tableClient.GetTableReference(tableName); // Create the TableOperation object that inserts the customer entity. TableOperation insertOperation = TableOperation.Insert(entity); // Execute the insert operation. TableResult result = table.Execute(insertOperation); System.Diagnostics.Trace.TraceInformation(string.Format("Date = {0}, AzureTableOperation.InsertEntityToAzureTable insert entity to {1}: {2}", DateTime.Now, tableName, result.ToString())); //TODO: how to determine whether the operation is successful return true; }
public CustomerRegisteredEvent(CustomerEntity entity, float initialCredit) { Customer = entity; InitialCredit = initialCredit; }
public async Task Save(CustomerEntity customer) { await Task.Run(() => _customerDatabase.InsertOne(customer)); }
public static CustomerModel CTM(this CustomerEntity source) => new CustomerModel { Address = new AddressModel() };
public CustomerGroupLinkEntity(CustomerEntity customer, GroupEntity group) { Customer = customer; Group = group; }
private void selectButton_Click(object sender, System.EventArgs e) { _cancelClicked = false; _selectedCustomer = (CustomerEntity)_allCustomers[customersDataGrid.CurrentRowIndex]; this.Close(); }
/// <summary>Konvertira entitet u business object.</summary> protected Customer(CustomerEntity entity) : base(entity) { }
private void NewItem() { current = CustomerEntity.Empty; ShowItem(current); }
/// <summary> /// Delete an entity /// </summary> /// <param name="table">Sample table name</param> /// <param name="deleteEntity">Entity to delete</param> /// <returns>A Task object</returns> private static async Task DeleteEntityAsync(CloudTable table, CustomerEntity deleteEntity) { try { if (deleteEntity == null) { throw new ArgumentNullException("deleteEntity"); } TableOperation deleteOperation = TableOperation.Delete(deleteEntity); await table.ExecuteAsync(deleteOperation); } catch (StorageException e) { Console.WriteLine(e.Message); Console.ReadLine(); throw; } }
/// <summary> /// The Table Service supports two main types of insert operations. /// 1. Insert - insert a new entity. If an entity already exists with the same PK + RK an exception will be thrown. /// 2. Replace - replace an existing entity. Replace an existing entity with a new entity. /// 3. Insert or Replace - insert the entity if the entity does not exist, or if the entity exists, replace the existing one. /// 4. Insert or Merge - insert the entity if the entity does not exist or, if the entity exists, merges the provided entity properties with the already existing ones. /// </summary> /// <param name="table">The sample table name</param> /// <param name="entity">The entity to insert or merge</param> /// <returns>A Task object</returns> private static async Task<CustomerEntity> InsertOrMergeEntityAsync(CloudTable table, CustomerEntity entity) { if (entity == null) { throw new ArgumentNullException("entity"); } try { // Create the InsertOrReplace table operation TableOperation insertOrMergeOperation = TableOperation.InsertOrMerge(entity); // Execute the operation. TableResult result = await table.ExecuteAsync(insertOrMergeOperation); CustomerEntity insertedCustomer = result.Result as CustomerEntity; return insertedCustomer; } catch (StorageException e) { Console.WriteLine(e.Message); Console.ReadLine(); throw; } }
/// <summary> /// Demonstrates basic CRUD operations using a SAS for authentication. /// </summary> /// <param name="table">The table.</param> /// <returns>A Task object</returns> private static async Task BasicDataOperationsWithSasAsync(CloudTable table) { string sharedAccessPolicyName = "sample-policy-" + DateTime.Now.Ticks.ToString(); // Create a shared access policy on the table. // The access policy may be optionally used to provide constraints for // shared access signatures on the table. await CreateSharedAccessPolicy(table, sharedAccessPolicyName); // Generate an ad-hoc SAS on the table, then test the SAS. It permits all CRUD operations on the table. string adHocTableSAS = GetTableSasUri(table); // Create an instance of a customer entity. CustomerEntity customer1 = new CustomerEntity("Johnson", "Mary") { Email = "*****@*****.**", PhoneNumber = "425-555-0105" }; await TestTableSAS(adHocTableSAS, customer1); // Generate a SAS URI for the table, using the stored access policy to set constraints on the SAS. // Then test the SAS. All CRUD operations should succeed. string sharedPolicyTableSAS = GetTableSasUri(table, sharedAccessPolicyName); // Create an instance of a customer entity. CustomerEntity customer2 = new CustomerEntity("Wilson", "Joe") { Email = "*****@*****.**", PhoneNumber = "425-555-0106" }; await TestTableSAS(sharedPolicyTableSAS, customer2); }
/// <summary> /// Demonstrate basic Table CRUD operations. /// </summary> /// <param name="table">The sample table</param> /// <returns>A Task object</returns> private static async Task BasicDataOperationsAsync(CloudTable table) { // Create an instance of a customer entity. See the Model\CustomerEntity.cs for a description of the entity. CustomerEntity customer = new CustomerEntity("Harp", "Walter") { Email = "*****@*****.**", PhoneNumber = "425-555-0101" }; // Demonstrate how to Update the entity by changing the phone number Console.WriteLine("2. Update an existing Entity using the InsertOrMerge Upsert Operation."); customer.PhoneNumber = "425-555-0105"; customer = await InsertOrMergeEntityAsync(table, customer); Console.WriteLine(); // Demonstrate how to Read the updated entity using a point query Console.WriteLine("3. Reading the updated Entity."); customer = await RetrieveEntityUsingPointQueryAsync(table, "Harp", "Walter"); Console.WriteLine(); // Demonstrate how to Delete an entity Console.WriteLine("4. Delete the entity. "); await DeleteEntityAsync(table, customer); Console.WriteLine(); }
public void update(CustomerEntity customerEntity) { _customerDataSource.update(customerEntity); }
public void save(CustomerEntity customerEntity) { _customerDataSource.save(customerEntity); }
public void Update(CustomerEntity entity) { repository.Update(entity); }
public static void Initialize(Context context) { context.Database.EnsureCreated(); HostContentPath = $"{Environment.CurrentDirectory}\\Images"; if (!context.Customers.Any()) { var customers = new CustomerEntity[] { new CustomerEntity { Name = "Иван Иванов", Address = "Проспект Мира д.24", Code = "0000-2021", Account = new AccountEntity { Email = "*****@*****.**", Password = "******", Role = Role.Admin } }, new CustomerEntity { Name = "Вячеслав Петров", Address = "ул. Академика Янгеля д.5", Code = "0001-2021", Account = new AccountEntity { Email = "*****@*****.**", Password = "******", Role = Role.User }, Discount = 10 }, new CustomerEntity { Name = "Александр Ветров", Address = "ул. Планерная д.31", Code = "0002-2021", Account = new AccountEntity { Email = "*****@*****.**", Password = "******", Role = Role.User }, Discount = 10 } }; context.Customers.AddRange(customers); context.SaveChanges(); } if (!context.Products.Any()) { var products = new ProductEntity[] { new ProductEntity { Name = "Молоко", Category = "молочная продукция", Price = 60, ImgPath = $"{HostContentPath}\\milkProducts\\milk.jpg" }, new ProductEntity { Name = "Творог", Category = "молочная продукция", Price = 90, ImgPath = $"{HostContentPath}\\milkProducts\\cottageCheese.jpg" }, new ProductEntity { Name = "Сметана", Category = "молочная продукция", Price = 78, ImgPath = $"{HostContentPath}\\milkProducts\\sourCream.jpg" }, new ProductEntity { Name = "Йогурт", Category = "молочная продукция", Price = 97, ImgPath = $"{HostContentPath}\\milkProducts\\yogurt.jpg" }, new ProductEntity { Name = "Масло", Category = "молочная продукция", Price = 110, ImgPath = $"{HostContentPath}\\milkProducts\\butter.jpg" }, new ProductEntity { Name = "Чизкэйк", Category = "молочная продукция", Price = 250, ImgPath = $"{HostContentPath}\\milkProducts\\cheeseCacke.jpg" }, new ProductEntity { Name = "Хлеб", Category = "хлебная продукция", Price = 50, ImgPath = $"{HostContentPath}\\breadProducts\\bread.jpg" }, new ProductEntity { Name = "Булочка с маком", Category = "хлебная продукция", Price = 63, ImgPath = $"{HostContentPath}\\breadProducts\\bun.jpg" }, new ProductEntity { Name = "Чиабата", Category = "хлебная продукция", Price = 102, ImgPath = $"{HostContentPath}\\breadProducts\\ciabatta.jpg" }, new ProductEntity { Name = "Батон", Category = "хлебная продукция", Price = 57, ImgPath = $"{HostContentPath}\\breadProducts\\loaf.jpg" }, new ProductEntity { Name = "Батон нарезной", Category = "хлебная продукция", Price = 60, ImgPath = $"{HostContentPath}\\breadProducts\\slicedLoaf.jpg" }, new ProductEntity { Name = "Кулич", Category = "хлебная продукция", Price = 220, ImgPath = $"{HostContentPath}\\breadProducts\\kulich.jpg" }, new ProductEntity { Name = "Банан", Category = "фрукты", Price = 61, ImgPath = $"{HostContentPath}\\fruits\\banana.jpg" }, new ProductEntity { Name = "Ананас", Category = "фрукты", Price = 150, ImgPath = $"{HostContentPath}\\fruits\\pineapple.jpg" }, new ProductEntity { Name = "Киви", Category = "фрукты", Price = 130, ImgPath = $"{HostContentPath}\\fruits\\qiwi.jpg" }, new ProductEntity { Name = "Яблоко", Category = "фрукты", Price = 78, ImgPath = $"{HostContentPath}\\fruits\\apple.jpg" }, new ProductEntity { Name = "Груша", Category = "фрукты", Price = 115, ImgPath = $"{HostContentPath}\\fruits\\pear.jpg" }, new ProductEntity { Name = "Виноград", Category = "фрукты", Price = 190, ImgPath = $"{HostContentPath}\\fruits\\grapes.jpg" }, new ProductEntity { Name = "Картофель", Category = "овощи", Price = 20, ImgPath = $"{HostContentPath}\\vegetables\\potato.jpg" }, new ProductEntity { Name = "Лук", Category = "овощи", Price = 15, ImgPath = $"{HostContentPath}\\vegetables\\onion.jpg" }, new ProductEntity { Name = "Морковь", Category = "овощи", Price = 18, ImgPath = $"{HostContentPath}\\vegetables\\carrot.jpg" }, new ProductEntity { Name = "Огурец", Category = "овощи", Price = 41, ImgPath = $"{HostContentPath}\\vegetables\\cucumber.jpg" }, new ProductEntity { Name = "Перец болгарский", Category = "овощи", Price = 68, ImgPath = $"{HostContentPath}\\vegetables\\bolgarPepper.jpg" }, new ProductEntity { Name = "Капута", Category = "овощи", Price = 22, ImgPath = $"{HostContentPath}\\vegetables\\cabbage.jpg" }, new ProductEntity { Name = "Спагети", Category = "макаронные изделия", Price = 30, ImgPath = $"{HostContentPath}\\pastaProducts\\spagetti.jpg" }, new ProductEntity { Name = "Рожки", Category = "макаронные изделия", Price = 31, ImgPath = $"{HostContentPath}\\pastaProducts\\macaroni-2.jpg" }, new ProductEntity { Name = "Вермишель", Category = "макаронные изделия", Price = 45, ImgPath = $"{HostContentPath}\\pastaProducts\\vermicelli.jpg" }, new ProductEntity { Name = "Лапша домашняя", Category = "макаронные изделия", Price = 60, ImgPath = $"{HostContentPath}\\pastaProducts\\homeNoodles.jpg" }, new ProductEntity { Name = "Ролтон", Category = "макаронные изделия", Price = 11, ImgPath = $"{HostContentPath}\\pastaProducts\\macaroni-3.jpg" }, new ProductEntity { Name = "Перья", Category = "макаронные изделия", Price = 34, ImgPath = $"{HostContentPath}\\pastaProducts\\macaroni-1.jpg" }, new ProductEntity { Name = "Мыло", Category = "бытовая химия", Price = 37, ImgPath = $"{HostContentPath}\\householdChemicals\\soap.jpg" }, new ProductEntity { Name = "Гель для посуды", Category = "бытовая химия", Price = 98, ImgPath = $"{HostContentPath}\\householdChemicals\\dishesGel.jpg" }, new ProductEntity { Name = "Порошок стиральный", Category = "бытовая химия", Price = 115, ImgPath = $"{HostContentPath}\\householdChemicals\\miss.jpg" }, new ProductEntity { Name = "Порошок чистящий", Category = "бытовая химия", Price = 42, ImgPath = $"{HostContentPath}\\householdChemicals\\miss-2.jpg" }, new ProductEntity { Name = "Шампунь", Category = "бытовая химия", Price = 113, ImgPath = $"{HostContentPath}\\householdChemicals\\shampoo.jpg" }, new ProductEntity { Name = "кондиционер для белья", Category = "бытовая химия", Price = 118, ImgPath = $"{HostContentPath}\\householdChemicals\\linenconditioner.jpg" }, }; context.Products.AddRange(products); context.SaveChanges(); } }
public void Add(CustomerEntity entity) { repository.Add(entity); }
/// <summary> /// Tests a table SAS to determine which operations it allows. /// </summary> /// <param name="sasUri">A string containing a URI with a SAS appended.</param> /// <param name="customer">The customer entity.</param> /// <returns>A Task object</returns> private static async Task TestTableSAS(string sasUri, CustomerEntity customer) { // Try performing table operations with the SAS provided. // Note that the storage account credentials are not required here; the SAS provides the necessary // authentication information on the URI. // Return a reference to the table using the SAS URI. CloudTable table = new CloudTable(new Uri(sasUri)); // Upsert (add/update) operations: insert an entity. // This operation requires both add and update permissions on the SAS. try { // Insert the new entity. customer = await InsertOrMergeEntityAsync(table, customer); Console.WriteLine("Add operation succeeded for SAS {0}", sasUri); Console.WriteLine(); } catch (StorageException e) { if (e.RequestInformation.HttpStatusCode == 403) { Console.WriteLine("Add operation failed for SAS {0}", sasUri); Console.WriteLine("Additional error information: " + e.Message); Console.WriteLine(); } else { Console.WriteLine(e.Message); Console.ReadLine(); throw; } } // Read operation: query an entity. // This operation requires read permissions on the SAS. try { TableOperation retrieveOperation = TableOperation.Retrieve<CustomerEntity>(customer.PartitionKey, customer.RowKey); TableResult result = await table.ExecuteAsync(retrieveOperation); CustomerEntity customerRead = result.Result as CustomerEntity; if (customerRead != null) { Console.WriteLine("\t{0}\t{1}\t{2}\t{3}", customerRead.PartitionKey, customerRead.RowKey, customerRead.Email, customerRead.PhoneNumber); } Console.WriteLine("Read operation succeeded for SAS {0}", sasUri); Console.WriteLine(); } catch (StorageException e) { if (e.RequestInformation.HttpStatusCode == 403) { Console.WriteLine("Read operation failed for SAS {0}", sasUri); Console.WriteLine("Additional error information: " + e.Message); Console.WriteLine(); } else { Console.WriteLine(e.Message); Console.ReadLine(); throw; } } // Delete operation: delete an entity. try { TableOperation retrieveOperation = TableOperation.Retrieve<CustomerEntity>(customer.PartitionKey, customer.RowKey); TableResult result = await table.ExecuteAsync(retrieveOperation); CustomerEntity customerDelete = result.Result as CustomerEntity; if (customerDelete != null) { await DeleteEntityAsync(table, customerDelete); } Console.WriteLine("Delete operation succeeded for SAS {0}", sasUri); Console.WriteLine(); } catch (StorageException e) { if (e.RequestInformation.HttpStatusCode == 403) { Console.WriteLine("Delete operation failed for SAS {0}", sasUri); Console.WriteLine("Additional error information: " + e.Message); Console.WriteLine(); } else { Console.WriteLine(e.Message); Console.ReadLine(); throw; } } Console.WriteLine(); }
public bool InsertEntityToAzureTable(string tableName, CustomerEntity entity) { System.Diagnostics.Trace.TraceInformation(string.Format("WebRoleService.InsertEntityToAzureTable is called.")); //validation if (tableName.Trim() == "") { System.Diagnostics.Trace.TraceError(string.Format("Error: Table name is empty when call InsertEntityToAzureTable")); return false; } //call worker bool response = false; try { IWorkerService myClient = GetClient(); response = myClient.InsertEntityToAzureTable(tableName, entity); } catch (Exception ex) { System.Diagnostics.Trace.TraceError(string.Format("Error in WebRoleService.InsertEntityToAzureTable: {0}", ex.Message)); } return response; }
/// <summary> /// The Table Service supports two main types of insert operations. /// 1. Insert - insert a new entity. If an entity already exists with the same PK + RK an exception will be thrown. /// 2. Replace - replace an existing entity. Replace an existing entity with a new entity. /// 3. Insert or Replace - insert the entity if the entity does not exist, or if the entity exists, replace the existing one. /// 4. Insert or Merge - insert the entity if the entity does not exist or, if the entity exists, merges the provided entity properties with the already existing ones. /// </summary> /// <param name="table">The sample table name</param> /// <param name="entity">The entity to insert or merge</param> /// <returns></returns> private static async Task <CustomerEntity> InsertOrMergeEntityAsync(CloudTable table, CustomerEntity entity) { if (entity == null) { throw new ArgumentNullException("entity"); } // Create the InsertOrReplace TableOperation TableOperation insertOrMergeOperation = TableOperation.InsertOrMerge(entity); // Execute the operation. TableResult result = await table.ExecuteAsync(insertOrMergeOperation); CustomerEntity insertedCustomer = result.Result as CustomerEntity; return(insertedCustomer); }
public ActionResult SaveForm(string keyValue, CustomerEntity entity) { customerbll.SaveForm(keyValue, entity); return(Success("操作成功。")); }
private void selectButton_Click(object sender, System.EventArgs e) { this.DialogResult = System.Windows.Forms.DialogResult.OK; _selectedCustomer = (CustomerEntity)_allCustomers[customersDataGrid.CurrentRowIndex]; this.Close(); }
/// <summary> /// Performs simple validation and setting property values so on any changes /// they are updated immediately. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void _customerView_ListChanged(object sender, ListChangedEventArgs e) { if (e.PropertyDescriptor != null) { // // Get current customer in current DataGridView row // CustomerEntity currentCustomer = _customerView.CurrentCustomer(_customerBindingSource.Position); Console.WriteLine($" -> {e.ListChangedType.ToString()}"); // // Assert if there are changes to the current row in the DataGridView // if (e.ListChangedType == ListChangedType.ItemChanged) { // // Get data residing in the database table // Customers customerItem = CustomersTestOperations .Context .Customers .FirstOrDefault((customer) => customer.CustomerIdentifier == currentCustomer.CustomerIdentifier); if (customerItem != null) { /* * Did contact first or last name change? * If so we need to update the contact. */ if (e.PropertyDescriptor.DisplayName == "FirstName" || e.PropertyDescriptor.DisplayName == "LastName") { customerItem.Contact.FirstName = currentCustomer.FirstName; customerItem.Contact.LastName = currentCustomer.LastName; } var test1 = currentCustomer.CompanyName; EntityEntry <Customers> customerEntry = CustomersTestOperations.Context.Entry(customerItem); customerEntry.CurrentValues.SetValues(currentCustomer); // // Setup validation on current row data // var validation = ValidationHelper.ValidateEntity(currentCustomer); // // If there are validation error present them to the user // if (validation.HasError) { var errorItems = string.Join(Environment.NewLine, validation.Errors.Select((containerItem) => containerItem.ErrorMessage).ToArray()); MessageBox.Show(errorItems + Environment.NewLine + @"Customer has been reset!!!", @"Corrections needed"); // // Read current values from database // Customers originalCustomer = CustomersTestOperations.CustomerFirstOrDefault(customerItem.CustomerIdentifier); // // reset current item both in Customer object and CustomerEntity object // (there are other ways to deal with this but are dependent on business logic) // customerEntry.CurrentValues.SetValues(originalCustomer); _customerView[_customerBindingSource.Position] = CustomersTestOperations.CustomerByIdentifier(originalCustomer.CustomerIdentifier); _hasValidationErrors = true; } else { _hasValidationErrors = false; CustomersTestOperations.Context.SaveChanges(); } } } } }
public async Task NewCustomer(CustomerEntity cust) { await _repo.AddCustomer(cust); }
public static void Add(CustomerEntity customer) { CustomerDetails.Add(customer); }
public bool SaveCustomer(CustomerEntity customerEntity) { _customerDataAccess = new CustomerDataAccess(_context); return(_customerDataAccess.SaveCustomer(customerEntity)); }
public CustomerEntityExtend(CustomerEntity item) { Tools.CopyModel(this, item); }
public string _CustomerList() { string sql = "select * from [custom_info] order by pname ;select count(id) from custom_info"; DataSet ds = DataFactory.SqlHelper.ExecuteDataset(DataBll.conString.constr, System.Data.CommandType.Text, sql); System.Data.DataTable dt = ds.Tables[0]; int rows = Convert.ToInt32(Convert.IsDBNull(ds.Tables[1].Rows[0][0]) ? 0 : ds.Tables[1].Rows[0][0]); //获得总数 List<CustomerEntity> wdList = new List<CustomerEntity>(); for (int i = 0; i < dt.Rows.Count; i++) { CustomerEntity wd = new CustomerEntity(); wd.id = Convert.ToInt32(dt.Rows[i]["id"] ?? 0); wd.pname = Convert.IsDBNull(dt.Rows[i]["pname"]) ? "" : dt.Rows[i]["pname"].ToString(); wd.psize = Convert.IsDBNull(dt.Rows[i]["psize"]) ? "" : dt.Rows[i]["psize"].ToString(); wd.clicevip = Convert.IsDBNull(dt.Rows[i]["clicevip"]) ? "" : dt.Rows[i]["clicevip"].ToString(); wd.puser = Convert.IsDBNull(dt.Rows[i]["puser"]) ? "" : dt.Rows[i]["puser"].ToString(); wd.userpho = Convert.IsDBNull(dt.Rows[i]["userpho"]) ? "" : dt.Rows[i]["userpho"].ToString(); wd.cstatus = Convert.IsDBNull(dt.Rows[i]["cstatus"]) ? "" : dt.Rows[i]["cstatus"].ToString(); wdList.Add(wd); } string output = JsonConvert.SerializeObject(wdList); string json = @"{""Rows"":" + output + @",""Total"":""" + rows + @"""}"; return json; }
public async Task Update(string id, CustomerEntity customer) { await Task.Run(() => _customerDatabase.ReplaceOne(c => c.Id == id, customer)); }
public void SaveFormApi(string keyValue, OrderEntity orderEntity, List <OrderEntryEntity> orderEntryList, List <ReceivableEntity> receivableentityList, string userid, string username) { IRepository db = new RepositoryFactory().BaseRepository().BeginTrans(); try { decimal realsize = 0; if (!string.IsNullOrEmpty(orderEntity.PhotoPath)) { if (orderEntity.PhotoPath.ToString().Substring(orderEntity.PhotoPath.Length - 1, 1) == ",") { orderEntity.PhotoPath = orderEntity.PhotoPath.Substring(0, orderEntity.PhotoPath.Length - 1); } } if (!string.IsNullOrEmpty(keyValue)) { decimal recA = 0; ////主表 // orderEntity.Modify(keyValue); orderEntity.OrderId = keyValue; if (receivableentityList != null) { //收款 db.Delete <ReceivableEntity>(t => t.OrderId.Equals(keyValue)); foreach (ReceivableEntity receivableEntity in receivableentityList) { System.Threading.Thread.Sleep(10); receivableEntity.PaymentTime = receivableEntity.PaymentTime == null ? DateTime.Now : receivableEntity.PaymentTime; receivableEntity.CreateDate = receivableEntity.CreateDate == null ? DateTime.Now : receivableEntity.CreateDate; receivableEntity.CreateUserId = receivableEntity.CreateUserId == null ? userid : receivableEntity.CreateUserId; receivableEntity.CreateUserName = receivableEntity.CreateUserName == null ? username : receivableEntity.CreateUserName; recA = recA + Convert.ToDecimal(receivableEntity.PaymentPrice) - Convert.ToDecimal(receivableEntity.DrawbackPrice); receivableEntity.ReceivableId = Guid.NewGuid().ToString(); receivableEntity.OrderId = orderEntity.OrderId; //添加收款 db.Insert(receivableEntity); } } if (orderEntryList != null) { //明细 db.Delete <OrderEntryEntity>(t => t.OrderId.Equals(keyValue)); foreach (OrderEntryEntity orderEntryEntity in orderEntryList) { System.Threading.Thread.Sleep(10); orderEntryEntity.RealSize = orderEntryEntity.RealSize == null ? 0 : orderEntryEntity.RealSize; orderEntryEntity.RealAmount = orderEntryEntity.RealAmount == null ? 0 : orderEntryEntity.RealAmount; realsize = realsize + Convert.ToDecimal(orderEntryEntity.RealSize == null ? 0 : orderEntryEntity.RealSize); orderEntryEntity.EstimateSize = 0; orderEntryEntity.EstimateAmount = 0; orderEntryEntity.OrderEntryId = Guid.NewGuid().ToString(); orderEntryEntity.OrderId = orderEntity.OrderId; db.Insert(orderEntryEntity); } } if (orderEntity.OrderStatusName.Contains("已")) { orderEntity.OrderStatusId = "3"; if (string.IsNullOrEmpty(Convert.ToString(orderEntity.FinishDate))) { orderEntity.FinishDate = DateTime.Today; } } else { orderEntity.OrderStatusId = "1"; } //if (Convert.ToString(orderEntity.OrderStatusId) != "3") //{ // orderEntity.FinishDate = null; //} if (recA > 0) { //更改订单状态 if (GetEntity(keyValue).Accounts >= recA) { orderEntity.PaymentState = 3; } else { orderEntity.PaymentState = 2; } if (orderEntity.PayeeModeId == null) { orderEntity.PayeeModeId = "1"; orderEntity.PayeeModeName = "现金"; } } db.Update(orderEntity); orderEntity.SellerId = null; orderEntity.SellerName = null; orderEntity.ModifyDate = DateTime.Now; orderEntity.ModifyUserId = userid; orderEntity.ModifyUserName = username; orderEntity.ReceivedAmount = recA; orderEntity.RealSize = realsize; //施工面积 db.Update(orderEntity); if (GetEntity(keyValue).Description != orderEntity.Description && !string.IsNullOrEmpty(orderEntity.Description)) {//备注和之前不同时,插入备注列表 Client_OrderDescriptionEntity orderDescriptionEntity = new Client_OrderDescriptionEntity(); orderDescriptionEntity.CreateDate = DateTime.Now; orderDescriptionEntity.CreateUserId = userid; orderDescriptionEntity.CreateUserName = username; orderDescriptionEntity.DescriptionId = Guid.NewGuid().ToString(); orderDescriptionEntity.OrderId = orderEntity.OrderId; orderDescriptionEntity.DescriptionContent = orderEntity.Description; db.Insert(orderDescriptionEntity); } } else { CustomerService customerService = new CustomerService(); if (customerService.GetEntityByCondation(orderEntity.CustomerName, orderEntity.ContecterTel).Count() == 0) { CustomerEntity customerEntity = new CustomerEntity(); customerEntity.FullName = orderEntity.CustomerName; customerEntity.Tel = orderEntity.ContecterTel; customerEntity.Mobile = orderEntity.ContecterTel; customerService.SaveFormApi("", customerEntity); orderEntity.CustomerId = customerService.GetEntityByCondation(orderEntity.CustomerName, orderEntity.ContecterTel).ToList()[0].CustomerId; } //主表 orderEntity.SellerId = userid; orderEntity.SellerName = username; if (orderEntity.OrderDate == null) { orderEntity.OrderDate = DateTime.Now; } //orderEntity.OrderDate = DateTime.Now; orderEntity.CreateUserId = userid; orderEntity.CreateUserName = username; orderEntity.OrderId = Guid.NewGuid().ToString(); orderEntity.CreateDate = DateTime.Now; orderEntity.OrderCode = coderuleService.SetBillCodeApi(userid, "", ((int)CodeRuleEnum.Customer_OrderCode).ToString()); coderuleService.UseRuleSeed(orderEntity.CreateUserId, "", ((int)CodeRuleEnum.Customer_OrderCode).ToString(), db);//占用单据号 decimal recA = 0; if (receivableentityList != null) { //收款 // db.Delete<ReceivableEntity>(t => t.OrderId.Equals(keyValue)); foreach (ReceivableEntity receivableEntity in receivableentityList) { System.Threading.Thread.Sleep(10); receivableEntity.CreateDate = DateTime.Now; receivableEntity.PaymentTime = receivableEntity.PaymentTime == null ? DateTime.Now : receivableEntity.PaymentTime; receivableEntity.CreateUserId = userid; receivableEntity.CreateUserName = username; recA = recA + Convert.ToDecimal(receivableEntity.PaymentPrice) - Convert.ToDecimal(receivableEntity.DrawbackPrice); receivableEntity.ReceivableId = Guid.NewGuid().ToString(); receivableEntity.OrderId = orderEntity.OrderId; //添加收款 db.Insert(receivableEntity); } } if (orderEntryList != null) { //明细 foreach (OrderEntryEntity orderEntryEntity in orderEntryList) { System.Threading.Thread.Sleep(10); orderEntryEntity.RealSize = orderEntryEntity.RealSize == null ? 0 : orderEntryEntity.RealSize; orderEntryEntity.RealAmount = orderEntryEntity.RealAmount == null ? 0 : orderEntryEntity.RealAmount; realsize = realsize + Convert.ToDecimal(orderEntryEntity.RealSize == null ? 0 : orderEntryEntity.RealSize); orderEntryEntity.EstimateSize = 0; orderEntryEntity.EstimateAmount = 0; orderEntryEntity.OrderEntryId = Guid.NewGuid().ToString(); orderEntryEntity.OrderId = orderEntity.OrderId; db.Insert(orderEntryEntity); } } if (orderEntity.OrderStatusName.Contains("已")) { orderEntity.OrderStatusId = "3"; if (string.IsNullOrEmpty(Convert.ToString(orderEntity.FinishDate))) { orderEntity.FinishDate = DateTime.Today; } } else { orderEntity.OrderStatusId = "1"; } if (recA > 0) { //更改订单状态 if (orderEntity.Accounts >= recA) { orderEntity.PaymentState = 3; } else { orderEntity.PaymentState = 2; } if (orderEntity.PayeeModeId == null) { orderEntity.PayeeModeId = "1"; orderEntity.PayeeModeName = "现金"; } } orderEntity.RealSize = realsize; //施工面积 orderEntity.ReceivedAmount = recA; db.Insert(orderEntity); if (!string.IsNullOrEmpty(orderEntity.Description)) { Client_OrderDescriptionEntity orderDescriptionEntity = new Client_OrderDescriptionEntity(); orderDescriptionEntity.CreateDate = DateTime.Now; orderDescriptionEntity.CreateUserId = userid; orderDescriptionEntity.CreateUserName = username; orderDescriptionEntity.DescriptionId = Guid.NewGuid().ToString(); orderDescriptionEntity.OrderId = orderEntity.OrderId; orderDescriptionEntity.DescriptionContent = orderEntity.Description; db.Insert(orderDescriptionEntity); } } db.Commit(); } catch { db.Rollback(); throw; } }
public void receive_from_table() { lock (this) { string ipaddress = null; string[] arr = new string[100]; arr = rd1.Split('-'); Console.WriteLine("IP Address : " + arr[0]); Console.WriteLine("Custmer Name : " + arr[1]); Console.WriteLine("Time of day : " + arr[2]); ipaddress = arr[0]; string tableName = arr[1] + arr[2]; CloudStorageAccount storageAccount = CloudStorageAccount.Parse( ConfigurationManager.ConnectionStrings["StorageConnectionString"].ConnectionString); CloudTableClient tableClient1 = storageAccount.CreateCloudTableClient(); CloudTable table1 = null; try { table1 = tableClient1.GetTableReference(tableName); TableQuery<CustomerEntity> query = new TableQuery<CustomerEntity>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.NotEqual, "xyz")); List<CustomerEntity> AddressList = new List<CustomerEntity>(); foreach (CustomerEntity entity in table1.ExecuteQuery(query)) { CustomerEntity ce = new CustomerEntity(); ce.PartitionKey = entity.PartitionKey; ce.RowKey = entity.RowKey; ce.id = entity.id; ce.devicefunction = entity.devicefunction; ce.devicename = entity.devicename; ce.devicetype = entity.devicetype; ce.devtabid = entity.devtabid; ce.ep = entity.ep; ce.vendorname = entity.vendorname; ce.IEEE = entity.IEEE; ce.datetime = entity.datetime; ce.energy1 = entity.energy1; ce.energy2 = entity.energy2; AddressList.Add(ce); } XmlSerializer serializer = new XmlSerializer(typeof(List<CustomerEntity>)); using (TextWriter writer = new StreamWriter("D:\\customerinfofromtable.xml")) { serializer.Serialize(writer, AddressList); } } catch (Exception e) { Console.WriteLine("TABLE NAME= " + tableName + " doesnot exist "); Console.WriteLine("Send again............."); processfun(); } string data; System.IO.StreamReader file1 = new System.IO.StreamReader("D:\\customerinfofromtable.xml"); data = file1.ReadToEnd(); //Console.WriteLine(data); file1.Close(); TcpClient newclient = new TcpClient(); Console.WriteLine("Trying to connect........!"); newclient.Connect(arr[0], 8902); Console.WriteLine("Connected to " + arr[1]); StreamWriter sw = new StreamWriter(newclient.GetStream()); sw.WriteLine(data.ToString()); sw.Flush(); newclient.Close(); Console.WriteLine("Successfully transfered.....!"); } }
protected void btnSend_Click(object sender, EventArgs e) { SMS.APIType = SMSGateway.Site2SMS; SMS.MashapeKey = "pPsD7Kqfn2mshzjqhhbOkQMfGyQgp1TQAf7jsnRTMs6ygiLeUg"; string text = ""; //Email starts using (Imap imap = new Imap()) { Limilabs.Mail.Log.Enabled = true; try { imap.ConnectSSL("imap.gmail.com", 993); // or ConnectSSL for SSL imap.UseBestLogin("*****@*****.**", "zeesense40"); } catch(Exception E) { return; } imap.SelectInbox(); List<long> uids = imap.Search(Flag.All); foreach (long uid in uids) { var eml = imap.GetMessageByUID(uid); IMail email = new MailBuilder() .CreateFromEml(eml); text = email.Text; } imap.Close(); } //Email ends string[] arr=text.Split('~'); string recvName = "",alert=""; if(arr[0]=="&") { recvName = arr[2].ToLower().Trim(); alert = arr[3]; } else if(arr[0]=="^" || arr[0]=="%") { recvName = arr[2].ToLower().Trim(); alert = arr[1]; } //txtyourmoNumber.Text = "9742984490"; SMS.Username = "******"; //txtyourPassword.Text = "12345"; SMS.Password = "******"; //string recvName = arr[2].ToLower().Trim(); // string alert = arr[3]; string phone = null; string tableName = "builder"; CloudStorageAccount storageAccount = CloudStorageAccount.Parse( ConfigurationManager.ConnectionStrings["StorageConnectionString"].ConnectionString); CloudTableClient tableClient1 = storageAccount.CreateCloudTableClient(); CloudTable table1 = null; try { table1 = tableClient1.GetTableReference(tableName); TableQuery<CustomerEntity> query = new TableQuery<CustomerEntity>().Where(TableQuery.GenerateFilterCondition("customername", QueryComparisons.Equal, recvName.ToLower())); List<CustomerEntity> AddressList = new List<CustomerEntity>(); CustomerEntity ce = new CustomerEntity(); foreach (CustomerEntity entity in table1.ExecuteQuery(query)) { phone = entity.contactnumber; break; } if (phone != null) SMS.SendSms(phone, alert); //SendingRandomMessages(recvName, data).Wait(); } catch(Exception e1) { } }
/// <summary> /// Calculates the statistics for the Northwind database and shows them in the form, illustrating the /// direct database power LLBLGen Pro offers you through scalar functions, aggregates, group by and expressions. /// </summary> /// <remarks>No error checking is applied to this routine, it's for illustrating the framework functionality.</remarks> private void CalculateStatistics() { // get amount customers CustomerCollection customers = new CustomerCollection(); int amountCustomers = customers.GetDbCount(); _amountCustomersTextBox.Text = amountCustomers.ToString(); // get all order prices ResultsetFields orderPricesFields = new ResultsetFields(2); orderPricesFields.DefineField(OrderDetailFields.OrderId, 0, "OrderId"); orderPricesFields.DefineField(OrderDetailFields.ProductId, 1, "OrderPrice", "", AggregateFunction.Sum); orderPricesFields[1].ExpressionToApply = (OrderDetailFields.Quantity * OrderDetailFields.UnitPrice); IGroupByCollection groupBy = new GroupByCollection(); groupBy.Add(orderPricesFields[0]); // fetch in a datatable, orderid + the order price. DataTable orderPrices = new DataTable(); TypedListDAO dao = new TypedListDAO(); dao.GetMultiAsDataTable(orderPricesFields, orderPrices, 0, null, null, null, true, groupBy, null, 0, 0); // calculate average order price and which customer has the most expensive order decimal averageOrderPrice = 0.0M; decimal highestOrderPrice = 0.0M; int orderIdWithHighestPrice = 0; for (int i = 0; i < orderPrices.Rows.Count; i++) { decimal currentOrderPrice = (decimal)orderPrices.Rows[i]["OrderPrice"]; if (currentOrderPrice > highestOrderPrice) { highestOrderPrice = currentOrderPrice; orderIdWithHighestPrice = (int)orderPrices.Rows[i]["OrderId"]; } averageOrderPrice += currentOrderPrice; } averageOrderPrice = averageOrderPrice / orderPrices.Rows.Count; _highestOrderPriceTextBox.Text = highestOrderPrice.ToString("C"); _averageOrderPriceTextBox.Text = averageOrderPrice.ToString("C"); // get order with highest price. Pull customer also in 1 go IPrefetchPath prefetchPathCustomer = new PrefetchPath((int)EntityType.OrderEntity); prefetchPathCustomer.Add(OrderEntity.PrefetchPathCustomer); OrderEntity highestOrder = new OrderEntity(); highestOrder.FetchUsingPK(orderIdWithHighestPrice, prefetchPathCustomer); _customerWithHighestOrder = highestOrder.Customer; // already loaded through prefetch path. _highestOrderCustomerTextBox.Text = _customerWithHighestOrder.CompanyName; // get customer with most orders. ResultsetFields orderCustomerFields = new ResultsetFields(2); orderCustomerFields.DefineField(OrderFields.CustomerId, 0, "CustomerID"); orderCustomerFields.DefineField(OrderFields.OrderId, 1, "AmountOrders", "", AggregateFunction.Count); groupBy = new GroupByCollection(); groupBy.Add(orderCustomerFields[0]); SortExpression sorter = new SortExpression(); sorter.Add(new SortClause(orderCustomerFields[1], SortOperator.Descending)); // now fetch the list, just 1 row, ordered descending on amount DataTable orderCustomer = new DataTable(); dao.GetMultiAsDataTable(orderCustomerFields, orderCustomer, 1, sorter, null, null, true, groupBy, null, 0, 0); _mostOrdersPerCustomerTextBox.Text = orderCustomer.Rows[0]["AmountOrders"].ToString(); // we'll assume the data was there, so there is a row. _customerWithMostOrders = new CustomerEntity(orderCustomer.Rows[0]["CustomerID"].ToString()); _mostOrdersCustomerTextBox.Text = _customerWithMostOrders.CompanyName; }
public async Task <string> Handle(CreateSalesCommand request, CancellationToken cancellationToken) { string invoiceNumber = string.Empty; var result = new object(); bool existingCustomer = true; var invoiceId = 1; try { CustomerEntity customer = _context.Customers.Where(c => c.PhoneNumber == request.PhoneNumber).SingleOrDefault(); var lastSales = _context.Sales.OrderByDescending(x => x.SalesId).FirstOrDefault(); if (lastSales != null) { invoiceId = lastSales.SalesId + 1; } if (customer == null) { customer = new CustomerEntity() { Name = request.Name, PhoneNumber = request.PhoneNumber, Email = request.Email }; existingCustomer = false; } invoiceNumber = "ORD-" + customer.PhoneNumber + "-" + invoiceId.ToString(); await _context.BeginTransactionAsync(); if (!existingCustomer) { _context.Customers.Add(customer); await _context.SaveChangesAsync(cancellationToken); } else { if (!string.IsNullOrEmpty(request.Name)) { customer.Name = request.Name; } if (!string.IsNullOrEmpty(request.Email)) { customer.Email = request.Email; } _context.Customers.Update(customer); await _context.SaveChangesAsync(cancellationToken); } var sales = new SalesEntity() { OrderGroup = request.OrderGroup, CustomerId = customer.CustomerId, InvoiceNumber = invoiceNumber, Total = request.Total, PickUpDate = request.PickUpDate }; _context.Sales.Add(sales); await _context.SaveChangesAsync(cancellationToken); await _context.CommitTransactionAsync(); IEnumerable <OrderEntity> orderEntities = _context.Orders.Where(x => x.OrderGroup == request.OrderGroup).ToList(); var totalOrders = orderEntities.Count(); result = new DocketVm() { CustomerName = customer.Name, PhoneNumber = customer.PhoneNumber, DocketNumber = invoiceNumber, PickUpDetails = request.PickUpDate.ToString("dddd, dd MMMM yyyy"), Qty = totalOrders }; } catch (Exception ex) { var exception = ex.Message.ToString(); _context.RollbackTransaction(); throw; } return(JsonConvert.SerializeObject(result)); }
public static async Task <CustomerEntity> InsertOrMergeEntityAsync(CloudTable table, CustomerEntity entity) { if (entity == null) { throw new ArgumentNullException("entity"); } try { // Create the InsertOrReplace table operation TableOperation insertOrMergeOperation = TableOperation.InsertOrMerge(entity); // Execute the operation. TableResult result = await table.ExecuteAsync(insertOrMergeOperation); CustomerEntity insertedCustomer = result.Result as CustomerEntity; if (result.RequestCharge.HasValue) { Console.WriteLine("Request Charge of InsertOrMerge Operation: " + result.RequestCharge); } return(insertedCustomer); } catch (StorageException e) { Console.WriteLine(e.Message); Console.ReadLine(); throw; } }
public void Add(CustomerEntity entity) { _context.Customers.Add(entity); }
/// <summary> /// Función que valida un CustomerEntity antes de ser guardado. /// </summary> /// <param name="customerEntity">CustomerEntity a validar</param> /// <param name="session">Identificador de sesion del usuario.</param> /// <returns>true si se valido correctamente, false en caso contrario</returns> /// <exception cref="ArgumentNullException"> /// si <paramref name="customerEntity"/> es null. /// </exception> /// <exception cref="UtnEmallBusinessLogicException"> /// Si una UtnEmallDataAccessException ocurre en el DataModel. /// </exception> public bool Validate(CustomerEntity customer) { bool result = true; if (customer == null) { throw new ArgumentException("The argument can't be null"); } // Check entity data if (String.IsNullOrEmpty(customer.Name)) { customer.Errors.Add(new Error("Name", "Name", "El nombre no puede estar vacío")); result = false; } if (String.IsNullOrEmpty(customer.Surname)) { customer.Errors.Add(new Error("Surname", "Surname", "El apellido no puede estar vacío")); result = false; } if (String.IsNullOrEmpty(customer.Address)) { customer.Errors.Add(new Error("Address", "Address", "La dirección no puede estar vacía")); result = false; } if (String.IsNullOrEmpty(customer.PhoneNumber)) { customer.Errors.Add(new Error("PhoneNumber", "PhoneNumber", "El número de teléfono no puede estar vacío")); result = false; } if (String.IsNullOrEmpty(customer.UserName)) { customer.Errors.Add(new Error("UserName", "UserName", "El nombre de usuario no puede estar vacío")); result = false; } if (customer.UserName != null) { Collection <CustomerEntity> listOfEquals = customerDataAccess.LoadWhere(CustomerEntity.DBUserName, customer.UserName, false, OperatorType.Equal); if (listOfEquals.Count > 0 && listOfEquals[0].Id != customer.Id) { customer.Errors.Add(new Error("UserName", "UserName", "Nombre de usuario duplicado")); result = false; } } if (String.IsNullOrEmpty(customer.Password)) { customer.Errors.Add(new Error("Password", "Password", "La contraseña no puede estar vacía")); result = false; } if (customer.Birthday == null) { customer.Errors.Add(new Error("Birthday", "Birthday", "La fecha de cumpleaños no puede estar vacía.")); result = false; } if (customer.Preferences == null) { customer.Errors.Add(new Error("Preferences", "Preferences", "Las preferencias no pueden estar vacías")); result = false; } if (customer.DeviceProfile == null) { customer.Errors.Add(new Error("DeviceProfile", "DeviceProfile", "El perfil del dispositivo no puede ser nulo")); result = false; } return(result); }
public void Update(CustomerEntity entity) { _context.Customers.Update(entity); }
public bool InsertEntityToAzureTable(string tableName, CustomerEntity entity) { System.Diagnostics.Trace.TraceInformation(string.Format("Date = {0}, Instance = {1}. WorkerService.InsertEntityToAzureTable is Called", DateTime.Now, RoleEnvironment.CurrentRoleInstance.Id)); return AzureTableOperation.InsertEntityToAzureTable(tableName, entity); }
public static async Task <CustomerEntity> InsertOrMergeEntityAsync(CloudTable table, CustomerEntity entity) { if (entity == null) { throw new ArgumentNullException("entity"); } try { TableOperation insertOrMergeOperation = TableOperation.InsertOrMerge(entity); TableResult result = await table.ExecuteAsync(insertOrMergeOperation); CustomerEntity insertedCustomer = result.Result as CustomerEntity; return(insertedCustomer); } catch (StorageException e) { Console.WriteLine(e.Message); Console.ReadLine(); throw; } }
private void gridCustomers_SelectionChanged(object sender, EventArgs e) { if (gridCustomers.SelectedCells == null || gridCustomers.SelectedCells.Count == 0) current = CustomerEntity.Empty; else current = gridCustomers.Rows[gridCustomers.SelectedCells[0].RowIndex].DataBoundItem as CustomerEntity; ShowItem(current); }
public InsertOrUpdateUserResponse InsertOrUpdateUser(InsertOrUpdateUserRequest request, int?supervisorUserId, int roleId, int branchId) { _context.Configuration.AutoDetectChangesEnabled = false; try { var result = new InsertOrUpdateUserResponse(); TB_R_USER dbUser; var transactionDateTime = DateTime.Now; if (request.ActionType == 1) { // Insert dbUser = null; } else { // Update dbUser = _context.TB_R_USER.Where(user => user.EMPLOYEE_CODE.Trim().ToUpper() == request.EmployeeCodeOld.Trim().ToUpper()).FirstOrDefault(); if (dbUser == null) { result.IsSuccess = false; result.ErrorCode = "8"; result.ErrorMessage = "ไม่สามารถอัพเดตข้อมูล User เนื่องจากไม่พบข้อมูล User (Employee Code Old='" + request.EmployeeCodeOld + "')"; return(result); } } if (dbUser == null) { dbUser = new TB_R_USER(); result.IsNewUser = true; } else { result.IsNewUser = false; // IF (Change Branch) Or (Change Status 1 to 0) if (dbUser.BRANCH_ID != branchId || (dbUser.STATUS == 1 && request.Status == 0)) { #region == Validate Job On Hand == var userId = dbUser.USER_ID; var activeStatuses = new int[] { Constants.SRStatusId.Open, Constants.SRStatusId.InProgress, Constants.SRStatusId.WaitingCustomer, Constants.SRStatusId.RouteBack, }; var countJobOnHand = _context.TB_T_SR.Count(sr => ( (sr.OWNER_USER_ID == userId || sr.DELEGATE_USER_ID == userId) && activeStatuses.Contains(sr.SR_STATUS_ID.Value) ) || ( sr.CREATE_USER == userId && sr.SR_STATUS_ID == Constants.SRStatusId.Draft ) ); if (countJobOnHand > 0) { result.IsSuccess = false; result.ErrorCode = "7"; result.ErrorMessage = "ไม่สามารถอัพเดตข้อมูล User ได้เนื่องจากมีงานค้างในมือ (ServiceRequest)"; return(result); } #endregion } } var actionUser = _context.TB_R_USER.Where(user => user.USERNAME.Trim().ToUpper() == request.ActionUsername.Trim().ToUpper()).FirstOrDefault(); if (actionUser == null) { if (dbUser == null) { result.IsSuccess = false; result.ErrorCode = "9"; result.ErrorMessage = "ไม่สามารถอัพเดตข้อมูล User เนื่องจากไม่พบข้อมูล Action User (Action Username='******')"; return(result); } } dbUser.BRANCH_ID = branchId; dbUser.SUPERVISOR_ID = supervisorUserId; dbUser.FIRST_NAME = ValueOrDefault(request.FirstName); dbUser.LAST_NAME = ValueOrDefault(request.LastName); dbUser.USERNAME = ValueOrDefault(request.WindowsUsername); dbUser.STATUS = Convert.ToInt16(request.Status); dbUser.ROLE_ID = roleId; dbUser.EMPLOYEE_CODE = ValueOrDefault(request.EmployeeCodeNew); dbUser.UPDATE_DATE = transactionDateTime; dbUser.IS_GROUP = request.IsGroup; dbUser.POSITION_CODE = ValueOrDefault(request.PositionCode); dbUser.MARKETING_CODE = ValueOrDefault(request.MarketingCode); dbUser.EMAIL = ValueOrDefault(request.Email); dbUser.ROLE_SALE = ValueOrDefault(request.RoleSale); dbUser.MARKETING_TEAM = ValueOrDefault(request.MarketingTeam); dbUser.LINE = ValueOrDefault(request.Line); dbUser.RANK = ValueOrDefault(request.Rank); dbUser.EMPLOYEE_TYPE = ValueOrDefault(request.EmployeeType); dbUser.COMPANY_NAME = ValueOrDefault(request.CompanyName); dbUser.TELESALE_TEAM = ValueOrDefault(request.TelesaleTeam); dbUser.MARKETING_FLAG = request.MarketingFlag; if (result.IsNewUser) { for (var i = 0; i < 3; i++) { var phone = new TB_R_USER_PHONE(); phone.TB_R_USER = dbUser; phone.PHONE_NO = i == 0 ? request.Phone1 : i == 1 ? request.Phone2 : request.Phone3; phone.ORDER = Convert.ToInt16(i + 1); phone.CREATE_DATE = transactionDateTime; phone.UPDATE_DATE = transactionDateTime; _context.TB_R_USER_PHONE.Add(phone); } } else { var dbPhoneList = dbUser.TB_R_USER_PHONE.OrderBy(p => p.ORDER).Take(10).ToList(); InsertOrUpdateUserPhone(dbPhoneList, request.Phone1, 1, dbUser, transactionDateTime); InsertOrUpdateUserPhone(dbPhoneList, request.Phone2, 2, dbUser, transactionDateTime); InsertOrUpdateUserPhone(dbPhoneList, request.Phone3, 3, dbUser, transactionDateTime); } if (result.IsNewUser) { dbUser.CREATE_USERNAME = ValueOrDefault(request.ActionUsername); dbUser.UPDATE_USERNAME = ValueOrDefault(request.ActionUsername); dbUser.CREATE_DATE = transactionDateTime; dbUser.UPDATE_DATE = transactionDateTime; _context.TB_R_USER.Add(dbUser); } else { dbUser.UPDATE_USERNAME = ValueOrDefault(request.ActionUsername); dbUser.UPDATE_DATE = transactionDateTime; SetEntryStateModified(dbUser); } this.Save(); if (!request.IsGroup) { var _customerDataAccess = new CustomerDataAccess(_context); CustomerEntity customerEntity; bool isCreateCustomer; if (result.IsNewUser) { isCreateCustomer = true; customerEntity = new CustomerEntity(); } else { customerEntity = _customerDataAccess.GetCustomerByEmployeeID(dbUser.USER_ID); // If Update but no have Customer for this user >> It will create if (customerEntity == null) { customerEntity = new CustomerEntity(); isCreateCustomer = true; } else { isCreateCustomer = false; } } // Create/Update Customer for this user if (isCreateCustomer) { // Create Customer var _commonDataAccess = new CommonDataAccess(_context); var subscriptionType = _commonDataAccess.GetSubscriptTypeByCode(Constants.DefaultSubscriptionTypeForUser); customerEntity.CustomerType = Constants.CustomerType.Employee; customerEntity.FirstNameThai = request.FirstName; customerEntity.LastNameThai = request.LastName; customerEntity.SubscriptType = subscriptionType; customerEntity.CardNo = request.EmployeeCodeNew; customerEntity.Email = request.Email; customerEntity.EmployeeId = dbUser.USER_ID; customerEntity.TitleThai = new TitleEntity(); customerEntity.TitleEnglish = new TitleEntity(); customerEntity.CreateUser = new UserEntity() { UserId = actionUser.USER_ID }; customerEntity.UpdateUser = new UserEntity() { UserId = actionUser.USER_ID }; customerEntity.PhoneList = new List <PhoneEntity>(); if (!string.IsNullOrEmpty(request.Phone1)) { customerEntity.PhoneList.Add(new PhoneEntity() { PhoneNo = request.Phone1 }); } if (!string.IsNullOrEmpty(request.Phone2)) { customerEntity.PhoneList.Add(new PhoneEntity() { PhoneNo = request.Phone2 }); } if (!string.IsNullOrEmpty(request.Phone3)) { customerEntity.PhoneList.Add(new PhoneEntity() { PhoneNo = request.Phone3 }); } var isSaveCustomerSuccess = _customerDataAccess.SaveCustomer(customerEntity); if (!isSaveCustomerSuccess) { return(new InsertOrUpdateUserResponse() { IsSuccess = false, ErrorCode = "6", ErrorMessage = "Cannot create customer for this user.", }); } } else { customerEntity.FirstNameThai = request.FirstName; customerEntity.LastNameThai = request.LastName; customerEntity.CardNo = request.EmployeeCodeNew; customerEntity.Email = request.Email; customerEntity.TitleThai = new TitleEntity(); customerEntity.TitleEnglish = new TitleEntity(); customerEntity.CreateUser = new UserEntity() { UserId = actionUser.USER_ID }; customerEntity.UpdateUser = new UserEntity() { UserId = actionUser.USER_ID }; if (customerEntity.PhoneList == null) { customerEntity.PhoneList = new List <PhoneEntity>(); } var phones = new List <string>(); if (!string.IsNullOrEmpty(request.Phone1)) { phones.Add(request.Phone1); } if (!string.IsNullOrEmpty(request.Phone2)) { phones.Add(request.Phone2); } if (!string.IsNullOrEmpty(request.Phone3)) { phones.Add(request.Phone3); } if (phones.Count > customerEntity.PhoneList.Count) { var diff = (phones.Count - customerEntity.PhoneList.Count); for (int i = 0; i < diff; i++) { customerEntity.PhoneList.Add(new PhoneEntity()); } } else if (phones.Count < customerEntity.PhoneList.Count) { var diff = (customerEntity.PhoneList.Count - phones.Count); for (int i = 0; i < diff; i++) { customerEntity.PhoneList.RemoveAt(customerEntity.PhoneList.Count - 1); } } for (int i = 0; i < phones.Count; i++) { customerEntity.PhoneList[i].PhoneNo = phones[i]; } var isSaveCustomerSuccess = _customerDataAccess.SaveCustomer(customerEntity); if (!isSaveCustomerSuccess) { return(new InsertOrUpdateUserResponse() { IsSuccess = false, ErrorCode = "6", ErrorMessage = "Cannot update customer for this user.", }); } } } result.IsSuccess = true; return(result); } catch (Exception ex) { Logger.Error("Exception occur:\n", ex); return(new InsertOrUpdateUserResponse() { IsSuccess = false, ErrorCode = "1", ErrorMessage = ex.Message, }); } finally { _context.Configuration.AutoDetectChangesEnabled = false; } }
private void ShowItem(CustomerEntity ent) { lblId.Text = ent.Id.HasValue ? ent.Id.Value.ToString() : string.Empty; txtName.Text = ent.Name; txtAddress.Text = ent.Address; txtAddress2.Text = ent.Address2; txtPhone.Text = ent.Phone; txtEmail.Text = ent.Email; if (cbCustomerTypes.Items.Count > 0) cbCustomerTypes.SelectedIndex = (int)(ent.DCustomerType ?? 0); txtComment.Text = ent.Comment; }
/// <summary> /// CTor /// </summary> /// <param name="customer">the customer to manage</param> public CustomerManager(CustomerEntity customer) : this() { // load customer and set as active. SetCustomerAsCurrent(customer); }
public MyPrincipal(EmployeeEntity EmployeeEntity = null, CustomerEntity CustomerEntity = null) { this.EmployeeEntity = EmployeeEntity; this.CustomerEntity = CustomerEntity; }
/// <summary>Po potrebi konvertira entity u business objekt.</summary> public static Customer ConvertEntityToBusinessObject(CustomerEntity entity) { Customer bizobj = entity as Customer; if (bizobj == null) bizobj = new Customer(entity); return bizobj; }