private async static Task <string> CreatePool(ModelCustomer customer, ProductName _productName) { try { string message = null; switch (_productName) { case ProductName.Concentrador: { message = await CommandWin32.Execute(@"C:\Windows\System32\inetsrv\", "appcmd.exe", $" add apppool /name:{customer.RootDirectory}-Concentrador"); break; } default: { break; } } return(message); } catch (Exception err) { return(err.Message); } }
public IActionResult Add(ModelCustomer customer) { try { var customerValue = _repository.Find(customer.CustomerId); if (customerValue == null) { _repository.Add(customer); return(Ok(customer.CustomerId.ToString())); } else { customerValue.Cnpj = customer.Cnpj; customerValue.CodeCeltaBs = customer.CodeCeltaBs; customerValue.CompanyName = customer.CompanyName; customerValue.FantasyName = customer.FantasyName; customerValue.RootDirectory = customer.RootDirectory; _repository.Update(customerValue); return(NoContent()); } } catch (Exception err) { return(BadRequest(err)); } }
protected void btnSubmit_Click(object sender, EventArgs e) { int result = 0; ModelCustomer customer = new ModelCustomer { CustomerId = Convert.ToInt32(txtCustomerID.Text), CustomerName = txtCustomerName.Text, City = txtCity.Text, Grade = Convert.ToInt32(txtGrade.Text), SalesmanId = Convert.ToInt32(txtSalesmanID.Text) }; BusinessLayer bl = new BusinessLayer(); result = bl.EnterNewCustomer(customer); if (result > 0) { txtCity.Text = ""; txtCustomerID.Text = ""; txtCustomerName.Text = ""; txtGrade.Text = ""; txtSalesmanID.Text = ""; lblResult.Text = "Record Inserted Successfully"; } else { lblResult.ForeColor = System.Drawing.Color.Red; lblResult.Text = "Error: Something going wrong"; } FillDataToGridView(); }
/// <summary> /// constructor para abrir customermanager /// </summary> public CustomersManager() { InitializeComponent(); model = new ModelCustomer(); //rellenar datagrid de los clientes this.toDGV(); }
public async static Task <string> CreateSite(ModelCustomer customer) { try { string DefaultDir = @"c:\Celta Business Solutions\" + customer.RootDirectory; DirectoryInfo dirSource = new DirectoryInfo(DefaultDir); if (!dirSource.Exists) { try { await ServicesCeltaWare.Tools.CommandWin32.Copy(@"c:\Celta Business Solutions\Empty\", @"c:\Celta Business Solutions\" + customer.RootDirectory, true, true); } catch (Exception) { throw new DirectoryNotFoundException( "Não foi possível criar o diretório: " + DefaultDir); } } // string message = await ServicesCeltaWare.Tools.CommandWin32.Execute(@"C:\Windows\System32\inetsrv\", "appcmd.exe", $" add site /name:{customer.RootDirectory + "-CeltaBS"} /physicalPath:" + "\"" + DefaultDir + "\"" + $" /bindings:http/*:{customer.CodeCeltaBs}:"); return(message); } catch (Exception err) { return(err.Message); } }
public async Task <IActionResult> StartCloud(ModelCustomer customer) { try { await ServicesCeltaWare.Tools.CommandWin32.Copy(@"c:\Celta Business Solutions\Empty\", @"c:\Celta Business Solutions\" + customer.RootDirectory, true, true); var message = ServicesCeltaWare.Tools.Helpers.CustomerHelpers.CreateSite(customer); string messagePool = await ServicesCeltaWare.Tools.Helpers.CustomerHelpers.CreatePool(customer); string messageChangePool = await ServicesCeltaWare.Tools.Helpers.CustomerHelpers.ChangePool(customer, ServicesCeltaWare.Model.Enum.ProductName.None); customer.IsCloud = true; await _repository.UpdateAsynch(customer); return(Ok(customer.CustomerId)); } catch (Exception err) { if (err.InnerException == null) { return(BadRequest(err.Message + "\n" + err.InnerException.Message)); } return(BadRequest(err.Message)); } }
public ModelCustomer Customer() { var item = DB.Customer.Where(x => x.CUSTOMER_ID == AuthCustomer.CustomerId).FirstOrDefault(); if (item == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } var model = new ModelCustomer(item); return(model); }
public async Task <bool> SaveCustomer(ModelCustomer customer) { try { return(await _mobileDataApi.SaveCustomer(customer)); } catch (Exception ex) { ErrorHandler.HandleError(ex); Mvx.Resolve <IUserInteraction>().ToastErrorAlert(ex.ToString()); } return(false); }
public bool SaveCustomer(ModelCustomer modelCustomer) { bool isSaveCustomer = false; SqlConnection sqlConnection = new SqlConnection(connection); string query = @"INSERT INTO Customer(CustomerCode, CustomerName, CustomerAddress, CustomerEmail, Contact, LoyaltyPoint)VALUES('" + modelCustomer.CustomerCode + "' , '" + modelCustomer.CustomerName + "', '" + modelCustomer.CustomerAddress + "', '" + modelCustomer.CustomerEmail + "', '" + modelCustomer.Contact + "', " + modelCustomer.LoyaltyPoint + ")"; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); sqlConnection.Open(); int isExecute = sqlCommand.ExecuteNonQuery(); if (isExecute > 0) { isSaveCustomer = true; } sqlConnection.Close(); return(isSaveCustomer); }
//hien thi chi tiet khach hang public JsonResult GetInfoCustomer(int Id_Customer) { Customer a = db.Customers.Where(x => x.Id_Customer == Id_Customer).FirstOrDefault(); ModelCustomer c = new ModelCustomer { Id_Customer = a.Id_Customer, FullName = a.FullName, CountCDBorrow = db.OrderDetails.Count((t => t.Orders.Id_Customer == Id_Customer && t.Status == "Chưa Trả")), NumDiskLate = db.OrderDetails.Count(k => k.Orders.Id_Customer == Id_Customer && k.Status == "Chưa Trả" && k.DateDue < DateTime.Now), Fine = a.Fine }; string val = string.Empty; val = JsonConvert.SerializeObject(c, Formatting.Indented, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); return(Json(val, JsonRequestBehavior.AllowGet)); }
//Chỉnh sửa public JsonResult GetCustomerById(int Id_Customer) { Customer model = db.Customers.Where(x => x.Id_Customer == Id_Customer).SingleOrDefault(); ModelCustomer s = new ModelCustomer(); s.Id_Customer = model.Id_Customer; s.FullName = model.FullName; s.Address = model.Address; s.Phone = model.Phone; string value = string.Empty; value = JsonConvert.SerializeObject(s, Formatting.Indented, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); return(Json(value, JsonRequestBehavior.AllowGet)); }
public async static Task <string> CreatePool(ModelCustomer customer) { try { string message = await ServicesCeltaWare.Tools.CommandWin32.Execute(@"C:\Windows\System32\inetsrv\", "appcmd.exe", $" add apppool /name:{customer.RootDirectory}-CeltaBS"); //message += await ServicesCeltaWare.Tools.CommandWin32.Execute(@"C:\Windows\System32\inetsrv\", // "appcmd.exe", // $" set apppool /apppool.name:\"{customer.RootDirectory}-CeltaBS\" /enable32bitapponwin64:true"); return(message); } catch (Exception err) { return(err.Message); } }
public int InsertCustomer(ModelCustomer customer) { try { string query = $"INSERT INTO Customer (customer_id, cust_name, city, grade, salesman_id) VALUES ({customer.CustomerId},'{customer.CustomerName}','{customer.City}',{customer.Grade},{customer.SalesmanId});"; SqlCommand cmd = new SqlCommand(query, _connection); _connection.Open(); int result = cmd.ExecuteNonQuery(); _connection.Close(); cmd.Dispose(); return(result); } catch (SqlException e) { return(0); throw new Exception(e.Message); } }
public async static Task <string> ChangePool(ModelCustomer customer, ServicesCeltaWare.Model.Enum.ProductName _productName) { try { string message = null; switch (_productName) { case ServicesCeltaWare.Model.Enum.ProductName.None: { message = await ServicesCeltaWare.Tools.CommandWin32.Execute(@"C:\Windows\System32\inetsrv\", "appcmd.exe", $" set site /site.name:{customer.RootDirectory}-CeltaBS /[path='/'].applicationPool:{customer.RootDirectory}-CeltaBS"); break; } case ServicesCeltaWare.Model.Enum.ProductName.BSF: { message = await ServicesCeltaWare.Tools.CommandWin32.Execute(@"C:\Windows\System32\inetsrv\", "appcmd.exe", $" set site /site.name:{customer.RootDirectory}-CeltaBS /[path='/BSF'].applicationPool:{customer.RootDirectory}-CeltaBS"); break; } case ServicesCeltaWare.Model.Enum.ProductName.CCS: { message = await ServicesCeltaWare.Tools.CommandWin32.Execute(@"C:\Windows\System32\inetsrv\", "appcmd.exe", $" set site /site.name:{customer.RootDirectory}-CeltaBS /[path='/CCS'].applicationPool:{customer.RootDirectory}-CeltaBS"); break; } } return(message); } catch (Exception err) { return(err.Message); } }
private async static Task <string> ChangePool(ModelCustomer customer, ProductName _productName) { try { string message = null; switch (_productName) { case ProductName.None: { break; } case ProductName.BSF: { break; } case ProductName.CCS: { break; } case ProductName.Concentrador: { message = await CommandWin32.Execute(@"C:\Windows\System32\inetsrv\", "appcmd.exe", $" set site /site.name:{customer.RootDirectory}-CeltaBS /[path='/CCS'].applicationPool:{customer.RootDirectory}-Concentrador"); break; } } return(message); } catch (Exception err) { return(err.Message); } }
public int EnterNewCustomer(ModelCustomer customer) { DBAccess addCustomer = new DBAccess(); return(addCustomer.InsertCustomer(customer)); }
public bool SaveCustomer(ModelCustomer modelCustomer) { return(_customerRepository.SaveCustomer(modelCustomer)); }