public BE_Json DeleteBankMaster(BE_BankMaster _BeBankMaster)
{
//BL_Bank _blBank = new BL_Bank();
//_blBank.connectionString = AppConfig.DbConnection;
//return _blBank.DeleteBankMaster(_BeBankMaster);
BE_Json objJson = null;
var objListaAux = string.Empty;
try
{
BL_Bank _blBank = new BL_Bank();
_blBank.connectionString = AppConfig.DbConnection;
//return _blBank.GetCompanyBankBalance(companyCode);
objListaAux = JsonConvert.SerializeObject(_blBank.DeleteBankMaster(_BeBankMaster));
objJson = new BE_Json();
objJson.data = objListaAux;
objJson.status = CManager.RESULTADO_WCF.OK;
}
catch (Exception ex)
{
objJson = new BE_Json();
objJson.data = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString();
objJson.status = CManager.RESULTADO_WCF.ERROR;
objJson.status = CManager.RESULTADO_WCF.ERROR;
}
finally
{
objListaAux = null;
}
return(objJson);
}
public List <BE_BankMaster> getBankMaster()
{
BE_BankMaster _BeBankMaster = null;
List <BE_BankMaster> _lstBankMaster = new List <BE_BankMaster>();
Dictionary <string, object> parameters = new Dictionary <string, object>();
var rows = _database.QuerySP("sps_getBankMaster", parameters);
foreach (var row in rows)
{
_BeBankMaster = new BE_BankMaster();
_BeBankMaster.bankMasterId = string.IsNullOrEmpty(row["Id"]) ? 0 : int.Parse(row["Id"]);
_BeBankMaster.description = row["Description"];
_lstBankMaster.Add(_BeBankMaster);
}
return(_lstBankMaster);
}
public BE_BankMaster deleteBankMaster(BE_BankMaster _BeBankMaster)
{
int filasAfectadas = 0;
string strError_Mensaje = string.Empty;
bool boResultado = false;
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("_id", _BeBankMaster.bankMasterId);
filasAfectadas = _database.ExecuteSP("spd_deleteBankMaster", parameters);
boResultado = (filasAfectadas > 0);
if (boResultado)
{
return(_BeBankMaster);
}
return(null);
}
public BE_BankMaster CreateBankMaster(BE_BankMaster _BeBankMaster)
{
_database = new MySQLDatabase(connectionString);
return(new DA_Bank(_database).createBankMaster(_BeBankMaster));
}
