public int SaveDocumentAssignment(DocumentAssignmentModel model)
{
var result = 0;
var tmp = ToEntity(model);
if (model.DocumentAssignmentId > 0)
{
tmp = context.DocumentAssignment.FirstOrDefault(x => x.DocumentAssignmentId == model.DocumentAssignmentId);
if (model.AssignmentStatus == "Cerrado")
{
tmp.AssignmentStatus = model.AssignmentStatus;
}
else
{
tmp.AssignmentStatus = model.AssignmentStatus;
tmp.DueToDate = model.DueToDate;
tmp.FirstReminderDays = model.FirstReminderDays;
tmp.SecondReminderDays = model.SecondReminderDays;
}
}
else
{
context.DocumentAssignment.Add(tmp);
}
context.SaveChanges();
result = tmp.DocumentAssignmentId;
return(result);
}
public DocumentAssignmentModel GetDocumentAssignmentById(int id)
{
var tmp = context.DocumentAssignment.FirstOrDefault(x => x.DocumentAssignmentId == id);
var result = new DocumentAssignmentModel();
if (tmp != null)
{
result = ToModel(tmp);
}
return(result);
}
public DocumentAssignmentModel GetDocumentAssignmentByLocation(string siteUrl, string docLibraryId, int itemId, string status)
{
var tmp = context.DocumentAssignment.Where(x => x.SiteUrl == siteUrl && x.DocumentLibraryId == docLibraryId && x.ListItemId == itemId && (string.IsNullOrEmpty(status) || x.AssignmentStatus == status)).OrderByDescending(x => x.AssignmentDate);
var result = new DocumentAssignmentModel();
if (tmp != null)
{
if (tmp.Count() > 0)
{
result = ToModel(tmp.First());
}
}
return(result);
}
public IHttpActionResult PostDocAssignment(DocumentAssignmentModel document)
{
var result = new PostEntityModelResponse();
try
{
result.ItemId = helper.SaveDocumentAssignment(document);
if (result.ItemId <= 0)
{
result.Message = "No records were saved.";
}
}
catch (Exception ex)
{
result.Message = "An error occured while saving your information.";
}
return(Ok(result));
}
public async Task <string> PostDocumentAssignment(DocumentAssignmentModel document)
{
var result = 0;
string actionEndpoint = "docassignment/DocAssignment";
PostEntityModelResponse serviceResult = new PostEntityModelResponse();
using (var client = new HttpClient())
{
using (var request = new HttpRequestMessage(HttpMethod.Get, baseEndpoint + actionEndpoint))
{
request.Headers.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
using (HttpResponseMessage response = await client.PostAsJsonAsync(request.RequestUri, document))
{
if (response.StatusCode == HttpStatusCode.OK)
{
serviceResult = JsonConvert.DeserializeObject <PostEntityModelResponse>(response.Content.ReadAsStringAsync().Result);
result = serviceResult.ItemId;
}
}
}
}
return(JsonConvert.SerializeObject(result));
}
public async Task <string> GetDocumentAssignment(DocumentAssignmentModel document)
{
string actionEndpoint = "docassignment/DocumentAssignment";
string queryParameter = string.Format("?DocumentAssignmentId={0}&SiteUrl={1}&DocumentLibraryId={2}&ListItemId={3}&DocumentStatus={4}", document.DocumentAssignmentId, document.SiteUrl, document.DocumentLibraryId, document.ListItemId, document.AssignmentStatus);
GetDocumentAssignmentResponse serviceResult = new GetDocumentAssignmentResponse();
DocumentAssignmentModel result = new DocumentAssignmentModel();
using (var client = new HttpClient())
{
using (var request = new HttpRequestMessage(HttpMethod.Get, baseEndpoint + actionEndpoint + queryParameter))
{
request.Headers.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
using (HttpResponseMessage response = await client.SendAsync(request))
{
if (response.StatusCode == HttpStatusCode.OK)
{
serviceResult = JsonConvert.DeserializeObject <GetDocumentAssignmentResponse>(response.Content.ReadAsStringAsync().Result);
result = serviceResult.Model;
}
}
}
}
return(JsonConvert.SerializeObject(result));
}
private DocumentAssignmentModel ToModel(DocumentAssignment doc)
{
var result = new DocumentAssignmentModel();
result.AssignedByLogin = doc.AssignedByLogin;
result.AssignedByName = doc.AssignedByName;
result.AssignedToControl = doc.AssignedToControl;
result.AssignedToLogin = doc.AssignedToLogin;
result.AssignedToName = doc.AssignedToName;
result.AssignmentDate = doc.AssignmentDate.HasValue? doc.AssignmentDate.Value : DateTime.MinValue;
result.AssignmentStatus = doc.AssignmentStatus;
result.DocumentAssignmentId = doc.DocumentAssignmentId;
result.DocumentLibraryId = doc.DocumentLibraryId;
result.DocumentTitle = doc.DocumentTitle;
result.DocumentUrl = doc.DocumentUrl;
result.DueToDate = doc.DueToDate.HasValue? doc.DueToDate.Value:DateTime.MinValue;
result.FirstReminderDays = doc.FirstReminderDays.HasValue ? doc.FirstReminderDays.Value : 0;
result.ListItemId = doc.ListItemId.HasValue ? doc.ListItemId.Value : 0;
result.SecondReminderDays = doc.SecondReminderDays.HasValue ? doc.SecondReminderDays.Value : 0;
result.SiteUrl = doc.SiteUrl;
result.DocumentAnnotations = doc.DocumentAnnotations;
result.DocumentSubject = doc.DocumentSubject;
return(result);
}
private DocumentAssignment ToEntity(DocumentAssignmentModel doc)
{
var result = new DocumentAssignment();
result.AssignedByLogin = doc.AssignedByLogin;
result.AssignedByName = doc.AssignedByName;
result.AssignedToControl = doc.AssignedToControl;
result.AssignedToLogin = doc.AssignedToLogin;
result.AssignedToName = doc.AssignedToName;
result.AssignmentDate = doc.AssignmentDate;
result.AssignmentStatus = doc.AssignmentStatus;
result.DocumentAssignmentId = doc.DocumentAssignmentId;
result.DocumentLibraryId = doc.DocumentLibraryId;
result.DocumentTitle = doc.DocumentTitle;
result.DocumentUrl = doc.DocumentUrl;
result.DueToDate = doc.DueToDate;
result.FirstReminderDays = doc.FirstReminderDays;
result.ListItemId = doc.ListItemId;
result.SecondReminderDays = doc.SecondReminderDays;
result.SiteUrl = doc.SiteUrl;
result.DocumentAnnotations = doc.DocumentAnnotations;
result.DocumentSubject = doc.DocumentSubject;
return(result);
}
public AssignDocumentViewModel()
{
DBModel = new DocumentAssignmentModel();
}
