/*
* Developer: Sajid Khan
* Date: 7-5-19
* Action: Insert purchase order Ledger data to database
* Input: new Purchase Orders Ledger data
* output: string of PurchaseOrders Ledger id
*/
public async Task <string> Create(PurchaseOrderLedger NewPurchaseOrder)
{
using (IDbConnection conn = Connection)
{
var result = await conn.InsertAsync <PurchaseOrderLedger>(NewPurchaseOrder);
return(result.ToString());
}
}
/*
* Developer: Sajid Khan
* Date: 7-5-19
* Action: update purchase order Ledger data by id from database
* Input: purchase order Ledger data
* output: Boolean
*/
public async Task <Boolean> Update(PurchaseOrderLedger PurchaseOrdersToUpdate)
{
using (IDbConnection conn = Connection)
{
var result = await conn.UpdateAsync <PurchaseOrderLedger>(PurchaseOrdersToUpdate);
return(result);
}
}
public async Task <List <PurchaseOrderLedger> > GetAsync(int id)
{
List <PurchaseOrderLedger> ToReturn = new List <PurchaseOrderLedger>();
try
{
PurchaseOrderLedger Res = await _PurchaseOrdersLedgerRepo.GetById(id);
ToReturn.Add(Res);
}
catch (Exception ex)
{
var logger = _loggerFactory.CreateLogger("internal_error_log");
logger.LogInformation("Problem happened in selecting the data for purchaseordersledger list by id with message" + ex.Message);
}
return(ToReturn);
}
public async Task <string> Update(int id, [FromBody] string value)
{
string UpdateResult = "Success";
bool UpdateProcessOutput = false;
try
{
PurchaseOrderLedger PurchaseOrdersToUpdate = JsonConvert.DeserializeObject <PurchaseOrderLedger>(value);
PurchaseOrdersToUpdate.transaction_id = id;
UpdateProcessOutput = await _PurchaseOrdersLedgerRepo.Update(PurchaseOrdersToUpdate);
var eventModel = new EventModel(tableName)
{
EntityId = PurchaseOrdersToUpdate.po_id,
EventName = ledger_update,
RefrenceId = id,
UserId = PurchaseOrdersToUpdate.updated_by,
EventNoteId = id
};
await _eventRepo.AddEventAsync(eventModel);
var userEvent = new EventModel(userEventTableName)
{
EntityId = PurchaseOrdersToUpdate.updated_by,
EventName = ledger_update,
RefrenceId = id,
UserId = PurchaseOrdersToUpdate.updated_by,
EventNoteId = id
};
await _eventRepo.AddEventAsync(userEvent);
}
catch (Exception ex)
{
var logger = _loggerFactory.CreateLogger("internal_error_log");
logger.LogInformation("Problem happened in updating purchaseordersledger with message" + ex.Message);
UpdateResult = "Failed";
}
if (!UpdateProcessOutput)
{
UpdateResult = "Creation failed due to reason: No specific reson";
}
return(UpdateResult);
}
public async Task <string> PostAsync([FromBody] string value)
{
string NewInsertionID = "0";
try
{
PurchaseOrderLedger newPurchaseOrder = JsonConvert.DeserializeObject <PurchaseOrderLedger>(value);
NewInsertionID = await _PurchaseOrdersLedgerRepo.Create(newPurchaseOrder);
var eventModel = new EventModel(tableName)
{
EntityId = newPurchaseOrder.po_id,
EventName = ledger_create,
RefrenceId = Int32.Parse(NewInsertionID),
UserId = newPurchaseOrder.created_by,
EventNoteId = Convert.ToInt32(NewInsertionID)
};
await _eventRepo.AddEventAsync(eventModel);
var userEvent = new EventModel(userEventTableName)
{
EntityId = newPurchaseOrder.created_by,
EventName = ledger_create,
RefrenceId = Convert.ToInt32(NewInsertionID),
UserId = newPurchaseOrder.created_by,
EventNoteId = Convert.ToInt32(NewInsertionID)
};
await _eventRepo.AddEventAsync(userEvent);
}
catch (Exception ex)
{
var logger = _loggerFactory.CreateLogger("internal_error_log");
logger.LogInformation("Problem happened in making new purchaseordersledger create with message" + ex.Message);
}
return(NewInsertionID);
}
public async Task <string> UpdateSpecific(int id, [FromBody] string value)
{
string UpdateResult = "Success";
try
{
PurchaseOrderLedger PurchaseOrdersToUpdate = JsonConvert.DeserializeObject <PurchaseOrderLedger>(value);
PurchaseOrdersToUpdate.transaction_id = id;
Dictionary <String, String> ValuesToUpdate = new Dictionary <string, string>();
if (PurchaseOrdersToUpdate.po_id != 0)
{
ValuesToUpdate.Add("po_id", PurchaseOrdersToUpdate.po_id.ToString());
}
if (PurchaseOrdersToUpdate.description != null)
{
ValuesToUpdate.Add("description", PurchaseOrdersToUpdate.description.ToString());
}
if (PurchaseOrdersToUpdate.credit != 0)
{
ValuesToUpdate.Add("credit", PurchaseOrdersToUpdate.credit.ToString());
}
if (PurchaseOrdersToUpdate.debit != 0)
{
ValuesToUpdate.Add("debit", PurchaseOrdersToUpdate.debit.ToString());
}
if (PurchaseOrdersToUpdate.created_by != 0)
{
ValuesToUpdate.Add("created_by", PurchaseOrdersToUpdate.created_by.ToString());
}
if (PurchaseOrdersToUpdate.updated_by != 0)
{
ValuesToUpdate.Add("updated_by", PurchaseOrdersToUpdate.updated_by.ToString());
}
if (PurchaseOrdersToUpdate.created_at != 0)
{
ValuesToUpdate.Add("created_at", PurchaseOrdersToUpdate.created_at.ToString());
}
if (PurchaseOrdersToUpdate.updated_at != 0)
{
ValuesToUpdate.Add("updated_at", PurchaseOrdersToUpdate.updated_at.ToString());
}
await _PurchaseOrdersLedgerRepo.UpdateSpecific(ValuesToUpdate, "transaction_id=" + id);
var eventModel = new EventModel(tableName)
{
EntityId = PurchaseOrdersToUpdate.po_id,
EventName = ledger_specificupdate,
RefrenceId = id,
UserId = PurchaseOrdersToUpdate.updated_by,
EventNoteId = id
};
await _eventRepo.AddEventAsync(eventModel);
var userEvent = new EventModel(userEventTableName)
{
EntityId = PurchaseOrdersToUpdate.updated_by,
EventName = ledger_specificupdate,
RefrenceId = id,
UserId = PurchaseOrdersToUpdate.updated_by,
EventNoteId = id
};
await _eventRepo.AddEventAsync(userEvent);
}
catch (Exception ex)
{
var logger = _loggerFactory.CreateLogger("internal_error_log");
logger.LogInformation("Problem happened in updating updatespecific purchaseordersledger with message" + ex.Message);
UpdateResult = "Failed";
}
return(UpdateResult);
}
