/*
* Developer: Sajid Khan
* Date: 7-5-19
* Action: Insert purchase order discount data to database
* Input: new Purchase Orders discount data
* output: string of PurchaseOrders discount id
*/
public async Task <string> Create(PurchaseOrderDiscounts NewPurchaseOrder)
{
using (IDbConnection conn = Connection)
{
var result = await conn.InsertAsync <PurchaseOrderDiscounts>(NewPurchaseOrder);
return(result.ToString());
}
}
/*
* Developer: Sajid Khan
* Date: 7-5-19
* Action: update purchase order discount data by id from database
* Input: purchase order discount data
* output: Boolean
*/
public async Task <Boolean> Update(PurchaseOrderDiscounts PurchaseOrdersToUpdate)
{
using (IDbConnection conn = Connection)
{
var result = await conn.UpdateAsync <PurchaseOrderDiscounts>(PurchaseOrdersToUpdate);
return(result);
}
}
public async Task <List <PurchaseOrderDiscounts> > GetAsync(int id)
{
List <PurchaseOrderDiscounts> ToReturn = new List <PurchaseOrderDiscounts>();
try
{
PurchaseOrderDiscounts Res = await _PurchaseOrdersDiscountsRepo.GetById(id);
ToReturn.Add(Res);
}
catch (Exception ex)
{
var logger = _loggerFactory.CreateLogger("internal_error_log");
logger.LogInformation("Problem happened in selecting the data for purchaseordersdiscounts 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
{
PurchaseOrderDiscounts PurchaseOrdersToUpdate = JsonConvert.DeserializeObject <PurchaseOrderDiscounts>(value);
PurchaseOrdersToUpdate.po_discount_id = id;
UpdateProcessOutput = await _PurchaseOrdersDiscountsRepo.Update(PurchaseOrdersToUpdate);
var eventModel = new EventModel(tableName)
{
EntityId = PurchaseOrdersToUpdate.po_id,
EventName = discount_update,
RefrenceId = id,
UserId = PurchaseOrdersToUpdate.updated_by,
EventNoteId = id
};
await _eventRepo.AddEventAsync(eventModel);
var userEvent = new EventModel(userEventTableName)
{
EntityId = PurchaseOrdersToUpdate.updated_by,
EventName = discount_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 purchaseordersdiscounts 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
{
PurchaseOrderDiscounts newPurchaseOrder = JsonConvert.DeserializeObject <PurchaseOrderDiscounts>(value);
NewInsertionID = await _PurchaseOrdersDiscountsRepo.Create(newPurchaseOrder);
var eventModel = new EventModel(tableName)
{
EntityId = newPurchaseOrder.po_id,
EventName = discount_create,
RefrenceId = Int32.Parse(NewInsertionID),
UserId = newPurchaseOrder.created_by,
EventNoteId = Int32.Parse(NewInsertionID)
};
await _eventRepo.AddEventAsync(eventModel);
var userEvent = new EventModel(userEventTableName)
{
EntityId = newPurchaseOrder.created_by,
EventName = discount_create,
RefrenceId = Convert.ToInt32(NewInsertionID),
UserId = newPurchaseOrder.created_by,
EventNoteId = Int32.Parse(NewInsertionID)
};
await _eventRepo.AddEventAsync(userEvent);
}
catch (Exception ex)
{
var logger = _loggerFactory.CreateLogger("internal_error_log");
logger.LogInformation("Problem happened in making new purchaseordersdiscounts create with message" + ex.Message);
}
return(NewInsertionID);
}
public async Task <string> UpdateSpecific(int id, [FromBody] string value)
{
string UpdateResult = "Success";
try
{
PurchaseOrderDiscounts PurchaseOrdersToUpdate = JsonConvert.DeserializeObject <PurchaseOrderDiscounts>(value);
PurchaseOrdersToUpdate.po_discount_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.discount_percentage != 0)
{
ValuesToUpdate.Add("discount_percentage", PurchaseOrdersToUpdate.discount_percentage.ToString());
}
if (PurchaseOrdersToUpdate.discount_note != null)
{
ValuesToUpdate.Add("discount_note", PurchaseOrdersToUpdate.discount_note.ToString());
}
if (PurchaseOrdersToUpdate.completed_status != 0)
{
ValuesToUpdate.Add("completed_status", PurchaseOrdersToUpdate.completed_status.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 _PurchaseOrdersDiscountsRepo.UpdateSpecific(ValuesToUpdate, "po_discount_id=" + id);
var eventModel = new EventModel(tableName)
{
EntityId = PurchaseOrdersToUpdate.po_id,
EventName = discount_specificupdate,
RefrenceId = id,
UserId = PurchaseOrdersToUpdate.updated_by,
EventNoteId = id
};
await _eventRepo.AddEventAsync(eventModel);
var userEvent = new EventModel(userEventTableName)
{
EntityId = PurchaseOrdersToUpdate.updated_by,
EventName = discount_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 purchaseordersdiscounts with message" + ex.Message);
UpdateResult = "Failed";
}
return(UpdateResult);
}
