/// <summary>
/// Issueデータの設定
/// </summary>
/// <param name="target">設定値</param>
/// <returns>設定の成功/失敗</returns>
public bool SetIssues(IssuesEntity target)
{
issues = target;
saveIssueFile();
return(true);
}
/// <summary>
/// 最新Issueをネットワークから取得する
/// </summary>
/// <returns>最新Issueリスト</returns>
public IssuesEntity GetLatestIssues()
{
var json = string.Empty;
using (var client = new HttpClient())
{
var response = client.GetAsync(uri).Result.Content.ReadAsStringAsync();
json = response.Result;
}
var result = JsonSerializer.Deserialize <List <JsonIssue> >(json);
return(IssuesEntity.Create(result.Select(item => item.ToDomainEntity()).ToList()));
}
/// <summary>
/// IssueデータJsonファイルの読み取り
/// </summary>
private void loadIssueFile()
{
var JSONFilePath = Path.Combine(baseDirectory, JSONFileName);
// ファイルがない場合は終了
if (!File.Exists(JSONFilePath))
{
return;
}
var json = string.Empty;
using (var sr = new StreamReader(JSONFilePath))
{
json = sr.ReadToEnd();
}
var jsonIssues = JsonSerializer.Deserialize <List <JsonIssue> >(json);
issues = IssuesEntity.Create(jsonIssues.Select(item => item.ToDomainEntity()).ToList());
}
public ActionResult UploadExcel(HttpPostedFileBase FileUpload)
{
ServiceProviderHelper serviceProviderHelper = new ServiceProviderHelper();
string viewName = "";
try
{
if (FileUpload != null)
{
if (FileUpload.ContentType == "application/vnd.ms-excel" || FileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
string filename = Path.GetFileName(FileUpload.FileName);
if (filename.EndsWith(".xlsx") || filename.EndsWith(".xls"))
{
string targetpath = Server.MapPath("~/UploadExcel/");
FileUpload.SaveAs(targetpath + filename);
string pathToExcelFile = targetpath + filename;
var excelFile = new ExcelQueryFactory(pathToExcelFile);//
var providerList = from provider in excelFile.Worksheet <ServiceProviderEntity>("ProviderList") select provider;
var issueList = from issue in excelFile.Worksheet <IssuesEntity>("IssueList") select issue;
//ValidateExcelFile();
List <ServiceProviderEntity> serviceProviderEntityList = new List <ServiceProviderEntity>();
foreach (var provider in providerList)
{
if (provider.Name != null)
{
ServiceProviderEntity serviceProviderEntity = new ServiceProviderEntity();
serviceProviderEntity.VendorCode = provider.VendorCode;
serviceProviderEntity.Name = provider.Name;
serviceProviderEntity.Status = provider.Status;
serviceProviderEntity.GoLiveDate = provider.GoLiveDate;
serviceProviderEntity.ProjectManager = provider.ProjectManager;
serviceProviderEntity.Phase = provider.Phase;
serviceProviderEntity.Fees = provider.Fees;
serviceProviderEntity.Type = provider.Type;
serviceProviderEntity.Update = provider.Update;
//serviceProviderEntity.IssuesList = issueList == null ? null : new List<IssuesEntity>() { new IssuesEntity() { Item = issueList.Where(x => x.ServiceProviderCode == provider.ServiceProviderCode).Select(y => y.Item).FirstOrDefault(), Issue = issueList.Where(x => x.ServiceProviderCode == provider.ServiceProviderCode).Select(y => y.Issue).FirstOrDefault(), Owner = issueList.Where(x => x.ServiceProviderCode == provider.ServiceProviderCode).Select(y => y.Owner).FirstOrDefault() } };
List <IssuesEntity> IssuesEntityList = new List <IssuesEntity>();
foreach (var issue in issueList.Where(i => i.VendorCode == provider.VendorCode))
{
if (issue.Issue != null)
{
IssuesEntity issuesEntity = new IssuesEntity();
issuesEntity.VendorCode = issue.VendorCode;
issuesEntity.Item = issue.Item;
issuesEntity.Issue = issue.Issue;
issuesEntity.Owner = issue.Owner;
IssuesEntityList.Add(issuesEntity);
}
}
if (IssuesEntityList.Count > 0)
{
serviceProviderEntity.IssuesList = IssuesEntityList;
}
serviceProviderEntityList.Add(serviceProviderEntity);
}
}
if (serviceProviderEntityList.Count > 0)
{
serviceProviderHelper.AddProvider(serviceProviderEntityList);
EmailSetting emailSetting = new EmailSetting();
string Body = System.IO.File.ReadAllText(System.Web.Hosting.HostingEnvironment.MapPath("~/EmailTemplates/ExcelUploadMail.html"));
bool isMailSend = emailSetting.SendMail(Convert.ToString(Session["EmailID"]), "", "Provider Details Upload Notification", Body.Replace("currDate", DateTime.Now.ToString("MMMM dd, yyyy")));
viewName = "uploadconfirmation";
}
}
else
{
TempData["Message"] = "Only Excel file format is allowed";
viewName = "AdminDashboard";
}
}
else
{
TempData["Message"] = "Only Excel file format is allowed";
viewName = "AdminDashboard";
}
}
else
{
TempData["Message"] = "Please select file.";
viewName = "AdminDashboard";
}
}
catch (Exception ex) { TempData["Message"] = "some issue occured. please try again"; viewName = "AdminDashboard"; }
return(RedirectToAction(viewName));
}
public bool SetIssues(IssuesEntity target)
{
issues = target;
return(true);
}
public IssuesEntity GetLatestIssues()
{
var result = JsonSerializer.Deserialize <List <JsonIssue> >(JsonText);
return(IssuesEntity.Create(result.Select(item => item.ToDomainEntity()).ToList()));
}
