public ActionResult Create(WorkRequestModel workRequest)
{
HttpCookie userCookie = HttpContext.Request.Cookies["UserCookie"] as HttpCookie;
workRequest.OwnerName = userCookie["UserName"];
workRequest.CreatedDate = DateTime.Now;
_WorkRequestRepository.SaveWorkRequest(workRequest);
return(View("~/Views/WorkRequest/AllWorkRequests.cshtml", _WorkRequestRepository.GetAllWorkRequests()));
}
public int Save(WorkRequestModel model)
{
var resData = model.GetWorkData();
var workRes = new Work()
{
Id = resData.Id,
Title = resData.Title,
SourceTitle = resData.SourceTitle,
WorkTypeId = resData.WorkType.Id,
ReleaseYear = resData.ReleaseYear,
Doi = resData.Doi,
Issn = resData.Issn,
Essn = resData.Essn,
Isbn = resData.Isbn,
PublishedMonRK = resData.PublishedMonRK,
AuthorId = resData.Author.Id
};
Db.Works.InsertOrUpdate(workRes);
Db.Complete();
try
{
if (resData.CoAuthors != null && resData.CoAuthors.Count() > 0)
{
var coAuth = Db.Works.GetCoAuthorsByWorkId(workRes.Id);
var coAuthDel = coAuth.Where(ca => !resData.CoAuthors.Select(ca => ca.EmployeeId).Contains(ca.EmployeeId));
var coAuthIns = resData.CoAuthors.Where(ca => !coAuth.Select(a => a.EmployeeId).Contains(ca.EmployeeId));
Db.WorkCoAuthors.RemoveRange(coAuthDel);
var coAuthRes = coAuthIns.Select(ca => new WorkCoAuthor()
{
EmployeeId = ca.EmployeeId,
FromSU = ca.FromSU,
WorkId = workRes.Id
});
Db.WorkCoAuthors.InsertOrUpdateRange(coAuthRes);
Db.Complete();
}
}
catch (Exception e)
{
Db.Dispose();
throw new Exception(e.Message);
}
return(workRes.Id);
}
public virtual ActionResult WorkRequestView()
{
PrismaServiceClient client = new PrismaServiceClient();
RequestMessageGetWorkRequest request = new RequestMessageGetWorkRequest();
request.Username = Environment.UserName;
var response = client.GetWorkRequest(request);
WorkRequest[] arr = response.WorkRequestList;
WorkRequestModel model = new WorkRequestModel();
model.WorkRequestList = new List <WorkRequest>(arr);
return(View(model));
}
public List <WorkRequestModel> GetAllWorkRequests()
{
List <WorkRequestModel> workRequests = new List <WorkRequestModel>();
_WorkRequestConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionStringName"].ConnectionString);
using (_WorkRequestConnection)
{
SqlCommand command = new SqlCommand(_GetAllWorkRequests, _WorkRequestConnection);
try
{
_WorkRequestConnection.Close();
_WorkRequestConnection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
var workRequest = new WorkRequestModel
{
Id = Convert.ToInt32(reader[0].ToString()),
OwnerName = reader[1].ToString(),
Description = reader[2].ToString(),
Status = reader[3].ToString(),
CreatedDate = Convert.ToDateTime(reader[4].ToString()),
};
workRequests.Add(workRequest);
}
}
catch (SqlException e)
{
Console.Out.Write($"SQL Exception {e.Message}");
return(workRequests);
}
finally
{
_WorkRequestConnection.Close();
}
}
return(workRequests);
}
public void SaveWorkRequest(WorkRequestModel workRequest)
{
SqlCommand command;
_WorkRequestConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionStringName"].ConnectionString);
using (_WorkRequestConnection)
{
if ((workRequest.Id != 0))
{
command = new SqlCommand(_UpdateWorkRequest, _WorkRequestConnection);
command.Parameters.AddWithValue("@Status", workRequest.Status);
command.Parameters.AddWithValue("@Description", workRequest.Description);
}
else
{
command = new SqlCommand(_SaveWorkRequest, _WorkRequestConnection);
command.Parameters.AddWithValue("@OwnerName", workRequest.OwnerName);
command.Parameters.AddWithValue("@Status", workRequest.Status);
command.Parameters.AddWithValue("@Description", workRequest.Description);
command.Parameters.AddWithValue("@CreatedDate", DateTime.Now);
}
try
{
_WorkRequestConnection.Open();
var reader = command.ExecuteReader();
}
catch (SqlException e)
{
Console.Out.Write($"SQL Exception {e.Message}");
return;
}
finally
{
_WorkRequestConnection.Close();
}
}
return;
}
public WorkRequestModel GetWorkRequest(int id)
{
WorkRequestModel workRequest = new WorkRequestModel();
_WorkRequestConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionStringName"].ConnectionString);
using (_WorkRequestConnection)
{
SqlCommand command = new SqlCommand(_FindWorkRequestQuery, _WorkRequestConnection);
command.Parameters.AddWithValue("@Id", id);
try
{
_WorkRequestConnection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
workRequest.Id = Convert.ToInt32(reader[0].ToString());
workRequest.OwnerName = reader[1].ToString();
workRequest.Description = reader[2].ToString();
workRequest.Status = reader[3].ToString();
workRequest.CreatedDate = Convert.ToDateTime(reader[4].ToString());
}
}
catch (SqlException e)
{
Console.Out.Write($"SQL Exception {e.Message}");
return(workRequest);
}
finally
{
_WorkRequestConnection.Close();
}
}
return(workRequest);
}
public IActionResult Save([FromForm] WorkRequestModel model)
{
var res = _workService.Save(model);
return(Ok(res));
}
public ActionResult Save(WorkRequestModel workRequest)
{
_WorkRequestRepository.SaveWorkRequest(workRequest);
return(View("~/Views/WorkRequest/AllWorkRequests.cshtml", _WorkRequestRepository.GetAllWorkRequests()));
}