)>}]
شركة التطبيقات المتكاملة لتصميم وبرمجة البرمجيات الخاصة ش.ش.و.
Integrated Applications Programming Company
Home » Code Library » Report (Ia.Dn.Wa.Models.Maintenance)

Public general use code classes and xml files that we've compiled and used over the years:

    1: using Microsoft.AspNetCore.Mvc.Rendering;
    2: using Microsoft.Identity.Client;
    3: using System.Data;
    4: using System.Net;
    5: using System.Text.RegularExpressions;
    6:  
    7: namespace Ia.Dn.Wa.Models.Maintenance
    8: {
    9:     ////////////////////////////////////////////////////////////////////////////
   10:  
   11:     /// <summary publish="true">
   12:     ///
   13:     /// </summary>
   14:     /// 
   15:     /// <remarks> 
   16:     /// Copyright © 2006-2025 Jasem Y. Al-Shamlan (info@ia.com.kw), Integrated Applications - Kuwait. All Rights Reserved.
   17:     /// </remarks> 
   18:     public static class Report
   19:     {
   20:         ////////////////////////////////////////////////////////////////////////////
   21:  
   22:         /// <summary>
   23:         ///
   24:         /// </summary>
   25:         public static void ViewModel(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel)
   26:         {
   27:             if (!string.IsNullOrEmpty(reportViewModel.FrameworkSelectedValue))
   28:             {
   29:                 ReportListAndFrameworkSelectList_ViewModel(ref reportViewModel, reportViewModel.FrameworkSelectedValue);
   30:             }
   31:             else if (reportViewModel.CurrentStaffIdentityUser.Framework != null) ReportListAndFrameworkSelectList_ViewModel(ref reportViewModel, reportViewModel.CurrentStaffIdentityUser.Framework.Id);
   32:             else
   33:             {
   34:             }
   35:  
   36:             //Telegram_ViewModel();
   37:  
   38:             reportViewModel.TelegramChatPanelVisible = false;
   39:         }
   40:  
   41:         ////////////////////////////////////////////////////////////////////////////
   42:  
   43:         /// <summary>
   44:         ///
   45:         /// </summary>
   46:         public static void Post(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel, string commandName, string _reportId)
   47:         {
   48:             if (!string.IsNullOrEmpty(commandName) && !string.IsNullOrEmpty(_reportId))
   49:             {
   50:                 if (commandName == "delete")
   51:                 {
   52:                     Ia.Dn.Wa.Models.Maintenance.Report.DeleteReport(ref reportViewModel, _reportId);
   53:                 }
   54:             }
   55:         }
   56:  
   57:         ////////////////////////////////////////////////////////////////////////////
   58:  
   59:         /// <summary>
   60:         ///
   61:         /// </summary>
   62:         public static void DeleteReport(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel, string _reportId)
   63:         {
   64:             reportViewModel.UpdateResult = new Ia.Cl.Models.Result();
   65:  
   66:             var reportId = int.Parse(_reportId);
   67:  
   68:             var report = Ia.Dn.Cl.Models.Data.Report.Read(reportId); // refresh report
   69:  
   70:             if (report != null)
   71:             {
   72:                 if (Ia.Dn.Cl.Models.Business.Authority.StaffCanCreateReadUpdateDeleteReport(Ia.Dn.Cl.Models.Business.Authority.PersistentStorageFunction.Delete, report, reportViewModel.CurrentStaffIdentityUser))
   73:                 {
   74:                     var b = Ia.Dn.Cl.Models.Data.Report.Delete(reportId);
   75:  
   76:                     if (b)
   77:                     {
   78:                         reportViewModel.UpdateResult.AddSuccess("Report successfully deleted (مسح التقرير بنجاح)");
   79:                     }
   80:                     else throw new Exception("") { };
   81:                 }
   82:                 else
   83:                 {
   84:                     reportViewModel.UpdateResult.AddError("You are not authorized to modify this report (لست مخولاً بتعديل هذا التقرير)");
   85:                 }
   86:             }
   87:             else
   88:             {
   89:                 reportViewModel.UpdateResult.AddError("Report " + reportId + " does not exist (التقرير غير موجود).");
   90:             }
   91:         }
   92:  
   93:         ////////////////////////////////////////////////////////////////////////////
   94:  
   95:         /// <summary>
   96:         ///
   97:         /// </summary>
   98:         private static void ReportListAndFrameworkSelectList_ViewModel(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel, string frameworkId)
   99:         {
  100:             bool has;
  101:  
  102:             has = Ia.Dn.Cl.Models.Business.Report.FrameworkHasReadabilityReport(frameworkId);
  103:  
  104:             if (has)
  105:             {
  106:                 var list = Ia.Dn.Cl.Models.Data.Report.ReportReadabilityByFrameworkIdDictionary();
  107:  
  108:                 var reportIdList = list.ContainsKey(frameworkId) ? list[frameworkId] : new List<int>();
  109:  
  110:                 reportViewModel.ReportList = Ia.Dn.Cl.Models.Data.Report.OpenStatusOrClosedStatusWithinLast24HourByReportIdReportList(reportIdList);
  111:  
  112:                 reportViewModel.StatisticLabel = reportViewModel.ReportList.Count.ToString();
  113:             }
  114:             else reportViewModel.StatisticLabel = string.Empty;
  115:  
  116:             FrameworkSelectList_ViewModel(ref reportViewModel, frameworkId);
  117:         }
  118:  
  119:         ////////////////////////////////////////////////////////////////////////////
  120:  
  121:         /// <summary>
  122:         ///
  123:         /// </summary>
  124:         private static void FrameworkSelectList_ViewModel(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel, string frameworkId)
  125:         {
  126:             var list = Ia.Dn.Cl.Models.Data.Report.ReportReadabilityByFrameworkList().OrderBy(f => f.FullyQualifiedArabicName);
  127:  
  128:             var list1 = new List<SelectListItem>();
  129:             //list1.Add(new SelectListItem(" ", "0"));
  130:  
  131:             foreach (var l in list) list1.Add(new SelectListItem(l.FullyQualifiedArabicName, l.Id));
  132:  
  133:             reportViewModel.FrameworkSelectList = new SelectList(list1, "Value", "Text");
  134:  
  135:             if (string.IsNullOrEmpty(frameworkId)) reportViewModel.FrameworkSelectedValue = "0";
  136:             else reportViewModel.FrameworkSelectedValue = frameworkId;
  137:         }
  138:  
  139:         ////////////////////////////////////////////////////////////////////////////
  140:  
  141:         /// <summary>
  142:         ///
  143:         /// </summary>
  144:         private static void Telegram_ViewModel(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel)
  145:         {
  146:             Ia.Cl.Models.QrCode qrCode;
  147:  
  148:             var currentStaffIdentityUser = reportViewModel.CurrentStaffIdentityUser;
  149:  
  150:             //if (Ia.Dn.Cl.Models.Business.Authority.StaffIsSuperUser(staff))
  151:             //{
  152:             var chat = (from c in Ia.Dn.Cl.Models.Telegram.Chat.ChatList
  153:                         where c.Framework != null && (c.Framework == currentStaffIdentityUser.Framework || currentStaffIdentityUser.Framework.Parent != null && c.Framework == currentStaffIdentityUser.Framework.Parent)
  154:                         select c).FirstOrDefault();
  155:  
  156:             if (chat != null)
  157:             {
  158:                 reportViewModel.TelegramGroupInviteQrCodeText = chat.Name;
  159:                 reportViewModel.TelegramGroupInviteQrCodeNavigateUrl = chat.TelegramGroupUrl;
  160:                 reportViewModel.TelegramGroupInviteQrCodeImageUrl = chat.LogoImageUrl;
  161:  
  162:                 qrCode = new Ia.Cl.Models.QrCode(chat.InviteLinkUrl, "SlateGray", "White", chat.LogoImageAbsolutePathUrl);
  163:  
  164:                 //telegramGroupInviteQrCodeImage.AlternateText = chat.Name;
  165:                 reportViewModel.TelegramGroupInviteQrCodeImageUrl = qrCode.ImageUrlDataFormat;
  166:  
  167:                 reportViewModel.TelegramChatPanelVisible = true;
  168:             }
  169:             else reportViewModel.TelegramChatPanelVisible = false;
  170:             //}
  171:             //else reportViewModel.TelegramChatPanelVisible = false;
  172:         }
  173:  
  174:         ////////////////////////////////////////////////////////////////////////////
  175:         ////////////////////////////////////////////////////////////////////////////
  176:  
  177:  
  178:  
  179:  
  180:  
  181:  
  182:  
  183:  
  184:  
  185:  
  186:  
  187:         ////////////////////////////////////////////////////////////////////////////
  188:         ////////////////////////////////////////////////////////////////////////////
  189:  
  190:         /// <summary>
  191:         ///
  192:         /// </summary>
  193:         public static void HistoryViewModel(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel, string _reportyId)
  194:         {
  195:             bool otherReportsExist;
  196:             List<Ia.Dn.Cl.Models.Report> reportList;
  197:  
  198:             reportViewModel.InformationResult = new Ia.Cl.Models.Result();
  199:  
  200:             var reportId = int.Parse(_reportyId);
  201:  
  202:             var report = Ia.Dn.Cl.Models.Data.Report.Read(reportId);
  203:  
  204:             if (report != null)
  205:             {
  206:                 // below: search for all available reports for this dn and display them as link
  207:                 reportList = Ia.Dn.Cl.Models.Data.Report.ListByReportId(reportId);
  208:  
  209:                 otherReportsExist = false;
  210:  
  211:                 reportViewModel.ReportLabel = string.Empty;
  212:  
  213:                 foreach (var report0 in reportList)
  214:                 {
  215:                     // below: we will check if there are open reports
  216:  
  217:                     reportViewModel.ReportLabel += "<a href=\"" + "history?reportId=" + report0.Id + "\">" + report0.Created.ToString("yyyy-MM-dd") + "</a> ";
  218:                     otherReportsExist = true;
  219:                 }
  220:  
  221:                 if (!otherReportsExist) reportViewModel.ReportLabel = "None (لا يوجد)";
  222:             }
  223:             else
  224:             {
  225:                 if (reportViewModel.ReportId > -1)
  226:                 {
  227:                     reportId = reportViewModel.ReportId;
  228:  
  229:                     report = Ia.Dn.Cl.Models.Data.Report.Read(reportId);
  230:                 }
  231:                 else reportViewModel.InformationResult.AddWarning("Report " + reportId + " does not exist (التقرير غير موجود)");
  232:             }
  233:  
  234:             // below: if the report status is closed we will hide the disable panel
  235:             if (report.StatusIsOpen)
  236:             {
  237:                 reportViewModel.ReportStatusIsOpen = true;
  238:                 reportViewModel.InsertButtonEnabled = true;
  239:                 reportViewModel.ReopenClosedReportButtonEnabled = false;
  240:  
  241:                 if (Ia.Dn.Cl.Models.Business.Authority.StaffCanCloseReport(report, reportViewModel.CurrentStaffIdentityUser)) reportViewModel.CloseReportCheckBoxEnabled = true;
  242:                 else reportViewModel.CloseReportCheckBoxEnabled = false;
  243:             }
  244:             else
  245:             {
  246:                 reportViewModel.ReportStatusIsOpen = false;
  247:                 reportViewModel.InsertButtonEnabled = false;
  248:  
  249:                 if (Ia.Dn.Cl.Models.Business.Authority.StaffCanReopenClosedReport(report, reportViewModel.CurrentStaffIdentityUser)) reportViewModel.ReopenClosedReportButtonEnabled = true;
  250:                 else reportViewModel.ReopenClosedReportButtonEnabled = false;
  251:  
  252:                 reportViewModel.InformationResult.AddWarning("Report is Closed (التقرير مغلق)");
  253:             }
  254:  
  255:             StaffFrameworkAssignmentSelectList_ViewModel(ref reportViewModel, report);
  256:  
  257:             IndicationSelectList_ViewModel(ref reportViewModel, report);
  258:             ActionSelectList_ViewModel(ref reportViewModel, report);
  259:             ResolutionSelectList_ViewModel(ref reportViewModel);
  260:             EstimateSelectList_ViewModel(ref reportViewModel);
  261:  
  262:             ReportSelectList_ViewModel(ref reportViewModel);
  263:             ReportHistorySelectList_ViewModel(ref reportViewModel, report);
  264:         }
  265:  
  266:         ////////////////////////////////////////////////////////////////////////////
  267:  
  268:         /// <summary>
  269:         ///
  270:         /// </summary>
  271:         public static void HistoryPost(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel, string commandName, string reportHistoryId)
  272:         {
  273:             if (!string.IsNullOrEmpty(commandName))
  274:             {
  275:                 if (commandName == "delete")
  276:                 {
  277:                     if (!string.IsNullOrEmpty(reportHistoryId))
  278:                     {
  279:                         Ia.Dn.Wa.Models.Maintenance.Report.DeleteHistoryReport(ref reportViewModel, reportHistoryId);
  280:                     }
  281:                     else
  282:                     {
  283:                     }
  284:                 }
  285:                 else if (commandName == "insert")
  286:                 {
  287:                     if (reportViewModel.ReportId > -1)
  288:                     {
  289:                         InsertReportHistory(ref reportViewModel);
  290:                     }
  291:                     else
  292:                     {
  293:                     }
  294:                 }
  295:                 else if (commandName == "reopenClosedReport")
  296:                 {
  297:                     if (reportViewModel.ReportId > -1)
  298:                     {
  299:                         ReopenClosedReport(ref reportViewModel);
  300:                     }
  301:                     else
  302:                     {
  303:                     }
  304:                 }
  305:                 else
  306:                 {
  307:                 }
  308:             }
  309:         }
  310:  
  311:         ////////////////////////////////////////////////////////////////////////////
  312:  
  313:         /// <summary>
  314:         ///
  315:         /// </summary>
  316:         public static void DeleteHistoryReport(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel, string _reportHistoryId)
  317:         {
  318:             reportViewModel.UpdateResult = new Ia.Cl.Models.Result();
  319:  
  320:             var reportHistoryId = int.Parse(_reportHistoryId);
  321:  
  322:             var report = Ia.Dn.Cl.Models.Data.Report.Read(reportViewModel.ReportId);
  323:             var reportHistory = Ia.Dn.Cl.Models.Data.ReportHistory.Read(reportHistoryId);
  324:  
  325:             if (reportHistory != null)
  326:             {
  327:                 if (Ia.Dn.Cl.Models.Business.Authority.StaffCanCreateReadUpdateDeleteReportHistory(Ia.Dn.Cl.Models.Business.Authority.PersistentStorageFunction.Delete, report, reportHistory, reportViewModel.CurrentStaffIdentityUser))
  328:                 {
  329:                     var b = Ia.Dn.Cl.Models.Data.ReportHistory.Delete(reportHistoryId);
  330:  
  331:                     if (b)
  332:                     {
  333:                         reportViewModel.UpdateResult.AddSuccess("Report history successfully deleted (مسح التقرير بنجاح)");
  334:                     }
  335:                     else throw new Exception("") { };
  336:                 }
  337:                 else
  338:                 {
  339:                     reportViewModel.InsertButtonEnabled = false;
  340:  
  341:                     reportViewModel.UpdateResult.AddError("You are not authorized to modify this report history (لست مخولاً بتعديل هذا التقرير)");
  342:                 }
  343:             }
  344:             else
  345:             {
  346:                 reportViewModel.UpdateResult.AddError("Report history " + reportHistoryId + " does not exist (التقرير غير موجود).");
  347:             }
  348:         }
  349:  
  350:         ////////////////////////////////////////////////////////////////////////////
  351:  
  352:         /// <summary>
  353:         ///
  354:         /// </summary>
  355:         private static void InsertReportHistory(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel)
  356:         {
  357:             bool reportInserted, reportClosed, complainantNotified;
  358:             int area;
  359:             string result;
  360:             DateTime now;
  361:  
  362:             reportViewModel.InsertResult = new Ia.Cl.Models.Result();
  363:  
  364:             var reportId = reportViewModel.ReportId;
  365:  
  366:             var report = Ia.Dn.Cl.Models.Data.Report.Read(reportId); // refresh report
  367:             Ia.Dn.Cl.Models.ReportHistory reportHistory = null;
  368:  
  369:             if (!string.IsNullOrEmpty(reportViewModel.ResolutionSelectedValue))
  370:             {
  371:                 if (Ia.Dn.Cl.Models.Business.Authority.StaffCanCreateReadUpdateDeleteReportHistory(Ia.Dn.Cl.Models.Business.Authority.PersistentStorageFunction.Create, report, null, reportViewModel.CurrentStaffIdentityUser))
  372:                 {
  373:                     now = DateTime.UtcNow.AddHours(3);
  374:  
  375:                     area = 11; // <area id="11" name="Service"
  376:  
  377:                     var indication = int.Parse(reportViewModel.IndicationSelectedValue);
  378:                     var resolution = int.Parse(reportViewModel.ResolutionSelectedValue);
  379:                     var action = int.Parse(reportViewModel.ActionSelectedValue);
  380:                     var estimate = int.Parse(reportViewModel.EstimateSelectedValue);
  381:  
  382:                     var detail = WebUtility.HtmlDecode(reportViewModel.DetailTextArea);
  383:                     var note = WebUtility.HtmlDecode(reportViewModel.NoteTextArea);
  384:  
  385:                     // below: first check if the last resolution is an assignement and weather the users is rejecting it
  386:                     if (resolution == 1005)
  387:                     {
  388:                         if (report.LastReportHistory != null && report.LastReportHistory.Resolution == 1003)
  389:                         {
  390:                             /*
  391:                              * <resolution id="1002" name="Assign" arabicName="تعيين" insertForm="false"/>
  392:                              * <resolution id="1003" name="Assigned" arabicName="تم تعيين" insertForm="false"/>
  393:                              * <resolution id="1004" name="Accepted" arabicName="قُبِل التعيين" insertForm="false"/>
  394:                              * <resolution id="1005" name="Not Accepted" arabicName="رفض التعيين" insertForm="true"/>
  395:                              */
  396:  
  397:                             // below: the user refuses an assignement, code will look for assingment before last, which should be resolution=1002 and reverse it back to the assigner
  398:  
  399:                             var assigneeStaffIdentityUser = report.SecondToLastReportHistory.StaffIdentityUser;
  400:  
  401:                             // below: first say that this person rejects an assignment
  402:                             // below: <resolution id="1005" name="Not Accepted"
  403:                             resolution = 1005;
  404:                             reportHistory = new Ia.Dn.Cl.Models.ReportHistory
  405:                             {
  406:                                 Report = Ia.Dn.Cl.Models.Data.Report.Read(reportId),
  407:                                 Area = area,
  408:                                 Indication = indication,
  409:                                 Resolution = resolution,
  410:                                 Action = action,
  411:                                 Estimate = estimate,
  412:                                 Detail = detail,
  413:                                 StaffIdentityUser = reportViewModel.CurrentStaffIdentityUser,
  414:                                 Note = note,
  415:                                 Created = now,
  416:                                 Updated = now
  417:                             };
  418:  
  419:                             reportInserted = Ia.Dn.Cl.Models.Data.ReportHistory.Create(reportHistory, out result);
  420:  
  421:                             if (reportInserted)
  422:                             {
  423:                                 // below: this user assigns to other user
  424:                                 // below: <resolution id="1002" name="Assign"
  425:                                 resolution = 1002;
  426:                                 reportHistory = new Ia.Dn.Cl.Models.ReportHistory
  427:                                 {
  428:                                     Report = Ia.Dn.Cl.Models.Data.Report.Read(reportId),
  429:                                     Area = area,
  430:                                     Indication = indication,
  431:                                     Resolution = resolution,
  432:                                     Action = action,
  433:                                     Estimate = estimate,
  434:                                     Detail = detail,
  435:                                     StaffIdentityUser = reportViewModel.CurrentStaffIdentityUser,
  436:                                     Note = note,
  437:                                     Created = now,
  438:                                     Updated = now
  439:                                 };
  440:  
  441:                                 reportInserted = Ia.Dn.Cl.Models.Data.ReportHistory.Create(reportHistory, out result);
  442:  
  443:                                 if (reportInserted)
  444:                                 {
  445:                                     // below: <resolution id="1003" name="Assigned"
  446:                                     resolution = 1003;
  447:                                     reportHistory = new Ia.Dn.Cl.Models.ReportHistory
  448:                                     {
  449:                                         Report = Ia.Dn.Cl.Models.Data.Report.Read(reportId),
  450:                                         Area = area,
  451:                                         Indication = indication,
  452:                                         Resolution = resolution,
  453:                                         Action = action,
  454:                                         Estimate = estimate,
  455:                                         Detail = detail,
  456:                                         StaffIdentityUser = assigneeStaffIdentityUser,
  457:                                         Note = note,
  458:                                         Created = now,
  459:                                         Updated = now
  460:                                     };
  461:  
  462:                                     reportInserted = Ia.Dn.Cl.Models.Data.ReportHistory.Create(reportHistory, out result);
  463:  
  464:                                     if (reportInserted)
  465:                                     {
  466:                                         if (bool.TryParse(reportViewModel.ComplainantNotifiedSelectedValue, out bool complainantNotifiedSelected))
  467:                                         {
  468:                                             complainantNotified = complainantNotifiedSelected && Ia.Dn.Cl.Models.Data.ReportHistory.ComplainantNotified(reportHistory);
  469:                                         }
  470:                                         else
  471:                                         {
  472:                                         }
  473:  
  474:                                         reportClosed = reportViewModel.CloseReportCheckBoxEnabled && Ia.Dn.Cl.Models.Data.Report.CloseStatus(report);
  475:  
  476:                                         if (reportClosed)
  477:                                         {
  478:                                             reportViewModel.InsertResult.AddSuccess("Report history successfully inserted and report closed (أدخلت حالة تقرير بنجاح وأغلق التقرير)");
  479:                                         }
  480:                                         else
  481:                                         {
  482:                                             reportViewModel.InsertResult.AddSuccess("Report history successfully inserted (أدخلت حالة تقرير بنجاح)");
  483:                                         }
  484:                                     }
  485:                                     else
  486:                                     {
  487:                                         reportViewModel.InsertResult.AddWarning("Two report histories successfully created, but the assignment acknowledgment (third) report was not successful (أدخل التقرير الأول والثاني بنجاح، لكن لم يدخل الثالث).");
  488:                                     }
  489:                                 }
  490:                                 else
  491:                                 {
  492:                                     reportViewModel.InsertResult.AddWarning("One report history successfully created, but the assignment (second) report was not successful (أدخل التقرير الأول بنجاح، لكن لم يدخل الثاني).");
  493:                                 }
  494:                             }
  495:                             else
  496:                             {
  497:                                 reportViewModel.InsertResult.AddWarning("One report history successfully created, but you can't assign to yourself (أدخل التقرير الأول بنجاح، لكن لا تستطيع التعيين لنفسك).");
  498:                             }
  499:                         }
  500:                         else
  501:                         {
  502:                             reportViewModel.InsertResult.AddError("No one assigned this report history to you (لم يتم التعيين لك)");
  503:                         }
  504:                     }
  505:                     else
  506:                     {
  507:                         reportHistory = new Ia.Dn.Cl.Models.ReportHistory
  508:                         {
  509:                             Report = Ia.Dn.Cl.Models.Data.Report.Read(reportId),
  510:                             Area = area,
  511:                             Indication = indication,
  512:                             Resolution = resolution,
  513:                             Action = action,
  514:                             Estimate = estimate,
  515:                             Detail = detail,
  516:                             StaffIdentityUser = reportViewModel.CurrentStaffIdentityUser,
  517:                             Note = note,
  518:                             Created = now,
  519:                             Updated = now
  520:                         };
  521:  
  522:                         reportInserted = Ia.Dn.Cl.Models.Data.ReportHistory.Create(reportHistory, out result);
  523:  
  524:                         if (reportInserted)
  525:                         {
  526:                             if (!string.IsNullOrEmpty(reportViewModel.StaffFrameworkAssignmentSelectedValue))
  527:                             {
  528:                                 // below: when an assignment is issued two more records will be inserted
  529:                                 /*
  530:                                  * <resolution id="1002" name="Assign" arabicName="تعيين" insertForm="false"/>
  531:                                  * <resolution id="1003" name="Assigned" arabicName="تم تعيين" insertForm="false"/>
  532:                                  * <resolution id="1004" name="Accepted" arabicName="قُبِل التعيين" insertForm="false"/>
  533:                                  * <resolution id="1005" name="Not Accepted" arabicName="رفض التعيين" insertForm="true"/>
  534:                                  */
  535:  
  536:                                 bool isFrameworkId;
  537:                                 Ia.Dn.Cl.Models.StaffIdentityUser assigneeStaffIdentityUser;
  538:  
  539:                                 var staffFrameworkId = reportViewModel.StaffFrameworkAssignmentSelectedValue;
  540:  
  541:                                 if (Ia.Dn.Cl.Models.Business.Administration.IsFrameworkId(staffFrameworkId))
  542:                                 {
  543:                                     isFrameworkId = true;
  544:  
  545:                                     assigneeStaffIdentityUser = reportViewModel.CurrentStaffIdentityUser;
  546:                                 }
  547:                                 else
  548:                                 {
  549:                                     isFrameworkId = false;
  550:  
  551:                                     assigneeStaffIdentityUser = (from s in Ia.Dn.Cl.Models.Data.StaffIdentityUser.List()
  552:                                                                  where s.Id == staffFrameworkId
  553:                                                                  select s).SingleOrDefault();
  554:                                 }
  555:  
  556:                                 // below: check if the assigner and assignee are the same
  557:                                 //if (!isFrameworkId && reportViewModel.CurrentStaffIdentityUser.Id != assigneeStaffIdentityUser.Id)
  558:                                 //{
  559:                                 resolution = 1002; // <resolution id="1002" name="Assign" arabicName="تعيين" insertForm="false"/>
  560:  
  561:                                 // below: then indicate the assigner
  562:                                 reportHistory = new Ia.Dn.Cl.Models.ReportHistory
  563:                                 {
  564:                                     Report = Ia.Dn.Cl.Models.Data.Report.Read(reportId),
  565:                                     Area = area,
  566:                                     Indication = indication,
  567:                                     Resolution = resolution,
  568:                                     Action = action,
  569:                                     Estimate = estimate,
  570:                                     Detail = detail,
  571:                                     StaffIdentityUser = reportViewModel.CurrentStaffIdentityUser,
  572:                                     Note = note,
  573:                                     Created = now,
  574:                                     Updated = now
  575:                                 };
  576:  
  577:                                 reportInserted = Ia.Dn.Cl.Models.Data.ReportHistory.Create(reportHistory, out result);
  578:  
  579:                                 if (reportInserted)
  580:                                 {
  581:                                     // below: check if assignee is staff or framework
  582:  
  583:                                     if (isFrameworkId) resolution = 1016; // <resolution id="1016" name="Domain Assignment" arabicName="تعيين نطاق"
  584:                                     else resolution = 1003; // <resolution id="1003" name="Assigned" arabicName="تم تعيين"/>
  585:  
  586:                                     // below: then indicate the person, or the framework, that was assigned to
  587:                                     reportHistory = new Ia.Dn.Cl.Models.ReportHistory
  588:                                     {
  589:                                         Report = Ia.Dn.Cl.Models.Data.Report.Read(reportId),
  590:                                         Area = area,
  591:                                         Indication = indication,
  592:                                         Resolution = resolution,
  593:                                         Action = action,
  594:                                         Estimate = estimate,
  595:                                         Detail = detail,
  596:                                         StaffIdentityUser = assigneeStaffIdentityUser,
  597:                                         FrameworkId = staffFrameworkId,
  598:                                         Note = note,
  599:                                         Created = now,
  600:                                         Updated = now
  601:                                     };
  602:  
  603:                                     reportInserted = Ia.Dn.Cl.Models.Data.ReportHistory.Create(reportHistory, out result);
  604:  
  605:                                     if (reportInserted)
  606:                                     {
  607:                                         if (bool.TryParse(reportViewModel.ComplainantNotifiedSelectedValue, out bool complainantNotifiedSelected))
  608:                                         {
  609:                                             complainantNotified = complainantNotifiedSelected && Ia.Dn.Cl.Models.Data.ReportHistory.ComplainantNotified(reportHistory);
  610:                                         }
  611:                                         else
  612:                                         {
  613:                                         }
  614:  
  615:                                         reportClosed = reportViewModel.CloseReportCheckBoxEnabled && Ia.Dn.Cl.Models.Data.Report.CloseStatus(report);
  616:  
  617:                                         if (reportClosed)
  618:                                         {
  619:                                             reportViewModel.InsertResult.AddSuccess("Report history successfully inserted and report closed (أدخلت حالة تقرير بنجاح وأغلق التقرير)");
  620:                                         }
  621:                                         else
  622:                                         {
  623:                                             reportViewModel.InsertResult.AddSuccess("Report history successfully inserted (أدخلت حالة تقرير بنجاح)");
  624:                                         }
  625:                                     }
  626:                                     else
  627:                                     {
  628:                                         reportViewModel.InsertResult.AddWarning("Two report histories successfully created, but the assignment acknowledgment (third) report was not successful (أدخل التقرير الأول والثاني بنجاح، لكن لم يدخل الثالث)");
  629:                                     }
  630:                                 }
  631:                                 else
  632:                                 {
  633:                                     reportViewModel.InsertResult.AddWarning("One report history successfully created, but the assignment (second) report was not successful (أدخل التقرير الأول بنجاح، لكن لم يدخل الثاني)");
  634:                                 }
  635:                                 //}
  636:                                 //else
  637:                                 //{
  638:                                 //    reportViewModel.InsertResult.AddWarning("One report history successfully created, but you can't assign to yourself (أدخل التقرير الأول بنجاح، لكن لا تستطيع التعيين لنفسك)");
  639:                                 //}
  640:  
  641:                                 // below: reset the assignment to nothing
  642:                                 reportViewModel.StaffFrameworkAssignmentSelectedValue = string.Empty;
  643:                             }
  644:                             else
  645:                             {
  646:                                 if (bool.TryParse(reportViewModel.ComplainantNotifiedSelectedValue, out bool complainantNotifiedSelected))
  647:                                 {
  648:                                     complainantNotified = complainantNotifiedSelected && Ia.Dn.Cl.Models.Data.ReportHistory.ComplainantNotified(reportHistory);
  649:                                 }
  650:                                 else
  651:                                 {
  652:                                 }
  653:  
  654:                                 if (bool.TryParse(reportViewModel.CloseReportSelectedValue, out bool closeReportSelected))
  655:                                 {
  656:                                     reportClosed = closeReportSelected && Ia.Dn.Cl.Models.Data.Report.CloseStatus(report);
  657:  
  658:                                     if (reportClosed)
  659:                                     {
  660:                                         reportViewModel.InsertResult.AddSuccess("Report history successfully inserted and report closed (أدخلت حالة تقرير بنجاح وأغلق التقرير)");
  661:                                     }
  662:                                     else
  663:                                     {
  664:                                         reportViewModel.InsertResult.AddSuccess("Report history successfully inserted (أدخلت حالة تقرير بنجاح)");
  665:                                     }
  666:                                 }
  667:                                 else
  668:                                 {
  669:                                 }
  670:                             }
  671:                         }
  672:                         else
  673:                         {
  674:                             reportViewModel.InsertResult.AddError("Report history not created (لم يدخل التقرير)");
  675:                         }
  676:                     }
  677:                 }
  678:                 else
  679:                 {
  680:                     reportViewModel.InsertButtonEnabled = false;
  681:  
  682:                     reportViewModel.InsertResult.AddError("You are not authorized to modify this report (لست مخولاً بتعديل هذا التقرير)");
  683:                 }
  684:             }
  685:             else
  686:             {
  687:                 reportViewModel.InsertResult.AddError("Missing resolution (لا نتيجة)");
  688:             }
  689:  
  690:             report = Ia.Dn.Cl.Models.Data.Report.Read(reportId); // refresh report
  691:         }
  692:  
  693:         ////////////////////////////////////////////////////////////////////////////
  694:  
  695:         /// <summary>
  696:         ///
  697:         /// </summary>
  698:         private static void ReopenClosedReport(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel)
  699:         {
  700:             bool reportInserted, reportReopened;
  701:             int area, indication, resolution, action, estimate;
  702:             string detail, note;
  703:             DateTime now;
  704:  
  705:             reportViewModel.Result = new Ia.Cl.Models.Result();
  706:  
  707:             var reportId = reportViewModel.ReportId;
  708:  
  709:             var report = Ia.Dn.Cl.Models.Data.Report.Read(reportId);
  710:             Ia.Dn.Cl.Models.ReportHistory reportHistory = null;
  711:  
  712:             if (Ia.Dn.Cl.Models.Business.Authority.StaffCanCreateReadUpdateDeleteReportHistory(Ia.Dn.Cl.Models.Business.Authority.PersistentStorageFunction.Create, report, null, reportViewModel.CurrentStaffIdentityUser)
  713:             && Ia.Dn.Cl.Models.Business.Authority.StaffCanReopenClosedReport(report, reportViewModel.CurrentStaffIdentityUser))
  714:             {
  715:                 now = DateTime.UtcNow.AddHours(3);
  716:  
  717:                 area = 11; // <area id="11" name="Service"
  718:  
  719:                 indication = 0;
  720:                 resolution = 1022; // <resolution id = "1022" name = "Reopened" arabicName = "إعادة فتح" 
  721:                 action = 0;
  722:                 estimate = 0;
  723:                 detail = string.Empty;
  724:                 note = string.Empty;
  725:  
  726:                 reportHistory = new Ia.Dn.Cl.Models.ReportHistory
  727:                 {
  728:                     Report = Ia.Dn.Cl.Models.Data.Report.Read(reportId),
  729:                     Area = area,
  730:                     Indication = indication,
  731:                     Resolution = resolution,
  732:                     Action = action,
  733:                     Estimate = estimate,
  734:                     Detail = detail,
  735:                     StaffIdentityUser = reportViewModel.CurrentStaffIdentityUser,
  736:                     Note = note,
  737:                     Created = now,
  738:                     Updated = now
  739:                 };
  740:  
  741:                 reportInserted = Ia.Dn.Cl.Models.Data.ReportHistory.Create(reportHistory, out string result);
  742:  
  743:                 if (reportInserted)
  744:                 {
  745:                     reportReopened = Ia.Dn.Cl.Models.Data.Report.OpenStatus(report);//, staff);
  746:  
  747:                     if (reportReopened)
  748:                     {
  749:                         reportViewModel.Result.AddSuccess("Report history successfully reopened (تم فتح التقرير بنجاح)");
  750:                     }
  751:                     else
  752:                     {
  753:                         reportViewModel.Result.AddError("Report history not reopened (لم يفتح التقرير)");
  754:                     }
  755:                 }
  756:                 else
  757:                 {
  758:                     reportViewModel.Result.AddError("Report history not created (لم يدخل التقرير)");
  759:                 }
  760:             }
  761:             else
  762:             {
  763:                 reportViewModel.InsertButtonEnabled = false;
  764:  
  765:                 reportViewModel.Result.AddError("You are not authorized to modify this report (لست مخولاً بتعديل هذا التقرير)");
  766:             }
  767:  
  768:             report = Ia.Dn.Cl.Models.Data.Report.Read(reportId);
  769:         }
  770:  
  771:         ////////////////////////////////////////////////////////////////////////////
  772:  
  773:         /// <summary>
  774:         ///
  775:         /// </summary>
  776:         private static void ReportSelectList_ViewModel(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel)
  777:         {
  778:             reportViewModel.ReportList = Ia.Dn.Cl.Models.Data.Report.ReadSingleAsList(reportViewModel.ReportId);
  779:         }
  780:  
  781:         ////////////////////////////////////////////////////////////////////////////
  782:  
  783:         /// <summary>
  784:         ///
  785:         /// </summary>
  786:         private static void StaffFrameworkAssignmentSelectList_ViewModel(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel, Ia.Dn.Cl.Models.Report report)
  787:         {
  788:             var list = Ia.Dn.Cl.Models.Business.Authority.StaffFrameworkListOfAllowedReportAssignsByStaff(report, reportViewModel.CurrentStaffIdentityUser);
  789:  
  790:             var list1 = new List<SelectListItem>();
  791:             list1.Add(new SelectListItem("", ""));
  792:  
  793:             foreach (var l in list) list1.Add(new SelectListItem(l.Name, l.Id));
  794:  
  795:             reportViewModel.StaffFrameworkAssignmentSelectList = new SelectList(list1, "Value", "Text");
  796:             reportViewModel.StaffFrameworkAssignmentSelectedValue = ""; // always default to none
  797:         }
  798:  
  799:         ////////////////////////////////////////////////////////////////////////////
  800:  
  801:         /// <summary>
  802:         ///
  803:         /// </summary>
  804:         private static void IndicationSelectList_ViewModel(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel, Ia.Dn.Cl.Models.Report report)
  805:         {
  806:             var currentStaffIdentityUser = reportViewModel.CurrentStaffIdentityUser;
  807:  
  808:             var list = (from i in Ia.Dn.Cl.Models.Data.Report.IndicationList
  809:                         where (i.Area != null && i.Area.Frameworks != null && (i.Area.Frameworks.Intersect(currentStaffIdentityUser.Framework.AncestorsOrSelf.Select(u => u.ArabicName)).Any() || i.Area.Frameworks.Intersect(currentStaffIdentityUser.Framework.AncestorsOrSelf.Select(u => u.FullyQualifiedArabicName)).Any())
  810:                         && i.Frameworks != null && (i.Frameworks.Intersect(currentStaffIdentityUser.Framework.AncestorsOrSelf.Select(u => u.ArabicName)).Any() || i.Frameworks.Intersect(currentStaffIdentityUser.Framework.AncestorsOrSelf.Select(u => u.FullyQualifiedArabicName)).Any())
  811:                         && !i.Obsolete && i.CanInsert) || i.Area == null
  812:                         select new
  813:                         {
  814:                             i.ColoredEnglishAndArabicName,
  815:                             i.XmlId
  816:                         }).Distinct().ToList();
  817:  
  818:             reportViewModel.IndicationSelectList = new SelectList(list, "XmlId", "ColoredEnglishAndArabicName");
  819:             reportViewModel.IndicationSelectedValue ??= "1000"; // <indication id="1000" name="Unspecified" arabicName="غير محدد"/>
  820:         }
  821:  
  822:         ////////////////////////////////////////////////////////////////////////////
  823:  
  824:         /// <summary>
  825:         ///
  826:         /// </summary>
  827:         private static void ActionSelectList_ViewModel(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel, Ia.Dn.Cl.Models.Report report)
  828:         {
  829:             var currentStaffIdentityUser = reportViewModel.CurrentStaffIdentityUser;
  830:  
  831:             var list = (from a in Ia.Dn.Cl.Models.Data.Report.ActionList
  832:                         where (a.Area != null && a.Area.Frameworks != null && (a.Area.Frameworks.Intersect(currentStaffIdentityUser.Framework.AncestorsOrSelf.Select(u => u.ArabicName)).Any() || a.Area.Frameworks.Intersect(currentStaffIdentityUser.Framework.AncestorsOrSelf.Select(u => u.FullyQualifiedArabicName)).Any())
  833:                         && a.Frameworks != null && (a.Frameworks.Intersect(currentStaffIdentityUser.Framework.AncestorsOrSelf.Select(u => u.ArabicName)).Any() || a.Frameworks.Intersect(currentStaffIdentityUser.Framework.AncestorsOrSelf.Select(u => u.FullyQualifiedArabicName)).Any())
  834:                         && !a.Obsolete && a.CanInsert) || a.Area == null
  835:                         select new
  836:                         {
  837:                             a.ColoredEnglishAndArabicName,
  838:                             a.XmlId
  839:                         }).Distinct().ToList();
  840:  
  841:             reportViewModel.ActionSelectList = new SelectList(list, "XmlId", "ColoredEnglishAndArabicName");
  842:             reportViewModel.ActionSelectedValue ??= "1000"; // <resolution id="1000" name="Unspecified" arabicName="غير محدد"/>
  843:         }
  844:  
  845:         ////////////////////////////////////////////////////////////////////////////
  846:  
  847:         /// <summary>
  848:         ///
  849:         /// </summary>
  850:         private static void ResolutionSelectList_ViewModel(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel)
  851:         {
  852:             var list = (from r in Ia.Dn.Cl.Models.Data.Report.ResolutionList
  853:                         where !r.Obsolete && r.CanInsert
  854:                         select new
  855:                         {
  856:                             r.ColoredEnglishAndArabicName,
  857:                             r.XmlId
  858:                         }).Distinct().ToList();
  859:  
  860:             reportViewModel.ResolutionSelectList = new SelectList(list, "XmlId", "ColoredEnglishAndArabicName");
  861:             reportViewModel.ResolutionSelectedValue ??= "1000"; // <indication id="1000" name="Unspecified" arabicName="غير محدد"/>
  862:         }
  863:  
  864:         ////////////////////////////////////////////////////////////////////////////
  865:  
  866:         /// <summary>
  867:         ///
  868:         /// </summary>
  869:         private static void EstimateSelectList_ViewModel(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel)
  870:         {
  871:             var list = Ia.Dn.Cl.Models.Data.Report.EstimateEnglishAndArabicDictionary;
  872:  
  873:             reportViewModel.EstimateSelectList = new SelectList(list, "Key", "Value", "0");
  874:         }
  875:  
  876:         ////////////////////////////////////////////////////////////////////////////
  877:  
  878:         /// <summary>
  879:         ///
  880:         /// </summary>
  881:         private static void ReportHistorySelectList_ViewModel(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel, Ia.Dn.Cl.Models.Report report)
  882:         {
  883:             var reportId = reportViewModel.ReportId;
  884:  
  885:             if (Ia.Dn.Cl.Models.Business.Authority.StaffCanCreateReadUpdateDeleteReportHistory(Ia.Dn.Cl.Models.Business.Authority.PersistentStorageFunction.Create, report, null, reportViewModel.CurrentStaffIdentityUser))
  886:             {
  887:                 reportViewModel.InsertButtonEnabled = true;
  888:             }
  889:             else
  890:             {
  891:                 // below: not owner
  892:                 reportViewModel.InsertButtonEnabled = false;
  893:  
  894:                 reportViewModel.InformationResult.AddError("You are not authorized to modify this report (لست مخولاً بتعديل هذا التقرير)");
  895:             }
  896:  
  897:             reportViewModel.ReportHistoryList = Ia.Dn.Cl.Models.Data.ReportHistory.ListForReportId(reportId);
  898:         }
  899:  
  900:         ////////////////////////////////////////////////////////////////////////////
  901:         ////////////////////////////////////////////////////////////////////////////
  902:  
  903:  
  904:  
  905:  
  906:  
  907:  
  908:  
  909:  
  910:  
  911:  
  912:  
  913:  
  914:  
  915:  
  916:  
  917:  
  918:  
  919:  
  920:  
  921:  
  922:  
  923:  
  924:  
  925:         ////////////////////////////////////////////////////////////////////////////
  926:         ////////////////////////////////////////////////////////////////////////////
  927:  
  928:         /// <summary>
  929:         ///
  930:         /// </summary>
  931:         public static void InsertViewModel(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel)
  932:         {
  933:             reportViewModel.PreliminaryAnalysisPanelVisible = false;
  934:             reportViewModel.ServiceAPanelVisible = true;
  935:  
  936:             PrioritySelectList_ViewModel(ref reportViewModel);
  937:             SeverityRadioButton_ViewModel(ref reportViewModel);
  938:             TreeView_DataAssign(ref reportViewModel);
  939:         }
  940:  
  941:         ////////////////////////////////////////////////////////////////////////////
  942:  
  943:         /// <summary>
  944:         ///
  945:         /// </summary>
  946:         private static void SeverityRadioButton_ViewModel(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel)
  947:         {
  948:             var list = Ia.Dn.Cl.Models.Data.Report.SeverityColoredDictionary;
  949:  
  950:             reportViewModel.SeveritySelectList = new SelectList(list, "Key", "Value");
  951:             reportViewModel.SeveritySelectedValue ??= "0";
  952:         }
  953:  
  954:         ////////////////////////////////////////////////////////////////////////////
  955:  
  956:         /// <summary>
  957:         ///
  958:         /// </summary>
  959:         private static void PrioritySelectList_ViewModel(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel)
  960:         {
  961:             var list = Ia.Dn.Cl.Models.Data.Report.PriorityEnglishAndArabicDictionary;
  962:  
  963:             reportViewModel.PrioritySelectList = new SelectList(list, "Key", "Value");
  964:         }
  965:  
  966:         ////////////////////////////////////////////////////////////////////////////
  967:  
  968:         /// <summary>
  969:         ///
  970:         /// </summary>
  971:         private static void TreeView_DataAssign(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel)
  972:         {
  973:             //indicationXmlDataSource.Data = Ia.Dn.Cl.Models.Data.Report.XDocument.ToString();
  974:             //indicationXmlDataSource.XPath = "report/customerCare/indication/*";
  975:         }
  976:  
  977:         ////////////////////////////////////////////////////////////////////////////
  978:         ////////////////////////////////////////////////////////////////////////////
  979:  
  980:         /// <summary>
  981:         ///
  982:         /// </summary>
  983:         public static void Find(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel)
  984:         {
  985:             int reportServiceType;
  986:             string input;
  987:  
  988:             input = WebUtility.HtmlDecode(reportViewModel.ServiceInput);
  989:  
  990:             reportViewModel.FindResult = new Ia.Cl.Models.Result();
  991:  
  992:             if (!string.IsNullOrEmpty(input))
  993:             {
  994:                 // below: space characters from start and end
  995:  
  996:                 input = input.Trim();
  997:  
  998:                 input = Regex.Replace(input, @"^\s+", "");
  999:                 input = Regex.Replace(input, @"\s+$", "");
 1000:                 input = input.ToUpper();
 1001:  
 1002:                 // below: the regex checks the format of input:
 1003:  
 1004:                 if (Ia.Dn.Cl.Models.Business.Service.ServiceHasEightDigitsAndIsWithinAllowedDomainList(input))
 1005:                 {
 1006:                     reportServiceType = (int)Ia.Dn.Cl.Models.Business.Report.ServiceType.Dn;
 1007:  
 1008:                     Find(ref reportViewModel, input, reportServiceType);
 1009:                 }
 1010:                 else if (Ia.Dn.Cl.Models.Business.Access.AccessNameIsInAValidFormat(input))
 1011:                 {
 1012:                     reportServiceType = (int)Ia.Dn.Cl.Models.Business.Report.ServiceType.AccessName;
 1013:  
 1014:                     Find(ref reportViewModel, input, reportServiceType);
 1015:                 }
 1016:                 else
 1017:                 {
 1018:                     reportServiceType = (int)Ia.Dn.Cl.Models.Business.Report.ServiceType.Unspecified;
 1019:  
 1020:                     reportViewModel.ServicePreviewText = string.Empty;
 1021:                     reportViewModel.InsertButtonEnabled = false;
 1022:  
 1023:                     reportViewModel.FindResult.AddError("Input format is unknown (قيمة غير مفهومة)");
 1024:                 }
 1025:  
 1026:                 reportViewModel.ReportServiceTypeLabel = reportServiceType.ToString();
 1027:             }
 1028:             else
 1029:             {
 1030:                 reportViewModel.FindResult.AddError("No input was entered (لم يتم إدخال أي شيء)");
 1031:  
 1032:                 reportViewModel.ServicePreviewText = string.Empty;
 1033:                 reportViewModel.InsertButtonEnabled = false;
 1034:             }
 1035:         }
 1036:  
 1037:         ////////////////////////////////////////////////////////////////////////////
 1038:  
 1039:         /// <summary>
 1040:         ///
 1041:         /// </summary>
 1042:         private static void Find(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel, string input, int reportServiceType)
 1043:         {
 1044:             bool openReportExists;
 1045:             string serviceName, accessName;
 1046:             Ia.Dn.Cl.Models.Access access;
 1047:             Ia.Dn.Cl.Models.Business.NetworkDesignDocument.Vendor switchVendor, accessVendor;
 1048:             List<Ia.Dn.Cl.Models.Report> reportList;
 1049:  
 1050:             reportViewModel.FindResult = new Ia.Cl.Models.Result();
 1051:  
 1052:             openReportExists = false;
 1053:             reportViewModel.ServicePreviewLabel = reportViewModel.ReportPreviewLabel = /*findResultLabel.Text =*/ string.Empty;
 1054:  
 1055:             serviceName = Ia.Dn.Cl.Models.Business.Service.ServiceName(input, reportServiceType);
 1056:  
 1057:             if (reportServiceType == (int)Ia.Dn.Cl.Models.Business.Report.ServiceType.Dn)
 1058:             {
 1059:                 if (Ia.Dn.Cl.Models.Business.Service.ServiceHasEightDigitsAndIsWithinAllowedDomainList(input))
 1060:                 {
 1061:                     if (Ia.Dn.Cl.Models.Business.Authority.NumberIsWithinFrameworkSiteDomainList(reportViewModel.CurrentStaffIdentityUser.Framework, input))
 1062:                     {
 1063:                         switchVendor = Ia.Dn.Cl.Models.Business.Service.SwitchVendor(input);
 1064:  
 1065:                         reportViewModel.ServicePreviewText = serviceName;
 1066:                         reportViewModel.ServicePreviewLink = Ia.Dn.Cl.Models.Business.Maintenance.Find.Url(serviceName);
 1067:                         reportViewModel.ServicePreviewPanelVisible = true;
 1068:  
 1069:                         using (var db = new Ia.Dn.Cl.Db())
 1070:                         {
 1071:                             access = (from a in db.Accesses
 1072:                                       join srs in db.ServiceRequestServices on a equals srs.Access
 1073:                                       where srs.Service == input
 1074:                                       select a).FirstOrDefault();
 1075:  
 1076:                             if (access != null)
 1077:                             {
 1078:                                 reportViewModel.ServicePreviewLabel = "(" + access.Name + ") " + access.Address;
 1079:                             }
 1080:                             else
 1081:                             {
 1082:                                 reportViewModel.ServicePreviewLabel = "Number property data not available (لا توجد معلومات عنوان للرقم)";
 1083:  
 1084:                                 reportViewModel.InsertButtonEnabled = true;
 1085:                                 reportViewModel.ServiceLabel = input;
 1086:                             }
 1087:                         }
 1088:  
 1089:                         // below: search for all available reports for this service and display them as link
 1090:                         reportList = Ia.Dn.Cl.Models.Data.Report.List(input);
 1091:  
 1092:                         if (reportList.Count >= 1)
 1093:                         {
 1094:                             reportViewModel.ReportPreviewLabel = string.Empty;
 1095:  
 1096:                             foreach (Ia.Dn.Cl.Models.Report report in reportList)
 1097:                             {
 1098:                                 // below: check if there are open reports
 1099:  
 1100:                                 // <status id="1" name="Open"
 1101:                                 // <status id="2" name="Closed"
 1102:                                 if (report.Status == 1)
 1103:                                 {
 1104:                                     openReportExists = true;
 1105:  
 1106:                                     reportViewModel.ReportPreviewLabel += "<a href=\"" + "history?reportId=" + report.Id + "\">" + report.Created.ToString("yyyy-MM-dd") + "</a> (open) ";
 1107:                                 }
 1108:                                 else
 1109:                                 {
 1110:                                     reportViewModel.ReportPreviewLabel += "<a href=\"" + "history?reportId=" + report.Id + "\">" + report.Created.ToString("yyyy-MM-dd") + "</a> ";
 1111:                                 }
 1112:                             }
 1113:  
 1114:                             reportViewModel.InsertedReportList = reportList;
 1115:  
 1116:                             if (openReportExists)
 1117:                             {
 1118:                                 reportViewModel.FindResult.AddWarning("You can not insert a new report because there is still an open report.<br /> لا يمكن إضافة تقرير جديد لهذا الرقم لأن تقريراً سابقاً لا يزال مفتوحاً");
 1119:  
 1120:                                 reportViewModel.InsertButtonEnabled = false;
 1121:                             }
 1122:                             else
 1123:                             {
 1124:                                 reportViewModel.InsertButtonEnabled = true;
 1125:                                 reportViewModel.ServiceLabel = input;
 1126:                             }
 1127:                         }
 1128:                         else
 1129:                         {
 1130:                             reportViewModel.InsertButtonEnabled = true;
 1131:                             reportViewModel.ServiceLabel = input;
 1132:  
 1133:                             reportViewModel.ReportPreviewLabel = "None (لا توجد)";
 1134:                         }
 1135:  
 1136:                         Ia.Dn.Cl.Models.Data.MessageQueue.SecretaryApplication.Enqueue(Ia.Dn.Cl.Models.Business.MessageQueue.Application.DnApplication, Ia.Dn.Cl.Models.Business.MessageQueue.Process.ReadService, input);
 1137:                     }
 1138:                     else
 1139:                     {
 1140:                         reportViewModel.FindResult.AddError("Number " + serviceName + " is not in staff site domain (الرقم لا ينتمي لنطاقات المستخدم)");
 1141:  
 1142:                         reportViewModel.ServicePreviewPanelVisible = false;
 1143:                         reportViewModel.InsertButtonEnabled = false;
 1144:                     }
 1145:                 }
 1146:                 else
 1147:                 {
 1148:                     reportViewModel.FindResult.AddError("Number " + serviceName + " is not within network (الرقم لا ينتمي للشبكة)");
 1149:  
 1150:                     reportViewModel.ServicePreviewPanelVisible = false;
 1151:                     reportViewModel.InsertButtonEnabled = false;
 1152:                 }
 1153:             }
 1154:             else if (reportServiceType == (int)Ia.Dn.Cl.Models.Business.Report.ServiceType.AccessName)
 1155:             {
 1156:                 if (Ia.Dn.Cl.Models.Data.NetworkDesignDocument.AccessNameIsWithinAllowedOntList(input, out accessName))
 1157:                 {
 1158:                     if (Ia.Dn.Cl.Models.Business.Authority.AccessNameIsWithinFrameworkSiteAreaSymbolList(reportViewModel.CurrentStaffIdentityUser.Framework, accessName))
 1159:                     {
 1160:                         accessVendor = Ia.Dn.Cl.Models.Business.Service.AccessVendor(accessName);
 1161:  
 1162:                         reportViewModel.ServicePreviewText = accessName;
 1163:                         reportViewModel.ServicePreviewLink = Ia.Dn.Cl.Models.Business.Maintenance.Find.Url(accessName);
 1164:  
 1165:                         access = Ia.Dn.Cl.Models.Data.Access.ReadByAccessName(accessName);
 1166:  
 1167:                         if (access != null)
 1168:                         {
 1169:                             reportViewModel.ServicePreviewPanelVisible = true;
 1170:                             reportViewModel.ServicePreviewLabel = "(" + access.Name + ") " + access.Address;
 1171:  
 1172:                             // below: search for all available reports for this accessName and display them as link
 1173:                             reportList = Ia.Dn.Cl.Models.Data.Report.List(access.Name);
 1174:  
 1175:                             if (reportList.Count >= 1)
 1176:                             {
 1177:                                 reportViewModel.ReportPreviewLabel = string.Empty;
 1178:  
 1179:                                 foreach (Ia.Dn.Cl.Models.Report report in reportList)
 1180:                                 {
 1181:                                     // below: we will check if there are open reports
 1182:  
 1183:                                     // <status id="1" name="Open"
 1184:                                     // <status id="2" name="Closed"
 1185:                                     if (report.Status == 1)
 1186:                                     {
 1187:                                         openReportExists = true;
 1188:  
 1189:                                         reportViewModel.ReportPreviewLabel += "<a href=\"" + "history?reportId=" + report.Id + "\">" + report.Created.ToString("yyyy-MM-dd") + "</a> (open) ";
 1190:                                     }
 1191:                                     else
 1192:                                     {
 1193:                                         reportViewModel.ReportPreviewLabel += "<a href=\"" + "history?reportId=" + report.Id + "\">" + report.Created.ToString("yyyy-MM-dd") + "</a> ";
 1194:                                     }
 1195:                                 }
 1196:  
 1197:                                 reportViewModel.InsertedReportList = reportList;
 1198:  
 1199:                                 if (openReportExists)
 1200:                                 {
 1201:                                     reportViewModel.FindResult.AddWarning("You can not insert a new report because there is still an open report.<br /> لا يمكن إضافة تقرير جديد لهذا الرقم لأن تقريراً سابقاً لا يزال مفتوحاً");
 1202:  
 1203:                                     reportViewModel.InsertButtonEnabled = false;
 1204:                                 }
 1205:                                 else
 1206:                                 {
 1207:                                     reportViewModel.ServiceLabel = accessName;
 1208:                                     reportViewModel.InsertButtonEnabled = true;
 1209:                                 }
 1210:                             }
 1211:                             else
 1212:                             {
 1213:                                 reportViewModel.ReportPreviewLabel = "None (لا توجد)";
 1214:  
 1215:                                 reportViewModel.FindResult.AddWarning("None (لا توجد)");
 1216:                                 //findResultLabel.CssClass = "warn";
 1217:  
 1218:                                 reportViewModel.ServiceLabel = accessName;
 1219:                                 reportViewModel.InsertButtonEnabled = true;
 1220:                             }
 1221:                         }
 1222:                         else
 1223:                         {
 1224:                             reportViewModel.FindResult.AddWarning("Access " + accessName + " data not available (لا توجد معلومات جهاز)");
 1225:  
 1226:                             reportViewModel.ServiceLabel = accessName;
 1227:                             reportViewModel.InsertButtonEnabled = true;
 1228:                         }
 1229:  
 1230:                         Ia.Dn.Cl.Models.Data.MessageQueue.SecretaryApplication.Enqueue(Ia.Dn.Cl.Models.Business.MessageQueue.Application.DnApplication, Ia.Dn.Cl.Models.Business.MessageQueue.Process.ReadAccess, accessName);
 1231:                     }
 1232:                     else
 1233:                     {
 1234:                         reportViewModel.FindResult.AddError("Access " + accessName + " is not in staff site access list (رقم الجهاز لا ينتمي لمقسم المستخدم)");
 1235:  
 1236:                         reportViewModel.ServicePreviewPanelVisible = false;
 1237:                         reportViewModel.InsertButtonEnabled = false;
 1238:                     }
 1239:                 }
 1240:                 else
 1241:                 {
 1242:                     reportViewModel.ServicePreviewText = string.Empty;
 1243:  
 1244:                     reportViewModel.FindResult.AddError("Access " + accessName + " does not belong to the network (الجهاز لا ينتمي للشبكة)");
 1245:  
 1246:                     reportViewModel.ServicePreviewPanelVisible = false;
 1247:                     reportViewModel.InsertButtonEnabled = false;
 1248:                 }
 1249:             }
 1250:             else
 1251:             {
 1252:                 reportViewModel.InsertAuthorityResult.AddError("Unknown error (خطأ غير معروف)");
 1253:  
 1254:                 reportViewModel.ServicePreviewPanelVisible = false;
 1255:                 reportViewModel.InsertButtonEnabled = false;
 1256:             }
 1257:         }
 1258:  
 1259:         ////////////////////////////////////////////////////////////////////////////
 1260:  
 1261:         /// <summary>
 1262:         ///
 1263:         /// </summary>
 1264:         private static bool OpenReportExistsForService(int reportServiceType, string input)
 1265:         {
 1266:             bool openReportExists;
 1267:             long number;
 1268:             string serviceName, accessName;
 1269:             Ia.Dn.Cl.Models.Access access;
 1270:             List<Ia.Dn.Cl.Models.Report> reportList;
 1271:  
 1272:             serviceName = Ia.Dn.Cl.Models.Business.Service.ServiceName(input, reportServiceType);
 1273:  
 1274:             if (reportServiceType == (int)Ia.Dn.Cl.Models.Business.Report.ServiceType.Dn)
 1275:             {
 1276:                 number = int.Parse(input);
 1277:  
 1278:                 if (Ia.Dn.Cl.Models.Business.Service.ServiceHasEightDigitsAndIsWithinAllowedDomainList(number))
 1279:                 {
 1280:                     reportList = Ia.Dn.Cl.Models.Data.Report.List(number.ToString());
 1281:  
 1282:                     if (reportList.Count >= 1)
 1283:                     {
 1284:                         openReportExists = false;
 1285:  
 1286:                         foreach (Ia.Dn.Cl.Models.Report report in reportList)
 1287:                         {
 1288:                             // below: check if there are open reports
 1289:  
 1290:                             // <status id="1" name="Open"
 1291:                             // <status id="2" name="Closed"
 1292:                             if (report.Status == 1)
 1293:                             {
 1294:                                 openReportExists = true;
 1295:                                 break;
 1296:                             }
 1297:                             else
 1298:                             {
 1299:                                 openReportExists = false;
 1300:                             }
 1301:                         }
 1302:                     }
 1303:                     else
 1304:                     {
 1305:                         openReportExists = false;
 1306:                     }
 1307:                 }
 1308:                 else
 1309:                 {
 1310:                     openReportExists = false;
 1311:                 }
 1312:             }
 1313:             else if (reportServiceType == (int)Ia.Dn.Cl.Models.Business.Report.ServiceType.AccessName)
 1314:             {
 1315:                 if (Ia.Dn.Cl.Models.Data.NetworkDesignDocument.AccessNameIsWithinAllowedOntList(input, out accessName))
 1316:                 {
 1317:                     access = Ia.Dn.Cl.Models.Data.Access.ReadByAccessName(accessName);
 1318:  
 1319:                     if (access != null)
 1320:                     {
 1321:                         reportList = Ia.Dn.Cl.Models.Data.Report.List(access.Name);
 1322:  
 1323:                         if (reportList.Count >= 1)
 1324:                         {
 1325:                             openReportExists = false;
 1326:  
 1327:                             foreach (Ia.Dn.Cl.Models.Report report in reportList)
 1328:                             {
 1329:                                 // below: we will check if there are open reports
 1330:  
 1331:                                 // <status id="1" name="Open"
 1332:                                 // <status id="2" name="Closed"
 1333:                                 if (report.Status == 1)
 1334:                                 {
 1335:                                     openReportExists = true;
 1336:                                     break;
 1337:                                 }
 1338:                                 else
 1339:                                 {
 1340:                                     openReportExists = false;
 1341:                                 }
 1342:                             }
 1343:                         }
 1344:                         else
 1345:                         {
 1346:                             openReportExists = false;
 1347:                         }
 1348:                     }
 1349:                     else
 1350:                     {
 1351:                         openReportExists = false;
 1352:                     }
 1353:                 }
 1354:                 else
 1355:                 {
 1356:                     openReportExists = false;
 1357:                 }
 1358:             }
 1359:             else
 1360:             {
 1361:                 openReportExists = false;
 1362:             }
 1363:  
 1364:             return openReportExists;
 1365:         }
 1366:  
 1367:         ////////////////////////////////////////////////////////////////////////////
 1368:  
 1369:         /// <summary>
 1370:         ///
 1371:         /// </summary>
 1372:         public static void InsertReport(ref Ia.Dn.Wa.Models.Maintenance.ReportViewModel reportViewModel)
 1373:         {
 1374:             int reportServiceType;
 1375:             string service, contact, result;
 1376:             DateTime now;
 1377:             Ia.Dn.Cl.Models.Report report;
 1378:  
 1379:             reportViewModel.InsertResult = new Ia.Cl.Models.Result();
 1380:  
 1381:             reportViewModel.DetailTextArea ??= string.Empty;
 1382:             reportViewModel.ContactNameInput ??= string.Empty;
 1383:             reportViewModel.ContactPhoneInput ??= string.Empty;
 1384:             reportViewModel.NoteTextArea ??= string.Empty;
 1385:  
 1386:             if (reportViewModel.ServiceInput.Length > 0)
 1387:             {
 1388:                 if (reportViewModel.ServicePreviewLink.Length > 0)
 1389:                 {
 1390:                     if (reportViewModel.DetailTextArea.Length > 0)
 1391:                     {
 1392:                         if (reportViewModel.ContactNameInput.Length > 0)
 1393:                         {
 1394:                             if (reportViewModel.ContactPhoneInput.Length > 0)
 1395:                             {
 1396:                                 if (reportViewModel.ServiceLabel.Length > 0 && reportViewModel.ReportServiceTypeLabel.Length > 0)
 1397:                                 {
 1398:                                     reportServiceType = int.Parse(reportViewModel.ReportServiceTypeLabel);
 1399:                                     service = WebUtility.HtmlDecode(reportViewModel.ServiceLabel);
 1400:  
 1401:                                     if (!OpenReportExistsForService(reportServiceType, service))
 1402:                                     {
 1403:                                         now = DateTime.UtcNow.AddHours(3);
 1404:  
 1405:                                         contact = WebUtility.HtmlDecode(reportViewModel.ContactNameInput) + " " + WebUtility.HtmlDecode(reportViewModel.ContactPhoneInput);
 1406:  
 1407:                                         /*
 1408:                                         below:
 1409:                                         <type id="1" name="Dn"
 1410:                                         <type id="2" name="Ont Name"
 1411:                                         <type id="3" name="No Ont"
 1412:                                         <type id="0" name="Unspecified"
 1413:                                         */
 1414:  
 1415:                                         report = new Ia.Dn.Cl.Models.Report
 1416:                                         {
 1417:                                             Service = service,
 1418:                                             ServiceType = reportServiceType,
 1419:                                             Area = 11, // <area id="11" name="Service"
 1420:                                             Category = 1,
 1421:                                             Severity = int.Parse(reportViewModel.SeveritySelectedValue),
 1422:                                             Priority = int.Parse(reportViewModel.PrioritySelectedValue),
 1423:                                             Status = 1, // <status id="1" name="Open" ...>
 1424:                                             Detail = WebUtility.HtmlDecode(reportViewModel.DetailTextArea),
 1425:                                             Contact = contact,
 1426:                                             StaffIdentityUser = reportViewModel.CurrentStaffIdentityUser,
 1427:                                             Note = WebUtility.HtmlDecode(reportViewModel.NoteTextArea),
 1428:                                             Created = now,
 1429:                                             Updated = now
 1430:                                         };
 1431:  
 1432:                                         var reportId = Ia.Dn.Cl.Models.Data.Report.Create(report, out result);
 1433:  
 1434:                                         if (reportId >= 0)
 1435:                                         {
 1436:                                             reportViewModel.ReportId = reportId;
 1437:  
 1438:                                             var s = "Report successfully created (تم إدخال المعلومات)";
 1439:                                             reportViewModel.InsertResult.AddSuccess(s);
 1440:  
 1441:                                             reportViewModel.ServiceInput = reportViewModel.DetailTextArea = reportViewModel.ContactNameInput = reportViewModel.ContactPhoneInput = reportViewModel.NoteTextArea = string.Empty;
 1442:  
 1443:                                             reportViewModel.InsertButtonEnabled = false;
 1444:                                         }
 1445:                                         else
 1446:                                         {
 1447:                                             reportViewModel.ReportId = -1;
 1448:  
 1449:                                             reportViewModel.InsertResult.AddError(result);
 1450:                                         }
 1451:                                     }
 1452:                                     else
 1453:                                     {
 1454:                                         reportViewModel.InsertResult.AddError("You can not insert a new report because there is still an open report.<br /> لا يمكن إضافة تقرير جديد لهذا الرقم لأن تقريراً سابقاً لا يزال مفتوحاً");
 1455:  
 1456:                                         reportViewModel.InsertButtonEnabled = false;
 1457:                                     }
 1458:                                 }
 1459:                                 else
 1460:                                 {
 1461:                                     reportViewModel.InsertResult.AddError("Service and ServiceType hidden labels are missing");
 1462:                                 }
 1463:                             }
 1464:                             else
 1465:                             {
 1466:                                 reportViewModel.InsertResult.AddError("Contact phone is missing (رقم مراجعة المتصل مفقود)");
 1467:                             }
 1468:                         }
 1469:                         else
 1470:                         {
 1471:                             reportViewModel.InsertResult.AddError("Contact name is missing (اسم المتصل مفقود)");
 1472:                         }
 1473:                     }
 1474:                     else
 1475:                     {
 1476:                         reportViewModel.InsertResult.AddError("Detail is missing (وصف العطل مفقود)");
 1477:                     }
 1478:                 }
 1479:                 else
 1480:                 {
 1481:                     reportViewModel.InsertResult.AddError("Number format is incorrect or does not exist.<br /> (تركيب الرقم غير صحيح أو الرقم غير موجود ضمن الخدمة)");
 1482:                 }
 1483:             }
 1484:             else
 1485:             {
 1486:                 reportViewModel.InsertResult.AddError("No input was entered (لم يتم إدخال أي شيء)");
 1487:             }
 1488:  
 1489:             reportViewModel.InsertedReportList = Ia.Dn.Cl.Models.Data.Report.ReadSingleAsList(reportViewModel.ReportId);
 1490:         }
 1491:  
 1492:         ////////////////////////////////////////////////////////////////////////////
 1493:         ////////////////////////////////////////////////////////////////////////////
 1494:     }
 1495:  
 1496:     ////////////////////////////////////////////////////////////////////////////
 1497:     ////////////////////////////////////////////////////////////////////////////
 1498: }