/// <summary>
/// 获取系统日志文件
/// </summary>
/// <param name="systemId"></param>
/// <param name="page"></param>
/// <param name="perPage"></param>
/// <param name="date"></param>
/// <returns></returns>
public static Tuple <IEnumerable <SystemLogFile>, int> GetSystemLogFiles(int systemId, int page, int perPage, DateTime date)
{
var logDir = LogHelper.GetSystemClientLogDir(systemId, date);
IEnumerable <SystemLogFile> logFiles = null;
int count = 0;
if (!Directory.Exists(logDir))
{
logFiles = new SystemLogFile[] { };
count = 0;
}
else
{
var allFiles = new DirectoryInfo(logDir).GetFiles("*.log", SearchOption.TopDirectoryOnly);
logFiles = from f in allFiles.OrderBy(f => f.Name)
.Skip(perPage * (page - 1)).Take(perPage)
select new SystemLogFile
{
Name = f.Name,
Size = f.Length,
CreationTime = f.CreationTime,
LastWriteTime = f.LastWriteTime
};
count = allFiles.Count();
}
return(Tuple.Create(logFiles, count));
}
public static void UpdateActivation(String value, string selectedIndex, frmMainPage mainScreen)
{
try
{
if (value.Equals("True"))
{
if (clsDatabase_Connection.ExecuteQuery("update tblStudentDetails set StudentStatus='" + value +
"',CreatedBy='" + IMS_System.Properties.Settings.Default.current_staff_id +
"',CreatedDate=GETDATE() where StudentId='" + selectedIndex + "'") == true)
{
if (clsDatabase_Connection.ExecuteQuery("update tblStudentBatchDetails set current_status='" + value +
"',CreatedBy='" + IMS_System.Properties.Settings.Default.current_staff_id +
"',CreatedDate=GETDATE() where StudentId='" + selectedIndex + "' and studentbatchid=(select max(studentbatchid)" +
" from tblStudentBatchDetails where studentid='" + selectedIndex + "')") == false)
{
SystemLogFile.WriteSystemLog("Seudent Batch Details Deactivation Error", "Student Deactivation");
}
mainScreen.SucessMessageShow("Sucessfully Activated", "INFO");
}
else
{
new frmMessageBox("error", "Activate", "You can not Activate this. Some errors occurred!", false, mainScreen).ShowDialog();
}
}
else
{
clsDatabase_Connection.Get_Table("select * from tblStudentDetails A inner join tblStudentBatchDetails B on A.StudentId=B.studentid where A.StudentId='" + selectedIndex + "'");
if (clsDatabase_Connection.objDataSet.Tables[0].Rows.Count > 1)
{
}
new frmMessageBox("question", "Batches", "Selected Students is studying for more batches, would you like to Deactivate all?", true, mainScreen).ShowDialog();
if (IMS_System.Properties.Settings.Default.MessageBoxResults.Equals("Yes"))
{
if (clsDatabase_Connection.ExecuteQuery("update tblStudentDetails set StudentStatus='" + value +
"',CreatedBy='" + IMS_System.Properties.Settings.Default.current_staff_id +
"',CreatedDate=GETDATE() where StudentId='" + selectedIndex + "'") == true)
{
if (clsDatabase_Connection.ExecuteQuery("update tblStudentBatchDetails set current_status='" + value +
"',CreatedBy='" + IMS_System.Properties.Settings.Default.current_staff_id +
"',CreatedDate=GETDATE() where StudentId='" + selectedIndex + "'") == false)
{
SystemLogFile.WriteSystemLog("Seudent Batch Details Deactivation Error - FULL", "Student Deactivation");
}
mainScreen.SucessMessageShow("Sucessfully Deactivated", "INFO");
}
else
{
new frmMessageBox("error", "Deactivate", "You can not Deactivate this. Some errors occurred!", false, mainScreen).ShowDialog();
}
}
else /** no need of deactivation **/ } {
}
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}