public async Task Execute(Input input)
{
Guid CustomerId;
var result = CommonAccess.GetAccessCustomer(input.CustomerId, _accountRepository, _loginUserService).Result.ToString();
if (!Guid.TryParse(result, out CustomerId))
{
_outputHandler.Error(result);
return;
}
ICustomer customer = await registerUserService.GetCustomer(CustomerId);
if (customer == null)
{
_outputHandler.Error($"The customer {CustomerId} does not exists or is not processed yet.");
return;
}
List <Boundaries.GetCustomerDetails.Account> accounts = new List <Boundaries.GetCustomerDetails.Account>();
foreach (Guid accountId in customer.Accounts)
{
IAccount account = await _accountRepository.Get(accountId);
if (account != null)
{
Boundaries.GetCustomerDetails.Account accountOutput = new Boundaries.GetCustomerDetails.Account(account);
accounts.Add(accountOutput);
}
}
Output output = new Output(customer, accounts);
_outputHandler.Handle(output);
}
public async Task Execute(Input input)
{
Guid AccountId;
var result = CommonAccess.GetAccessAccount(input.AccountId, _accountRepository, _loginUserService).Result.ToString();
if (!Guid.TryParse(result, out AccountId))
{
_outputHandler.Error(result);
return;
}
IAccount account = await _accountRepository.Get(AccountId);
if (account == null)
{
_outputHandler.Error($"The account {input.AccountId} does not exists or is already closed.");
return;
}
if (account.IsClosingAllowed())
{
await _accountRepository.Delete(account);
}
var output = new Output(account);
_outputHandler.Handle(output);
}
public async Task Execute(Input input)
{
Guid AccountId;
var result = CommonAccess.GetAccessAccount(input.AccountId, _accountRepository, _loginUserService).Result.ToString();
if (!Guid.TryParse(result, out AccountId))
{
_outputHandler.Error(result);
return;
}
IAccount account = await _accountRepository.Get(AccountId);
if (account == null)
{
_outputHandler.Error($"The account {input.AccountId} does not exists or is already closed.");
return;
}
ICredit credit = account.Deposit(input.Amount);
await _accountRepository.Update(account, credit);
Output output = new Output(
credit,
account.GetCurrentBalance());
_outputHandler.Handle(output);
}
public int Delete(AcquisitionBaseData model)
{
return(CommonAccess.ComSQLiteDelete(model, "ID"));
//var sql = "DELETE FROM [AcquisitionBaseData] WHERE [Id]=@Id";
//var conn = new SQLiteConnection(connstr);
//object[] para = { new SQLiteParameter("@Id", model.Id) };
//return SqLiteHelper.ExecuteNonQuery(conn, sql, para);
}
public int Insert(AcquisitionBaseData model)
{
return(CommonAccess.ComSQLiteInsert(model));
//var sql = "INSERT INTO [AcquisitionBaseData] ([Code],[Confidence],[Remark],[Name],[Value]) VALUES (@Code,@Confidence,@Remark,@Name,@Value)";
//var conn = new SQLiteConnection(connstr);
//object[] para = {
// new SQLiteParameter("@Code", model.Code),
// new SQLiteParameter("@Confidence", model.Confidence),
// new SQLiteParameter("@Remark", model.Remark),
// new SQLiteParameter("@Name", model.Name),
// new SQLiteParameter("@Value", model.Value)
// };
//return SqLiteHelper.ExecuteNonQuery(conn, sql, para);
}
public int Update(AcquisitionBaseData model, string _identity)
{
return(CommonAccess.ComSQLiteUpdate(model, _identity));
//var sql = "Update [AcquisitionBaseData] set [Code] = @Code,[Confidence]=@Confidence,[Remark] = @Remark,[Name]=@Name,[Value]=@Value WHERE [Id] = @Id";
//var conn = new SQLiteConnection(connstr);
//object[] para = {
// new SQLiteParameter("@Code",model.Code),
// new SQLiteParameter("@Confidence",model.Confidence),
// new SQLiteParameter("@Remark",model.Remark),
// new SQLiteParameter("@Name",model.Name),
// new SQLiteParameter("@Value",model.Value),
// new SQLiteParameter("@Id",model.Id)
// };
//return SqLiteHelper.ExecuteNonQuery(conn, sql, para);
}
public ObservableCollection <AcquisitionBaseData> Select(string _sqlwhere)
{
return(CommonAccess.ComSQLiteSelect <AcquisitionBaseData>(_sqlwhere));
//var collection = new ObservableCollection<AcquisitionBaseData>();
//var sql = "SELECT * FROM [AcquisitionBaseData] ";
//var conn = new SQLiteConnection(connstr);
//var ds = SqLiteHelper.ExecuteDataSet(conn, sql, null);
//if (ds != null && ds.Tables.Count > 0)
//{
// foreach (DataRow dr in ds.Tables[0].Rows)
// {
// var resource = new AcquisitionBaseData();
// resource.Id = int.Parse(dr["Id"].ToString());
// resource.Code = int.Parse(dr["Code"].ToString());
// resource.Confidence = int.Parse(dr["Confidence"].ToString());
// resource.Name = dr["Name"].ToString();
// resource.Remark = dr["Remark"].ToString();
// collection.Add(resource);
// }
//}
//return collection;
}
public int Delete(EquipmentAlarmRecord model)
{
return(CommonAccess.ComSQLiteDelete(model, "ID"));
}
public int Update(EquipmentAlarmRecord model, string _identity)
{
return(CommonAccess.ComSQLiteUpdate(model, _identity));
}
public int Update(AlarmHistory model, string _identity)
{
return(CommonAccess.ComSQLiteUpdate(model, _identity));
}
public ObservableCollection <AlarmHistory> Select(string _sqlwhere)
{
return(CommonAccess.ComSQLiteSelect <AlarmHistory>(_sqlwhere));
}
public int Update(SystemModule model, string _identity)
{
return(CommonAccess.ComSQLiteUpdate(model, _identity));
}
public int Insert(EquipmentLedger model)
{
return(CommonAccess.ComSQLiteInsert(model));
}
public int Delete(Role model)
{
return(CommonAccess.ComSQLiteDelete(model, "ID"));
}
public int Insert(Role model)
{
return(CommonAccess.ComSQLiteInsert(model));
}
public int Delete(SystemSetting model)
{
return(CommonAccess.ComSQLiteDelete(model, "ID"));
}
public int Insert(SystemSetting model)
{
return(CommonAccess.ComSQLiteInsert(model));
}
public ObservableCollection <SystemModule> Select(string _sqlwhere)
{
return(CommonAccess.ComSQLiteSelect <SystemModule>(_sqlwhere));
}
public int Insert(SystemModule model)
{
return(CommonAccess.ComSQLiteInsert(model));
}
public int Update(EquipmentLedger model, string _identity)
{
return(CommonAccess.ComSQLiteUpdate(model, _identity));
}
public int Delete(SystemModule model)
{
return(CommonAccess.ComSQLiteDelete(model, "ID"));
}
public int Delete(EquipmentLedger model)
{
return(CommonAccess.ComSQLiteDelete(model, "ID"));
}
public int Insert(AlarmHistory model)
{
return(CommonAccess.ComSQLiteInsert(model));
}
public ObservableCollection <Department> Select(string _sqlwhere)
{
return(CommonAccess.ComSQLiteSelect <Department>(_sqlwhere));
}
public int Delete(AlarmHistory model)
{
return(CommonAccess.ComSQLiteDelete(model, "ID"));
}
public int Update(Department model, string _identity)
{
return(CommonAccess.ComSQLiteUpdate(model, _identity));
}
public int Insert(Department model)
{
return(CommonAccess.ComSQLiteInsert(model));
}
public ObservableCollection <EquipmentAlarmRecord> Select(string _sqlwhere)
{
return(CommonAccess.ComSQLiteSelect <EquipmentAlarmRecord>(_sqlwhere));
}
public int Delete(Department model)
{
return(CommonAccess.ComSQLiteDelete(model, "ID"));
}
public int Insert(EquipmentAlarmRecord model)
{
return(CommonAccess.ComSQLiteInsert(model));
}
