protected decimal CreateReAudit(decimal auditId)
{
decimal reauditId = 0;
PSsqmEntities entities = new PSsqmEntities();
AUDIT oldAudit = EHSAuditMgr.SelectAuditById(entities, auditId);
if (oldAudit != null)
{
// create the copy
PLANT auditPlant = SQMModelMgr.LookupPlant((decimal)oldAudit.DETECT_PLANT_ID);
DateTime localTime = WebSiteCommon.LocalTime(DateTime.UtcNow, auditPlant.LOCAL_TIMEZONE);
AUDIT reAudit = new AUDIT()
{
DETECT_COMPANY_ID = Convert.ToDecimal(oldAudit.DETECT_COMPANY_ID),
DETECT_BUS_ORG_ID = oldAudit.DETECT_BUS_ORG_ID,
DETECT_PLANT_ID = oldAudit.DETECT_PLANT_ID,
DEPT_ID = oldAudit.DEPT_ID,
AUDIT_TYPE = oldAudit.AUDIT_TYPE,
CREATE_DT = localTime,
CREATE_BY = SessionManager.UserContext.Person.FIRST_NAME + " " + SessionManager.UserContext.Person.LAST_NAME,
DESCRIPTION = oldAudit.DESCRIPTION,
CREATE_PERSON = SessionManager.UserContext.Person.PERSON_ID, // do we want to set this to admin?
AUDIT_DT = localTime,
AUDIT_TYPE_ID = oldAudit.AUDIT_TYPE_ID,
AUDIT_PERSON = SessionManager.UserContext.Person.PERSON_ID,
CURRENT_STATUS = "A",
PERCENT_COMPLETE = 0,
TOTAL_SCORE = 0,
AUDITING_ID = auditId
};
entities.AddToAUDIT(reAudit);
entities.SaveChanges();
reauditId = reAudit.AUDIT_ID;
AUDIT_ANSWER answer = null;
List <EHSAuditQuestion> questions = EHSAuditMgr.SelectAuditQuestionList(reAudit.AUDIT_TYPE_ID, 0, auditId);
foreach (var q in questions)
{
answer = new AUDIT_ANSWER()
{
AUDIT_ID = reauditId,
AUDIT_QUESTION_ID = q.QuestionId,
ANSWER_VALUE = "",
ORIGINAL_QUESTION_TEXT = q.QuestionText,
//COMMENT = q.AnswerComment
};
entities.AddToAUDIT_ANSWER(answer);
}
entities.SaveChanges();
}
return(reauditId);
}
static void ScheduleAllAudits()
{
List <AUDIT_SCHEDULER> scheduler = EHSAuditMgr.SelectActiveAuditSchedulers(0, null); // currently, we will select all schedules for all plants
AUDIT audit = null;
List <EHSAuditQuestion> questions = null;
AUDIT_ANSWER answer = null;
decimal auditId = 0;
foreach (AUDIT_SCHEDULER schedule in scheduler)
{
AUDIT_TYPE type = EHSAuditMgr.SelectAuditTypeById(entities, (decimal)schedule.AUDIT_TYPE_ID);
// check that the audit is still active
if (type != null)
{
if (!type.INACTIVE)
{
WriteLine("");
WriteLine("The following " + type.TITLE + " audits were created for Audit Scheduler " + schedule.AUDIT_SCHEDULER_ID + ": ");
// determine the date to schedule, by finding the next occurance of the selected day of the week after the current day
DateTime auditDate = DateTime.Today;
while ((int)auditDate.DayOfWeek != schedule.DAY_OF_WEEK)
{
auditDate = auditDate.AddDays(1);
}
// get the plant
PLANT auditPlant = SQMModelMgr.LookupPlant((decimal)schedule.PLANT_ID);
// for the location, select all people that should get the audit
List <PERSON> auditors = SQMModelMgr.SelectPlantPrivgroupPersonList(auditPlant.PLANT_ID, new string[1] {
schedule.JOBCODE_CD
});
foreach (PERSON person in auditors)
{
// check to see if there is already an audit for this plant/type/date/person
audit = EHSAuditMgr.SelectAuditForSchedule(auditPlant.PLANT_ID, type.AUDIT_TYPE_ID, person.PERSON_ID, auditDate);
if (audit == null)
{
// create audit header
auditId = 0;
audit = new AUDIT()
{
DETECT_COMPANY_ID = Convert.ToDecimal(auditPlant.COMPANY_ID),
DETECT_BUS_ORG_ID = auditPlant.BUS_ORG_ID,
DETECT_PLANT_ID = auditPlant.PLANT_ID,
AUDIT_TYPE = "EHS",
CREATE_DT = DateTime.Now,
CREATE_BY = "Automated Scheduler",
DESCRIPTION = type.TITLE,
// CREATE_PERSON = SessionManager.UserContext.Person.PERSON_ID, // do we want to set this to admin?
AUDIT_DT = auditDate,
AUDIT_TYPE_ID = type.AUDIT_TYPE_ID,
AUDIT_PERSON = person.PERSON_ID,
CURRENT_STATUS = "A",
PERCENT_COMPLETE = 0,
TOTAL_SCORE = 0
};
entities.AddToAUDIT(audit);
entities.SaveChanges();
auditId = audit.AUDIT_ID;
// create audit answer records
questions = EHSAuditMgr.SelectAuditQuestionList(type.AUDIT_TYPE_ID, 0, 0); // do not specify the audit ID
foreach (var q in questions)
{
answer = new AUDIT_ANSWER()
{
AUDIT_ID = auditId,
AUDIT_QUESTION_ID = q.QuestionId,
ANSWER_VALUE = q.AnswerText,
ORIGINAL_QUESTION_TEXT = q.QuestionText,
COMMENT = q.AnswerComment
};
entities.AddToAUDIT_ANSWER(answer);
}
entities.SaveChanges();
// create task record for their calendar
EHSAuditMgr.CreateOrUpdateTask(auditId, person.PERSON_ID, 50, auditDate.AddDays(type.DAYS_TO_COMPLETE), "A");
// send an email
EHSNotificationMgr.NotifyOnAuditCreate(auditId, person.PERSON_ID);
WriteLine(person.LAST_NAME + ", " + person.FIRST_NAME + " - audit added");
}
else
{
WriteLine(person.LAST_NAME + ", " + person.FIRST_NAME + " - audit already exists for this date");
}
}
}
else
{
WriteLine("Adit Type " + schedule.AUDIT_TYPE_ID + " inactive. Audits not created for Scheduler Record " + schedule.AUDIT_SCHEDULER_ID.ToString());
}
}
else
{
WriteLine("Adit Type " + schedule.AUDIT_TYPE_ID + " not found. Audits not created for Scheduler Record " + schedule.AUDIT_SCHEDULER_ID.ToString());
}
}
}
AuditData PopulateByAuditId(decimal aid)
{
AuditData d = new AuditData();
var entities = new PSsqmEntities();
d.audit = EHSAuditMgr.SelectAuditById(entities, aid);
if (d.audit != null)
{
try
{
string plantName = EHSAuditMgr.SelectPlantNameById((decimal)d.audit.DETECT_PLANT_ID);
d.auditLocation = plantName;
d.auditNumber = aid.ToString();
AUDIT_TYPE auditType = EHSAuditMgr.SelectAuditTypeById(entities, d.audit.AUDIT_TYPE_ID);
d.auditType = auditType.TITLE; // do I need this?
decimal auditTypeId = d.audit.AUDIT_TYPE_ID; // if I have all this, why am I redefining it?
decimal companyId = d.audit.DETECT_COMPANY_ID;
if (d.audit.DEPT_ID != null)
{
if (d.audit.DEPT_ID == 0)
{
d.auditDepartment = "Plant Wide";
}
else
{
DEPARTMENT dept = SQMModelMgr.LookupDepartment(entities, (decimal)d.audit.DEPT_ID);
d.auditDepartment = dept.DEPT_NAME;
}
}
var questions = EHSAuditMgr.SelectAuditQuestionList(auditTypeId, 0, aid);
d.questionList = questions;
List <AUDIT_TOPIC> topics = new List <AUDIT_TOPIC>();
AUDIT_TOPIC topic = new AUDIT_TOPIC();
decimal previousTopicId = 0;
foreach (EHSAuditQuestion question in questions)
{
if (question.TopicId != previousTopicId)
{
topic = new AUDIT_TOPIC();
topic.AUDIT_TOPIC_ID = question.TopicId;
topic.TITLE = question.TopicTitle;
topics.Add(topic);
previousTopicId = question.TopicId;
}
}
d.topicList = topics;
// Date/Time
d.auditDate = d.audit.AUDIT_DT.ToShortDateString();
DateTime closeDate = d.audit.AUDIT_DT.AddDays(auditType.DAYS_TO_COMPLETE);
d.auditCloseDate = closeDate.ToShortDateString();
// Description
d.auditDescription = d.audit.DESCRIPTION;
d.auditPerson = SQMModelMgr.LookupPerson(entities, (decimal)d.audit.AUDIT_PERSON, "", false);
// Audit Exception Actions
foreach (TASK_STATUS ac in EHSAuditMgr.GetAuditActionList(aid, 0))
{
//if (ac.RESPONSIBLE_ID.HasValue)
//{
// ac.COMMENTS = SQMModelMgr.FormatPersonListItem(SQMModelMgr.LookupPerson((decimal)ac.RESPONSIBLE_ID, ""));
//}
d.actionList.Add(ac);
}
// not showing the attachments at this point, but not deleting code... just in case
//var files = (from a in entities.ATTACHMENT
// where
// (a.RECORD_ID == aid && a.RECORD_TYPE == 40 && a.DISPLAY_TYPE > 0) &&
// (a.FILE_NAME.ToLower().Contains(".jpg") || a.FILE_NAME.ToLower().Contains(".jpeg") ||
// a.FILE_NAME.ToLower().Contains(".gif") || a.FILE_NAME.ToLower().Contains(".png") ||
// a.FILE_NAME.ToLower().Contains(".bmp"))
// orderby a.RECORD_TYPE, a.FILE_NAME
// select new
// {
// Data = (from f in entities.ATTACHMENT_FILE where f.ATTACHMENT_ID == a.ATTACHMENT_ID select f.ATTACHMENT_DATA).FirstOrDefault(),
// Description = (string.IsNullOrEmpty(a.FILE_DESC)) ? "" : a.FILE_DESC,
// }).ToList();
//if (files.Count > 0)
//{
// d.photoData = new List<byte[]>();
// d.photoCaptions = new List<string>();
// foreach (var f in files)
// {
// d.photoData.Add(f.Data);
// d.photoCaptions.Add(f.Description);
// }
//}
}
catch
{
}
}
return(d);
}
