/*
* Developer: Sajid Khan
* Date: 7-5-19
* Action:update tracking data by id from database
* Input: tracking data
* output:Boolean
*/
public async Task <Boolean> Update(PurchaseOrdersTracking TrackingToUpdate)
{
using (IDbConnection conn = Connection)
{
var result = await conn.UpdateAsync <PurchaseOrdersTracking>(TrackingToUpdate);
return(result);
}
}
/*
* Developer: Sajid Khan
* Date: 7-5-19
* Action: Insert tracking to database
* Input: new tracking data
* output: string of tracking id
*/
public async Task <string> Create(PurchaseOrdersTracking Newtracking)
{
using (IDbConnection conn = Connection)
{
var result = await conn.InsertAsync <PurchaseOrdersTracking>(Newtracking);
return(result.ToString());
}
}
public async Task <string> Update(int id, [FromBody] string value)
{
string UpdateResult = "Success";
bool UpdateProcessOutput = false;
try
{
PurchaseOrdersTracking PurchaseOrdersTrackingToUpdate = JsonConvert.DeserializeObject <PurchaseOrdersTracking>(value);
PurchaseOrdersTrackingToUpdate.po_tracking_id = id;
UpdateProcessOutput = await _PurchaseOrdersTrackingRepo.Update(PurchaseOrdersTrackingToUpdate);
var eventModel = new EventModel(tableName)
{
EntityId = PurchaseOrdersTrackingToUpdate.po_id,
EventName = tracking_update,
RefrenceId = id,
UserId = PurchaseOrdersTrackingToUpdate.updated_by,
EventNoteId = id
};
await _eventRepo.AddEventAsync(eventModel);
var userEvent = new EventModel(userEventTableName)
{
EntityId = PurchaseOrdersTrackingToUpdate.updated_by,
EventName = tracking_update,
RefrenceId = id,
UserId = PurchaseOrdersTrackingToUpdate.updated_by,
EventNoteId = id
};
await _eventRepo.AddEventAsync(userEvent);
}
catch (Exception ex)
{
var logger = _loggerFactory.CreateLogger("internal_error_log");
logger.LogInformation("Problem happened in updating purchaseorderstracking with message" + ex.Message);
UpdateResult = "Failed";
}
if (!UpdateProcessOutput)
{
UpdateResult = "Creation failed due to reason: No specific reson";
}
return(UpdateResult);
}
public async Task <bool> Delete(int id, [FromBody] string value)
{
Boolean res = false;
try
{
using (IDbConnection conn = Connection)
{
String DeleteQuery = "Delete From purchase_order_tracking WHERE po_tracking_id =" + id.ToString();
var vendorDetails = await conn.QueryAsync <object>(DeleteQuery);
res = true;
PurchaseOrdersTracking PurchaseOrdersToUpdate = JsonConvert.DeserializeObject <PurchaseOrdersTracking>(value);
var eventModel = new EventModel(tableName)
{
EntityId = PurchaseOrdersToUpdate.po_id,
EventName = tracking_delete,
RefrenceId = id,
UserId = PurchaseOrdersToUpdate.updated_by,
EventNoteId = id
};
await _eventRepo.AddEventAsync(eventModel);
var userEvent = new EventModel(userEventTableName)
{
EntityId = PurchaseOrdersToUpdate.updated_by,
EventName = tracking_delete,
RefrenceId = id,
UserId = PurchaseOrdersToUpdate.updated_by,
EventNoteId = id
};
await _eventRepo.AddEventAsync(userEvent);
}
}
catch (Exception ex)
{
}
return(res);
}
public async Task <string> PostAsync([FromBody] string value)
{
string NewInsertionID = "0";
try
{
PurchaseOrdersTracking newPurchaseOrderTracking = JsonConvert.DeserializeObject <PurchaseOrdersTracking>(value);
NewInsertionID = await _PurchaseOrdersTrackingRepo.Create(newPurchaseOrderTracking);
var eventModel = new EventModel(tableName)
{
EntityId = newPurchaseOrderTracking.po_id,
EventName = tracking_create,
RefrenceId = Int32.Parse(NewInsertionID),
UserId = newPurchaseOrderTracking.created_by,
EventNoteId = Int32.Parse(NewInsertionID)
};
await _eventRepo.AddEventAsync(eventModel);
var userEvent = new EventModel(userEventTableName)
{
EntityId = newPurchaseOrderTracking.created_by,
EventName = tracking_create,
RefrenceId = Convert.ToInt32(NewInsertionID),
UserId = newPurchaseOrderTracking.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 new Purchase Order Tracking create with message" + ex.Message);
}
return(NewInsertionID);
}
public async Task <string> UpdateSpecific(int id, [FromBody] string value)
{
string UpdateResult = "Success";
try
{
PurchaseOrdersTracking PurchaseOrdersToUpdate = JsonConvert.DeserializeObject <PurchaseOrdersTracking>(value);
PurchaseOrdersToUpdate.po_tracking_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.tracking_number != 0)
{
ValuesToUpdate.Add("tracking_number", PurchaseOrdersToUpdate.tracking_number.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 _PurchaseOrdersTrackingRepo.UpdateSpecific(ValuesToUpdate, "po_tracking_id=" + id);
var eventModel = new EventModel(tableName)
{
EntityId = PurchaseOrdersToUpdate.po_id,
EventName = tracking_specific_update,
RefrenceId = id,
UserId = PurchaseOrdersToUpdate.updated_by,
EventNoteId = id
};
await _eventRepo.AddEventAsync(eventModel);
var userEvent = new EventModel(userEventTableName)
{
EntityId = PurchaseOrdersToUpdate.updated_by,
EventName = tracking_specific_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 new updatespecific purchaseorderstracking with message" + ex.Message);
UpdateResult = "Failed";
}
return(UpdateResult);
}
