public async Task <ActionResult> CreateBusiness(IEnumerable <HttpPostedFileBase> files, [Bind(Include = "BusinessProcesID,WalktroughID,DocumentNo,DocumentName,FolderName,BPMID")] BusinessProces businessProces)
{
if (ModelState.IsValid)
{
HttpServerUtilityBase server = Server;
int i = 0;
foreach (var file in files)
{
if (file != null)
{
i = i + 1;
bool addFile = filesTransact.addFile(businessProces.DocumentNo, i, file, server);
}
}
string username = User.Identity.Name;
db.BusinessProcess.Add(businessProces);
await db.SaveChangesAsync();
int wallid = Convert.ToInt32(businessProces.WalktroughID);
BusinessProces bus = new BusinessProces();
auditTransact.CreateAuditTrail("Create", wallid, "BusinessProcessDetail", bus, businessProces, username);
TempData["message"] = "BPM detail successfully created!";
return(RedirectToAction("CreateBusiness", new { id = businessProces.BPMID, walkid = businessProces.WalktroughID }));
//return RedirectToAction("Create");
}
//ViewBag.WalktroughID = new SelectList(db.Walktroughs, "WalktroughID", "Remarks", businessProces.WalktroughID);
return(View(businessProces));
}
public async Task <ActionResult> Create([Bind(Include = "FeedbackID,FieldWorkID")] Feedback feedback)
{
if (ModelState.IsValid)
{
db.Feedbacks.Add(feedback);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
//ViewBag.AuditPlanningMemorandumID = new SelectList(db.AuditPlanningMemorandums, "AuditPlanningMemorandumID", "NomerAPM", feedback.AuditPlanningMemorandumID);
return(View(feedback));
}
public async Task <ActionResult> Create([Bind(Include = "ReportingID,LetterOfCommandID,NomorLaporan,MemoDescription,SummaryDescription,Bab01Title,Bab01SubTitle,Bab01Description,Bab02Title,Bab02SubTitle,Bab02Description")] Reporting reporting)
{
if (ModelState.IsValid)
{
db.Reportings.Add(reporting);
await db.SaveChangesAsync();
TempData["message"] = "Report successfully created!";
return(RedirectToAction("Index"));
}
return(View(reporting));
}
public async Task <ActionResult> Create([Bind(Include = "BusinessProcesID,BPMID,DocumentNo,DocumentName,FolderName")] BusinessProces businessProces)
{
if (ModelState.IsValid)
{
db.BusinessProcess.Add(businessProces);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
//ViewBag.WalktroughID = new SelectList(db.Walktroughs, "WalktroughID", "Remarks", businessProces.WalktroughID);
return(View(businessProces));
}
public ActionResult FeedBackURL(ConsultingQuestionerAnswers qa)
{
ConsultingFeedbackQuestionDetail fqd = db.ConsultingFeedbackQuestionDetails.Find(qa.ConsultingFeedBackQuestionDetailID);
fqd.Status = "Submitted";
db.Entry(fqd).State = EntityState.Modified;
db.SaveChangesAsync();
TempData["message"] = "Consulting Feedback successfully updated!";
return(RedirectToAction("Index"));
}
public ActionResult Create(string period1, string period2, string empchair, string empmoderator, string empreporter, string empmember, string letterno, [Bind(Include = "NotulenEntryMeetingID,AuditPlanningMemorandumID,Tujuan,TimeConsumableStartDate,TimeConsumableEndDate,Place,EmployeeChairmanID,EmployeeModeratorID,EmployeeReporterID,EmployeeMemberID,Opening,ExposurePlan,LetterOfCommandID")] NotulenEntryMeeting notulenEntryMeeting, IEnumerable <HttpPostedFileBase> files)
{
if (ModelState.IsValid)
{
IQueryable <LetterOfCommand> loc = db.LetterOfCommands.Where(p => p.NomorSP.Equals(letterno));
int LetterOfCommandID = 0;
if (loc.Count() > 0 || letterno != null)
{
LetterOfCommandID = loc.Select(p => p.LetterOfCommandID).FirstOrDefault();
}
notulenEntryMeeting.LetterOfCommandID = LetterOfCommandID;
notulenEntryMeeting.TimeConsumableStartDate = Convert.ToDateTime(period1);
notulenEntryMeeting.TimeConsumableEndDate = Convert.ToDateTime(period2);
IQueryable <Employee> emp = db.Employees.Where(p => p.Name.Equals(empchair));
int empId = 0;
if (emp.Count() > 0 || emp != null)
{
empId = emp.Select(p => p.EmployeeID).FirstOrDefault();
}
notulenEntryMeeting.EmployeeChairmanID = empId;
IQueryable <Employee> emp2 = db.Employees.Where(p => p.Name.Equals(empmoderator));
int empId2 = 0;
if (emp2.Count() > 0 || emp2 != null)
{
empId2 = emp2.Select(p => p.EmployeeID).FirstOrDefault();
}
notulenEntryMeeting.EmployeeModeratorID = empId2;
IQueryable <Employee> emp3 = db.Employees.Where(p => p.Name.Equals(empreporter));
int empId3 = 0;
if (emp3.Count() > 0 || emp3 != null)
{
empId3 = emp3.Select(p => p.EmployeeID).FirstOrDefault();
}
notulenEntryMeeting.EmployeeReporterID = empId3;
IQueryable <Employee> emp4 = db.Employees.Where(p => p.Name.Equals(empmember));
int empId4 = 0;
if (emp4.Count() > 0 || emp4 != null)
{
empId4 = emp4.Select(p => p.EmployeeID).FirstOrDefault();
}
notulenEntryMeeting.EmployeeMemberID = empId4;
string username = User.Identity.Name;
db.NotulenEntryMeetings.Add(notulenEntryMeeting);
db.SaveChangesAsync();
HttpServerUtilityBase server = Server;
int i = 0;
foreach (var file in files)
{
if (file != null)
{
i = i + 1;
var notulen = "notulen";
var id = notulenEntryMeeting.NotulenEntryMeetingID;
bool addFile = filesTransact.addFile(notulen + id, i, file, server);
}
}
NotulenEntryMeeting no = new NotulenEntryMeeting();
auditTransact.CreateAuditTrail("Create", notulenEntryMeeting.NotulenEntryMeetingID, "NotulenEntryMeeting", no, notulenEntryMeeting, username);
TempData["message"] = "Notulen Entry Meeting successfully created!";
return(RedirectToAction("Index"));
}
ViewBag.AuditPlanningMemorandumID = new SelectList(db.AuditPlanningMemorandums, "AuditPlanningMemorandumID", "NomerAPM", notulenEntryMeeting.AuditPlanningMemorandumID);
return(View(notulenEntryMeeting));
}
public async Task <ActionResult> Create(string submit, [Bind(Include = "QuestionerID,Name,Type,Value,Status")] Questioner questioner, string Textarea, string Textbox, string Rating, string from, string to)
{
if (ModelState.IsValid)
{
if (questioner.Type == "TextBox")
{
questioner.Value = Textbox;
}
else if (questioner.Type == "TextArea")
{
questioner.Value = Textarea;
}
else
{
questioner.Value = from + ";" + to;
}
string user = submit.Contains("By") ? submit.Split('y')[1] : String.Empty;
if (submit == "Save" || submit == "Send Back")
{
questioner.Status = "Draft";
}
else if (submit == "Approve")
{
questioner.Status = "Approve";
}
else if (submit == "Submit For Review By" + user)
{
questioner.Status = "Pending for Review by" + user;
}
else if (submit == "Submit For Approve By" + user)
{
questioner.Status = "Pending for Approve by" + user;
string baseUrl = Request.Url.GetLeftPart(UriPartial.Authority);
List <string> CIAUserIds = Request.GetOwinContext().GetUserManager <ApplicationRoleManager>().Roles.Where(p => p.Name.Equals(user.Trim())).FirstOrDefault().Users.Select(p => p.UserId).ToList();
List <Employee> CIAEmpList = new List <Employee>();
if (CIAUserIds.Count() > 0)
{
var CIAUsers = Request.GetOwinContext().GetUserManager <ApplicationUserManager>().Users.Where(p => (CIAUserIds.Contains(p.Id))).ToList();
foreach (var CIAUser in CIAUsers)
{
Employee emp = db.Employees.Where(p => p.Email.Equals(CIAUser.Email)).FirstOrDefault();
string emailContent = "Dear {0}, <BR/><BR/>Questioner : {1} need your approval. Please click on this <a href=\"{2}\" title=\"Questioner\">link</a> to show the Questioner.<BR/><BR/><BR/> Regards,<BR/><BR/> ePatria Team";
string url = baseUrl + "/Questioners/Details/" + questioner.QuestionerID;
//emailTransact.SentEmailApproval(emp.Email, emp.Name, questioner.Name, emailContent, url);
}
}
}
db.Questioners.Add(questioner);
await db.SaveChangesAsync();
string username = User.Identity.Name;
Questioner qus = new Questioner();
auditTransact.CreateAuditTrail("Create", questioner.QuestionerID, "Questioner", qus, questioner, username);
ReviewRelationMaster rrm = new ReviewRelationMaster();
string page = "questioner";
rrm.Description = page + questioner.QuestionerID;
db.ReviewRelationMasters.Add(rrm);
db.SaveChanges();
TempData["message"] = "Questioner successfully created!";
return(RedirectToAction("Index"));
}
return(View(questioner));
}
public async Task <ActionResult> Edit(string submit, string Status, string[] Dasar, string[] Untuk, string[] Tembusan, string activid, string memberName, string[] member, string pic, string supervisor, string leader, string nomer, [Bind(Include = "LetterOfCommandID,NomorSP,Status,Remarks,AssuranceType,Date_Start,Date_End,Menimbang,Penutup,AuditPlanningMemorandumID,ActivityID,PICID,SupervisorID,TeamLeaderID,MemberID")] LetterOfCommand letterOfCommand)
{
if (ModelState.IsValid)
{
letterOfCommand.Status = Status;
IQueryable <AuditPlanningMemorandum> apm = db.AuditPlanningMemorandums.Where(p => p.NomerAPM.Equals(nomer));
int apmId = 0;
if (apm.Count() > 0 || apm != null)
{
apmId = apm.Select(p => p.AuditPlanningMemorandumID).FirstOrDefault();
letterOfCommand.AuditPlanningMemorandumID = apmId;
}
letterOfCommand.SupervisorID = supervisor;
letterOfCommand.TeamLeaderID = leader;
letterOfCommand.PICID = pic;
if (member != null)
{
foreach (var mb in member)
{
letterOfCommand.MemberID += mb + ";";
}
}
else
{
letterOfCommand.MemberID += ";";
}
string user = submit.Contains("By") ? submit.Split('y')[1] : String.Empty;
if (submit == "Save")
{
letterOfCommand.Status = "Draft";
}
else if (submit == "Send Back")
{
letterOfCommand.Status = HelperController.GetStatusSendback(db, "Surat Perintah", letterOfCommand.Status);
}
else if (submit == "Approve")
{
letterOfCommand.Status = "Approve";
}
else if (submit == "Submit For Review By" + user)
{
letterOfCommand.Status = "Pending for Review by" + user;
}
else if (submit == "Submit For Approve By" + user)
{
letterOfCommand.Status = "Pending for Approve by" + user;
string userToSentEmail = String.Empty;
if (user.Trim() == "CIA")
{
userToSentEmail = letterOfCommand.PICID;
if (userToSentEmail != null)
{
sentSingleEmailSP(userToSentEmail, letterOfCommand);
}
else
{
sentEmailSP(letterOfCommand, user.Trim());
}
}
else if (user.Trim() == "Pengawas")
{
userToSentEmail = letterOfCommand.SupervisorID;
if (userToSentEmail != null)
{
sentSingleEmailSP(userToSentEmail, letterOfCommand);
}
else
{
sentEmailSP(letterOfCommand, user.Trim());
}
}
else if (user.Trim() == "Ketua Tim")
{
userToSentEmail = letterOfCommand.TeamLeaderID;
if (userToSentEmail != null)
{
sentSingleEmailSP(userToSentEmail, letterOfCommand);
}
else
{
sentEmailSP(letterOfCommand, user.Trim());
}
}
else if (user.Trim() == "Member")
{
userToSentEmail = letterOfCommand.MemberID;
if (userToSentEmail != null)
{
sentSingleEmailSP(userToSentEmail, letterOfCommand);
}
else
{
sentEmailSP(letterOfCommand, user.Trim());
}
}
}
IQueryable <Activity> act = db.Activities.Where(p => p.Name.Equals(activid));
int activ = 0;
if (act.Count() > 0 || act != null)
{
activ = act.Select(p => p.ActivityID).FirstOrDefault();
}
letterOfCommand.ActivityID = activ;
db.Configuration.ProxyCreationEnabled = false;
LetterOfCommandDetailDasar letterOfCommandDetailDasar = db.LetterOfCommandDetailDasars.AsNoTracking().Where(p => p.LetterOfCommandID == letterOfCommand.LetterOfCommandID).FirstOrDefault();
LetterOfCommandDetailUntuk letterOfCommandDetailUntuk = db.LetterOfCommandDetailUntuks.AsNoTracking().Where(p => p.LetterOfCommandID == letterOfCommand.LetterOfCommandID).FirstOrDefault();
LetterOfCommandDetailTembusan letterOfCommandDetailTembusan = db.LetterOfCommandDetailTembusans.AsNoTracking().Where(p => p.LetterOfCommandID == letterOfCommand.LetterOfCommandID).FirstOrDefault();
letterOfCommandDetailDasar.LetterOfCommandID = letterOfCommand.LetterOfCommandID;
letterOfCommandDetailDasar.Dasar = null;
if (Dasar != null)
{
foreach (var ds in Dasar)
{
letterOfCommandDetailDasar.Dasar += ds + ";";
}
}
else
{
letterOfCommandDetailDasar.Dasar = ";";
}
letterOfCommandDetailUntuk.LetterOfCommandID = letterOfCommand.LetterOfCommandID;
letterOfCommandDetailUntuk.Untuk = null;
if (Untuk != null)
{
foreach (var uk in Untuk)
{
letterOfCommandDetailUntuk.Untuk += uk + ";";
}
}
else
{
letterOfCommandDetailUntuk.Untuk = ";";
}
letterOfCommandDetailTembusan.LetterOfCommandID = letterOfCommand.LetterOfCommandID;
letterOfCommandDetailTembusan.Tembusan = null;
if (Tembusan != null)
{
foreach (var ts in Tembusan)
{
letterOfCommandDetailTembusan.Tembusan += ts + ";";
}
}
else
{
letterOfCommandDetailTembusan.Tembusan = ";";
}
string username = User.Identity.Name;
LetterOfCommand oldData = db.LetterOfCommands.AsNoTracking().Where(p => p.LetterOfCommandID.Equals(letterOfCommand.LetterOfCommandID)).FirstOrDefault();
LetterOfCommandDetailDasar oldDataDasar = db.LetterOfCommandDetailDasars.AsNoTracking().Where(p => p.ID.Equals(letterOfCommandDetailDasar.ID)).FirstOrDefault();
LetterOfCommandDetailUntuk oldDataUntuk = db.LetterOfCommandDetailUntuks.AsNoTracking().Where(p => p.ID.Equals(letterOfCommandDetailUntuk.ID)).FirstOrDefault();
LetterOfCommandDetailTembusan oldDataTembusan = db.LetterOfCommandDetailTembusans.AsNoTracking().Where(p => p.ID.Equals(letterOfCommandDetailTembusan.ID)).FirstOrDefault();
auditTransact.CreateAuditTrail("Update", letterOfCommand.LetterOfCommandID, "LetterOfCommand", oldData, letterOfCommand, username);
auditTransact.CreateAuditTrail("Update", letterOfCommandDetailDasar.ID, "LetterOfCommandDasar", oldDataDasar, letterOfCommandDetailDasar, username);
auditTransact.CreateAuditTrail("Update", letterOfCommandDetailUntuk.ID, "LetterOfCommandUntuk", oldDataUntuk, letterOfCommandDetailUntuk, username);
auditTransact.CreateAuditTrail("Update", letterOfCommandDetailTembusan.ID, "LetterOfCommandTembusan", oldDataTembusan, letterOfCommandDetailTembusan, username);
db.Entry(letterOfCommandDetailDasar).State = EntityState.Modified;
db.Entry(letterOfCommandDetailUntuk).State = EntityState.Modified;
db.Entry(letterOfCommandDetailTembusan).State = EntityState.Modified;
db.Entry(letterOfCommand).State = EntityState.Modified;
await db.SaveChangesAsync();
TempData["message"] = "Letter Of Command successfully updated!";
return(RedirectToAction("Index"));
}
ViewBag.PreliminaryID = new SelectList(db.Preliminaries, "PreliminaryID", "Type", letterOfCommand.PreliminaryID);
return(View(letterOfCommand));
}
