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));
}
