private void LoadTable()
{
string str = string.Empty;
string NoData = "No Data";
string preparedBy = string.Empty;
string excption_message = "Server Error cann't load data";
List <Treatment_Detial> List_Fill_D = db.Treatment_Detial.ToList();
if (SessionWrapper.LoggedUser.Language_id == 1)
{
NoData = "لا يوجد بيانات";
excption_message = "خطاء في السيرفر لم يتمكن من تحميل البيانات";
}
try
{
Total.Text = treatmentList.Count.ToString();
if (treatmentList.Count == 0)
{
str += "<tr><td colspan='7' style='text-align:center'>" + NoData + "</td></tr>";
}
for (int i = 0; i < treatmentList.Count; i++)
{
str += "<tr>";
str += "<td style='text-align:center;vertical-align:center;'>" + (i + 1) + "</td>";
if (treatmentList[i].Treatment_Keywork == "inbox")
{
str += "<td style='font-size:25px;text-align:center;color:#00c3da;vertical-align:center;'><i class='icofont icofont-inbox'></i></td>";
}
else
{
str += "<td style='font-size:25px;text-align:center;color:orange;vertical-align:center;'><i class='icofont icofont-send-mail'></i></td>";
}
string subject = treatmentList[i].Treatment_Subject;
if (subject.Length > 26)
{
str += "<td style='vertical-align:center;'>" + subject.Substring(0, 25) + "...</td>";
}
else
{
str += "<td style='vertical-align:center;'>" + subject + "</td>";
}
if (SessionWrapper.LoggedUser.Language_id == 1)
{
try { preparedBy = structureList.FirstOrDefault(x => x.Structure_Id == treatmentList[i].Prepared_Administration_Id).Structure_Name_Ar; } catch { preparedBy = " - "; }
}
else
{
try { preparedBy = structureList.FirstOrDefault(x => x.Structure_Id == treatmentList[i].Prepared_Administration_Id).Structure_Name_En; } catch { preparedBy = " - "; }
}
str += "<td style='text-align:center;vertical-align:center;'>" + preparedBy + "</td>";
if (SessionWrapper.LoggedUser.Language_id == 1)
{
str += "<td style='text-align:center;vertical-align:center;'>" + treatmentList[i].Employee_Structure.Employee.Employee_Name_Ar + "</td>";
}
else
{
str += "<td style='text-align:center;vertical-align:center;'>" + treatmentList[i].Employee_Structure.Employee.Employee_Name_En + "</td>";
}
str += "<td>" + treatmentList[i].Treatment_Date + "</td>";
if (SessionWrapper.LoggedUser.Language_id == 1)
{
str += "<td style='text-align:center;vertical-align:center;'><label class='" + treatmentList[i].Treatment_Confidentiality.Css_Class + "'>" + treatmentList[i].Treatment_Confidentiality.Treatment_Confidentiality_Name_Ar + "</label></td>";
}
else
{
str += "<td style='text-align:center;vertical-align:center;'><label class='" + treatmentList[i].Treatment_Confidentiality.Css_Class + "'>" + treatmentList[i].Treatment_Confidentiality.Treatment_Confidentiality_Name_En + "</label></td>";
}
// Check if inbox or not (اضفت كلمة انبوكس دي في دالة اللود فوق عشان افرق)
if (treatmentList[i].Treatment_Keywork == "inbox")
{
Treatment_Detial Treat = List_Fill_D.FirstOrDefault(x => x.Treatment_Id == treatmentList[i].Treatment_Id && x.To_Employee_Structure_Id == SessionWrapper.EmpStructure);
if (Treat != null)
{
if (Treat.Assignment_Status_Id == 3)
{
if (treatmentList[i].Treatment_Mother == 0)
{
str += "<td style='text-align:center;vertical-align:center;'><a href='../../Pages/Treatment/ShowTreatment.aspx?getTreatmentId=" + treatmentList[i].Treatment_Id + "&getTabId=3&getTreatmentDetialId=" + Treat.Treatment_Detial_Id + "' style='font-size:25px;text-align:center;'><i style='color:#452a74;' class='icofont icofont-eye-alt'></i></a></td></tr>";
}
else
{
str += "<td style='text-align:center;vertical-align:center;'><a href='../../Pages/Treatment/ShowTreatment.aspx?getTreatmentId=" + treatmentList[i].Treatment_Mother + "&getTabId=3&getTreatmentDetialId=" + Treat.Treatment_Detial_Id + "' style='font-size:25px;text-align:center;'><i style='color:#452a74;' class='icofont icofont-eye-alt'></i></a></td></tr>";
}
}
else
{
if (treatmentList[i].Treatment_Mother == 0)
{
str += "<td style='text-align:center;vertical-align:center;'><a href='../../Pages/Treatment/ShowTreatment.aspx?getTreatmentId=" + treatmentList[i].Treatment_Id + "&getTabId=1&getTreatmentDetialId=" + Treat.Treatment_Detial_Id + "' style='font-size:25px;text-align:center;'><i style='color:#452a74;' class='icofont icofont-eye-alt'></i></a></td></tr>";
}
else
{
str += "<td style='text-align:center;vertical-align:center;'><a href='../../Pages/Treatment/ShowTreatment.aspx?getTreatmentId=" + treatmentList[i].Treatment_Mother + "&getTabId=1&getTreatmentDetialId=" + Treat.Treatment_Detial_Id + "' style='font-size:25px;text-align:center;'><i style='color:#452a74;' class='icofont icofont-eye-alt'></i></a></td></tr>";
}
}
}
}
else
{
if (treatmentList[i].Treatment_Mother == 0)
{
str += "<td style='text-align:center;vertical-align:center;'><a href='../../Pages/Treatment/ShowTreatment.aspx?getTreatmentId=" + treatmentList[i].Treatment_Id + "&getTabId=2' style='font-size:25px;text-align:center;'><i style='color:#452a74;' class='icofont icofont-eye-alt'></i></a></td></tr>";
}
else
{
str += "<td style='text-align:center;vertical-align:center;'><a href='../../Pages/Treatment/ShowTreatment.aspx?getTreatmentId=" + treatmentList[i].Treatment_Mother + "&getTabId=2' style='font-size:25px;text-align:center;'><i style='color:#452a74;' class='icofont icofont-eye-alt'></i></a></td></tr>";
}
}
}
}
catch (Exception er)
{
str += "<tr><td colspan='7' style='text-align:center;color:red;'>" + excption_message + "</td></tr>";
}
txtData.Text = str;
}
private bool saveTreatment()
{
if (validationForm())
{
try
{
db.Configuration.LazyLoadingEnabled = false;
var newTreatment = db.Treatment_Master.Create();
newTreatment.Create_Date = DateTime.Now;
newTreatment.Update_Date = DateTime.Now;
newTreatment.Treatment_Date = DateTime.Parse(treatmentDate.Text);
newTreatment.Treatment_Procedure_Id = int.Parse(standardProcedure.SelectedValue);
newTreatment.Treatment_Type_Id = int.Parse(typeTreatment.SelectedValue);
newTreatment.Prepared_Administration_Id = int.Parse(preparedManagement.SelectedValue);
newTreatment.Treatment_Class_Id = int.Parse(classificationSubject.SelectedValue);
newTreatment.Treatment_Subject = subjectTreatement.Text;
newTreatment.Treatment_Confidentiality_Id = int.Parse(secretLevel.SelectedValue);
newTreatment.Treatment_Priority_id = int.Parse(priorityLevel.SelectedValue);
newTreatment.Treatment_Delivery_Id = int.Parse(speedUp.SelectedValue);
newTreatment.Treatment_Body = speech.Text;
newTreatment.Required_Reply = checkRequiredReply();
newTreatment.Treatment_Status_Id = 1;
newTreatment.Treatment_Number = getTreatmentNumber();
newTreatment.From_Employee_Structure_Id = currentStructureUserId;
newTreatment.Treatment_Mother = 0;
if (checkRequiredReply())
{
newTreatment.Required_Reply_Date = DateTime.Parse(replyDate.Text);
}
/////////////////////////////////////// Start Insert Send To /////////////////////////////////////
Treatment_Detial treatmentDetial;
var selectedItemsTreatmentTo = from li in treatmentTo.Items.Cast <ListItem>()
where li.Selected == true
select li;
foreach (var itemTreatmentTo in selectedItemsTreatmentTo)
{
treatmentDetial = new Treatment_Detial();
treatmentDetial.To_Employee_Structure_Id = int.Parse(itemTreatmentTo.Value);
treatmentDetial.Parent = 0;
treatmentDetial.Assignment_Status_Id = 1;
treatmentDetial.Is_Read = false;
treatmentDetial.Is_Delete = false;
treatmentDetial.Treatment_Copy_To = false;
newTreatment.Treatment_Detial.Add(treatmentDetial);
}
/////////////////////////////////////// End Insert Send To /////////////////////////////////////
/////////////////////////////////////// Start Insert Copy To /////////////////////////////////////
var selectedItemsTreatmentCopyTo = from li in treatmentCopyTo.Items.Cast <ListItem>()
where li.Selected == true
select li;
foreach (var itemTreatmentCopyTo in selectedItemsTreatmentCopyTo)
{
treatmentDetial = new Treatment_Detial();
treatmentDetial.To_Employee_Structure_Id = int.Parse(itemTreatmentCopyTo.Value);
treatmentDetial.Parent = 0;
treatmentDetial.Assignment_Status_Id = 1;
treatmentDetial.Is_Read = false;
treatmentDetial.Is_Delete = false;
treatmentDetial.Treatment_Copy_To = true;
newTreatment.Treatment_Detial.Add(treatmentDetial);
}
/////////////////////////////////////// End Insert Copy To /////////////////////////////////////
db.Treatment_Master.Add(newTreatment);
db.SaveChanges();
treatmentId = newTreatment.Treatment_Id;
/////////////////////////////////////// Start Add Attachment /////////////////////////////////////
Attachment addAtachtmentTreatment;
foreach (HttpPostedFile postfiles in addAttachments1111.PostedFiles)
{
if (postfiles.ContentLength > 0 && postfiles.FileName != "")
{
addAtachtmentTreatment = new Attachment();
addAtachtmentTreatment.Attachment_Path = UploadFile(postfiles);
addAtachtmentTreatment.Attachment_Name = postfiles.FileName;
addAtachtmentTreatment.Treatment_Id = newTreatment.Treatment_Id;
addAtachtmentTreatment.Attachment_Type = 1;
db.Attachments.Add(addAtachtmentTreatment);
db.SaveChanges();
}
}
/////////////////////////////////////// End Add Attachment /////////////////////////////////////
if (insertNotification(newTreatment.Treatment_Id))
{
}
LogData = "data:" + JsonConvert.SerializeObject(newTreatment, logFileModule.settings);
logFileModule.logfile(1009, "إضافة معاملة جديدة", "Create New Treatment", LogData);
}
catch (Exception exceptionLog)
{
string exceptionStackTrace = exceptionLog.StackTrace;
string exceptionGetType = exceptionLog.GetType().ToString();
string exceptionMessage = exceptionLog.Message;
string exceptionData = "data:{\"StackTrace\":\"" + exceptionStackTrace + "\",\"GetType\":\"" + exceptionGetType + "\",\"Message\":\"" + exceptionMessage + "\"}";
logFileModule.logfile(1025, "حدث خطأ في حفظ المعاملة", "An error occurred in saving the transaction", exceptionData);
if (SessionWrapper.LoggedUser.Language_id == 1)
{
messageForm = "حدث خطأ في حفظ البيانات في النظام";
}
else
{
messageForm = "Erorr to save data in system";
}
return(false);
}
return(true);
}
else
{
return(false);
}
}
private bool saveTreatment()
{
if (validationForm())
{
try
{
var newTreatment = db.Treatments.Create();
newTreatment.Create_Date = DateTime.Now;
newTreatment.Update_Date = DateTime.Now;
newTreatment.Treatment_Date = DateTime.Parse(treatmentDate.Text);
newTreatment.Treatment_Procedure_Id = int.Parse(standardProcedure.SelectedValue);
newTreatment.Treatment_Type_Id = int.Parse(typeTreatment.SelectedValue);
newTreatment.Prepared_Administration_Id = int.Parse(preparedManagement.SelectedValue);
newTreatment.Treatment_Class_Id = int.Parse(classificationSubject.SelectedValue);
newTreatment.Treatment_Subject = subjectTreatement.Text;
newTreatment.Treatment_Confidentiality_Id = int.Parse(secretLevel.SelectedValue);
newTreatment.Treatment_Priority_id = int.Parse(priorityLevel.SelectedValue);
newTreatment.Treatment_Delivery_Id = int.Parse(speedUp.SelectedValue);
newTreatment.Treatment_Body = speech.Text;
newTreatment.Required_Reply = checkRequiredReply();
newTreatment.Treatment_Status_Id = 1;
newTreatment.Treatment_Number = getTreatmentNumber();
newTreatment.From_Employee_Structure_Id = currentStructureUserId;
if (checkRequiredReply())
{
newTreatment.Required_Reply_Date = DateTime.Parse(replyDate.Text);
}
/////////////////////////////////////// Start Insert To /////////////////////////////////////
Treatment_Detial treatmentDetial;
for (int i = 0; i < treatmentTo.Items.Count; i++)
{
if (treatmentTo.Items[i].Selected)
{
treatmentDetial = new Treatment_Detial();
treatmentDetial.To_Employee_Structure_Id = int.Parse(treatmentTo.Items[i].Value);
treatmentDetial.Parent = 0;
treatmentDetial.Assignment_Status_Id = 1;
treatmentDetial.Is_Read = false;
treatmentDetial.Is_Delete = false;
treatmentDetial.Treatment_Copy_To = false;
newTreatment.Treatment_Detial.Add(treatmentDetial);
}
}
/////////////////////////////////////// End Insert To /////////////////////////////////////
/////////////////////////////////////// Start Insert Copy To /////////////////////////////////////
for (int i = 0; i < treatmentCopyTo.Items.Count; i++)
{
if (treatmentCopyTo.Items[i].Selected)
{
treatmentDetial = new Treatment_Detial();
treatmentDetial.To_Employee_Structure_Id = int.Parse(treatmentCopyTo.Items[i].Value);
treatmentDetial.Parent = 0;
treatmentDetial.Assignment_Status_Id = 1;
treatmentDetial.Is_Read = false;
treatmentDetial.Is_Delete = false;
treatmentDetial.Treatment_Copy_To = true;
newTreatment.Treatment_Detial.Add(treatmentDetial);
}
}
/////////////////////////////////////// End Insert Copy To /////////////////////////////////////
db.Treatments.Add(newTreatment);
db.SaveChanges();
}
catch { messageForm = "Erorr to save data in system"; return(false); }
return(true);
}
else
{
return(false);
}
}
