protected void Page_Load(object sender, EventArgs e) { if (SessionWrapper.LoggedUser == null) { Response.Redirect("~/Pages/Setting/Auth/Login.aspx"); } int EmpStructureID = SessionWrapper.EmpStructure; int UserID = SessionWrapper.LoggedUser.Employee_Id; treatmentList = db.Treatment_Master.Where(x => x.From_Employee_Structure_Id == EmpStructureID).ToList(); treatmentDList = db.Treatment_Detial.Where(x => x.To_Employee_Structure_Id == EmpStructureID).ToList(); for (int i = 0; i < treatmentDList.Count; i++) { Treatment_Master treat = treatmentList.FirstOrDefault(x => x.Treatment_Id == treatmentDList[i].Treatment_Id); if (treat == null) { treatmentDList[i].Treatment_Master.Treatment_Keywork = "inbox"; treatmentList.Add(treatmentDList[i].Treatment_Master); } } treatmentList = treatmentList.OrderByDescending(x => x.Create_Date).ToList(); structureList = db.Structures.ToList(); btnSearch.Text = FieldNames.getFieldName("AdvancedSearch-Search", "Search"); if (!IsPostBack) { FillDropDownLists(); //LoadTable(); } }
protected void Page_Load(object sender, EventArgs e) { if (SessionWrapper.LoggedUser == null) { Response.Redirect("~/Pages/Setting/Auth/Login.aspx"); } List <Employee_Structure> stList = db.Employee_Structure.Where(x => x.Employee_Id == SessionWrapper.LoggedUser.Employee_Id).ToList(); try { int treatmentId = 0; if (int.TryParse(Request["getTreatmentId"], out treatmentId) && treatmentId > 0) { Treatment_Master treat_Master = db.Treatment_Master.Find(treatmentId); TreatmentReport report = new TreatmentReport(); report.RequestParameters = false; report.Parameters["TreatmentID"].Value = treatmentId; report.Parameters["TreatmentNumber"].Value = treat_Master.Treatment_Number; report.Parameters["PreparedStructure"].Value = treat_Master.Structure.Structure_Name_En; report.Parameters["TreatmentDate"].Value = treat_Master.Create_Date; report.Parameters["TreatmentSubject"].Value = treat_Master.Treatment_Subject; report.Parameters["body"].Value = "<div style='text-align: left !important;direction: ltr !important;'>" + treat_Master.Treatment_Body + "<div>"; report.Parameters["CurrentUser"].Value = SessionWrapper.LoggedUser.Employee_Name_En; try { report.Parameters["CurrentManagment"].Value = stList[0].Structure.Structure_Name_En; } catch { } TreatmentASPxDocumentViewer.Report = report; } } catch (Exception er) { } }
private bool insertNotification(int treatmentIdNotf) { try { using (ECMSEntities dbEcms = new ECMSEntities()) { Treatment_Master treatmentMasterNotf = new Treatment_Master(); treatmentMasterNotf = dbEcms.Treatment_Master.FirstOrDefault(x => x.Treatment_Id == treatmentIdNotf && x.Required_Reply == true); if (treatmentMasterNotf != null) { List <Treatment_Detial> listTreatmentDetialNotf = new List <Treatment_Detial>(); listTreatmentDetialNotf = treatmentMasterNotf.Treatment_Detial.Where(x => x.Treatment_Copy_To == false).ToList <Treatment_Detial>(); string linkNotif = ""; for (int i = 0; i < listTreatmentDetialNotf.Count; i++) { linkNotif = "../../../../Pages/Treatment/ShowTreatment.aspx?getTreatmentId=" + treatmentIdNotf + "&getTabId=4&getTreatmentDetialId=" + 0 + "&getNotificationId="; Notification_Master notificationMaster = new Notification_Master(); notificationMaster = dbEcms.Notification_Master.Create(); notificationMaster.Notification_Date = DateTime.Now; notificationMaster.Is_Read = false; notificationMaster.From_Employee_Structure_Id = listTreatmentDetialNotf[i].To_Employee_Structure_Id; notificationMaster.To_Employee_Structure_Id = currentStructureUserId; notificationMaster.Master_Id = treatmentIdNotf; notificationMaster.Notification_Description_Ar = "لم يتم الرد علي المعاملة"; notificationMaster.Notification_Description_En = "The transaction was not answered"; notificationMaster.Notification_Link = linkNotif; notificationMaster.Is_Show_Reply = true; notificationMaster.Date_Show_Reply = treatmentMasterNotf.Required_Reply_Date; notificationMaster.Notification_Show_Id = 4; dbEcms.Notification_Master.Add(notificationMaster); dbEcms.SaveChanges(); } } } return(true); } catch { return(false); } }
private bool loadListViewCompleteTreatment() { using (ECMSEntities db = new ECMSEntities()) { try { string yourHTMLstring = "<table id='issue-list-table1' class='table dt-responsive' style='width: 100%;border-collapse: collapse !important'>" + "<thead class='text-left' style='display: none;'>" + "<tr>" + "<th>Expand</th>" + "<th>Actions</th>" + "<th>Status</th>" + "<th>English Name</th>" + "<th>Arabic Name</th>" + "</tr>" + "</thead>" + "<tbody class='text-left'>"; completeTreatment.Controls.Add(new LiteralControl(yourHTMLstring)); List <Treatment_Detial> treatmentDetial = new List <Treatment_Detial>(); //treatmentDetial = db.Treatment_Detial.Where(x => x.To_Employee_Structure_Id == currentStructureUserId && (x.Assignment_Status_Id == 1 || x.Assignment_Status_Id == 2)).OrderByDescending(x => x.Treatment_Detial_Id).ToList<Treatment_Detial>(); treatmentDetial = getTreatmentDetailComplete(); Treatment_Master oneTreatmentMaster; int motherTreatmentId = 0; int oneTreatmentDetailId = 0; string langTreatmentPriorityName = "", langEmployeeName = "", langTreatmentConfidentialityName = ""; for (int i = 0; i < treatmentDetial.Count; i++) { oneTreatmentDetailId = treatmentDetial[i].Treatment_Detial_Id; treatmentDetial[i] = db.Treatment_Detial.FirstOrDefault(x => x.Treatment_Detial_Id == oneTreatmentDetailId); if (treatmentDetial[i] != null) { oneTreatmentMaster = new Treatment_Master(); motherTreatmentId = (int)treatmentDetial[i].Treatment_Master.Treatment_Mother; if (motherTreatmentId == 0) { oneTreatmentMaster = treatmentDetial[i].Treatment_Master; } else { oneTreatmentMaster = db.Treatment_Master.First(x => x.Treatment_Id == motherTreatmentId); } if (SessionWrapper.LoggedUser.Language_id == 1) { langTreatmentPriorityName = treatmentDetial[i].Treatment_Master.Treatment_Priority.Treatment_Priority_Name_Ar; langEmployeeName = getSubString(treatmentDetial[i].Treatment_Master.Employee_Structure.Employee.Employee_Name_Ar, 20); langTreatmentConfidentialityName = treatmentDetial[i].Treatment_Master.Treatment_Confidentiality.Treatment_Confidentiality_Name_Ar; } else { langTreatmentPriorityName = treatmentDetial[i].Treatment_Master.Treatment_Priority.Treatment_Priority_Name_En; langEmployeeName = getSubString(treatmentDetial[i].Treatment_Master.Employee_Structure.Employee.Employee_Name_En, 20); langTreatmentConfidentialityName = treatmentDetial[i].Treatment_Master.Treatment_Confidentiality.Treatment_Confidentiality_Name_En; } yourHTMLstring = "<tr class='unread'>" + "<td style='width: 4%;'>" + "<div class='check-star'>" + "<a href='#!' data-toggle='tooltip' data-placement='top' data-trigger='hover' title='" + langTreatmentPriorityName + "'>" + "<i class='" + treatmentDetial[i].Treatment_Master.Treatment_Priority.Css_Class + "' style='font-size: 150%;'></i>" + "</a>" + "</div>" + "</td>" + "<td style='width: 20%;'><a href='ShowTreatment.aspx?getTreatmentId=" + oneTreatmentMaster.Treatment_Id + "&getTabId=3&getTreatmentDetialId=" + treatmentDetial[i].Treatment_Detial_Id + "' class='email-name'>" + langEmployeeName + "</a></td>" + "<td style='width: 60%;'><a href='ShowTreatment.aspx?getTreatmentId=" + oneTreatmentMaster.Treatment_Id + "&getTabId=3&getTreatmentDetialId=" + treatmentDetial[i].Treatment_Detial_Id + "' class='email-name'>" + getSubString(treatmentDetial[i].Treatment_Master.Treatment_Subject, 90) + "</a></td>" + "<td style='width: 7%;' class='email-tag'><a href='ShowTreatment.aspx?getTreatmentId=" + oneTreatmentMaster.Treatment_Id + "&getTabId=3&getTreatmentDetialId=" + treatmentDetial[i].Treatment_Detial_Id + "'><label class='" + treatmentDetial[i].Treatment_Master.Treatment_Confidentiality.Css_Class + "'>" + langTreatmentConfidentialityName + "</label></a></td>" + "<td style='width: 9%;' class='email-time'>" + Date_Different((DateTime)treatmentDetial[i].Treatment_Master.Create_Date) + "</td>" + "</tr>"; completeTreatment.Controls.Add(new LiteralControl(yourHTMLstring)); } } yourHTMLstring = "</tbody></table>"; completeTreatment.Controls.Add(new LiteralControl(yourHTMLstring)); return(true); } catch (Exception eee) { return(false); } } }