public ActionResult DeleteConfirmed(int id)
{
MissionAuthorization missionAuthorization = db.MissionAuthorizations.Find(id);
db.MissionAuthorizations.Remove(missionAuthorization);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: MissionAuthorizations/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MissionAuthorization missionAuthorization = db.MissionAuthorizations.Find(id);
if (missionAuthorization == null)
{
return(HttpNotFound());
}
return(View(missionAuthorization));
}
// GET: MissionAuthorizations/SuperEdit/5
public ActionResult SuperEdit(int?id, int?id2, int?drd)
{
var staffs = db.staffs.Include(s => s.contract_details).Include(s => s.contract_type).Include(s => s.Country_office).Include(s => s.functional_title).Include(s => s.staff2).Include(s => s.sub_office).Include(s => s.unit).Include(s => s.country).Include(s => s.governorate);
staffs = staffs.Where(s => s.staff_email.Contains(User.Identity.Name + "@wfp.org"));
//ViewBag.staffid = new SelectList(db.staffs, "staffs.First().staffid", staffs.First().staff_email);
ViewBag.staffid22 = staffs.First().staffid;
//ViewBag.RDORDRDDate = DateTime.Now;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
//string passingURL = "/MissionAuthorizations/Index/";
//return Redirect(passingURL);
}
//if (id2 != ViewBag.staffid22)
//{
// //return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
// string passingURL = "/MissionAuthorizations/Index/";
// return Redirect(passingURL);
//}
MissionAuthorization missionAuthorization = db.MissionAuthorizations.Find(id);
if (missionAuthorization == null)
{
return(HttpNotFound());
}
if (drd.ToString() == "1")
{
ViewBag.RDORDRDDate = DateTime.Now;
ViewBag.RDORDRDSignature = missionAuthorization.RDORDRDSignature;
ViewBag.staffid = staffs.First().staffid;
return(View(missionAuthorization));
}
ViewBag.RDORDRDSignature = missionAuthorization.RDORDRDSignature;
ViewBag.RDORDRDDate = missionAuthorization.RDORDRDDate;
ViewBag.staffid = staffs.First().staffid;
return(View(missionAuthorization));
}
public ActionResult Edit([Bind(Include = "MissionID,staffid,FromDate,ToDate,MissionItinerary,funding,ClearedBySupervisor,MissionObjective,ExpectedOutputs,Achievements,FollowUp,SignatureDate")] MissionAuthorization missionAuthorization)
{
if (ModelState.IsValid)
{
db.Entry(missionAuthorization).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
var staffs = db.staffs.Include(s => s.contract_details).Include(s => s.contract_type).Include(s => s.Country_office).Include(s => s.functional_title).Include(s => s.staff2).Include(s => s.sub_office).Include(s => s.unit).Include(s => s.country).Include(s => s.governorate);
staffs = staffs.Where(s => s.staff_email.Contains(User.Identity.Name + "@wfp.org"));
ViewBag.staffid = staffs.First().staffid;
ViewBag.FirstNme = staffs.First().staff_first_name;
ViewBag.LastName = staffs.First().staff_last_name;
return(View(missionAuthorization));
}
// GET: MissionAuthorizations/Edit/5
public ActionResult Edit(int?id, int?id2, int?drd, int?loginid)
{
var staffs = db.staffs.Include(s => s.contract_details).Include(s => s.contract_type).Include(s => s.Country_office).Include(s => s.functional_title).Include(s => s.staff2).Include(s => s.sub_office).Include(s => s.unit).Include(s => s.country).Include(s => s.governorate);
staffs = staffs.Where(s => s.staff_email.Contains(User.Identity.Name + "@wfp.org"));
//ViewBag.staffid = new SelectList(db.staffs, "staffs.First().staffid", staffs.First().staff_email);
ViewBag.staffid22 = staffs.First().staffid;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
//string passingURL = "/MissionAuthorizations/Index/";
//return Redirect(passingURL);
}
if (id2 != ViewBag.staffid22)
{
//return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
//string passingURL = "/MissionAuthorizations/SuperEdit/";
//return Redirect(passingURL? id);
return(RedirectToAction("SuperEdit", "MissionAuthorizations", new { id = id, id2 = id2, drd = drd, loginid = loginid }));
}
MissionAuthorization missionAuthorization = db.MissionAuthorizations.Find(id);
if (missionAuthorization == null)
{
return(HttpNotFound());
}
ViewBag.staffid = staffs.First().staffid;
return(View(missionAuthorization));
}
public ActionResult Create(Models.MailModel objModelMail, [Bind(Include = "MissionID,staffid,FromDate,ToDate,MissionItinerary,funding,ClearedBySupervisor,MissionObjective,ExpectedOutputs,FollowUp,SignatureDate")] MissionAuthorization missionAuthorization)
{
if (ModelState.IsValid)
{
db.MissionAuthorizations.Add(missionAuthorization);
try
{
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
}
var staffs = db.staffs.Include(s => s.contract_details).Include(s => s.contract_type).Include(s => s.Country_office).Include(s => s.functional_title).Include(s => s.staff2).Include(s => s.sub_office).Include(s => s.unit).Include(s => s.country).Include(s => s.governorate);
staffs = staffs.Where(s => s.staff_email.Contains(User.Identity.Name + "@wfp.org"));
//ViewBag.staffid = new SelectList(db.staffs, "staffs.First().staffid", staffs.First().staff_email);
ViewBag.staffid = staffs.First().staffid;
ViewBag.staffid2 = staffs.First().staff_first_name;
ViewBag.FirstName = staffs.First().staff_first_name;
ViewBag.LastName = staffs.First().staff_last_name;
ViewBag.Unit = staffs.First().unit.unit_description_english;
var staffsupervisor = staffs.First().staff_supervisorid;
var supers = db.staffs.Include(d => d.contract_details).Include(d => d.contract_type).Include(d => d.Country_office).Include(d => d.functional_title).Include(d => d.staff2).Include(d => d.sub_office).Include(d => d.unit).Include(d => d.country).Include(d => d.governorate);
supers = supers.Where(d => d.staffid == staffsupervisor);
var to = supers.First().staff_email;
MailMessage mail = new MailMessage();
mail.To.Add(to);
mail.From = new MailAddress("*****@*****.**");
mail.Subject = "Mission Authorization Form";
string Body = "Request : Mission Mission ID : " + missionAuthorization.MissionID + " <br> " + " From :" + staffs.First().staff_first_name + " " + staffs.First().staff_last_name + "<br><br>" + " Mission Information" + "<br><br>" + " From :" + missionAuthorization.FromDate + " To :" + missionAuthorization.ToDate +
"<br>Funding :" + missionAuthorization.funding + " " + "Objective :" + missionAuthorization.MissionObjective;
mail.Body = Body;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtprelay.global.wfp.org";
smtp.Port = 25;
smtp.UseDefaultCredentials = true;
//smtp.Credentials = new System.Net.NetworkCredential
//("ahmed.badr", "Survivor2323");// Enter seders User name and password
//smtp.EnableSsl = true;
smtp.Send(mail);
//string from = "*****@*****.**";
////Replace this with your own correct Gmail Address
//string to = "*****@*****.**";
////Replace this with the Email Address
////to whom you want to send the mail
//System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage();
//mail.To.Add(to);
//mail.From = new MailAddress(from);
//mail.Subject = "This is a test mail";
//mail.SubjectEncoding = System.Text.Encoding.UTF8;
//mail.Body = "This is Email Body Text";
//mail.BodyEncoding = System.Text.Encoding.UTF8;
//mail.IsBodyHtml = true;
//mail.Priority = MailPriority.High;
//SmtpClient client = new SmtpClient("smtp.WFPEGSIMSP01.global.wfp.org", 25);
////Add the Creddentials- use your own email id and password
//System.Net.NetworkCredential nt =
//new System.Net.NetworkCredential("ahmed.badr", "Survivor2323");
//client.Port = 25; // Gmail works on this port
//client.EnableSsl = false; //Gmail works on Server Secured Layer
//client.UseDefaultCredentials = true;
//client.Credentials = nt;
//client.Send(mail);
// var body = "<p>Email From: {0} ({1})</p><p>Message:</p><p>{2}</p>";
// var message = new MailMessage();
// message.To.Add(new MailAddress("*****@*****.**")); // replace with valid value
// message.From = new MailAddress("*****@*****.**"); // replace with valid value
// message.Subject = "Your email subject";
// message.Body = string.Format(body,"hhh","hjkjh","kjlkjl");
// message.IsBodyHtml = true;
// using (var smtp = new SmtpClient())
// {
// var credential = new NetworkCredential
// {
// UserName = "******", // replace with valid value
// Password = "******" // replace with valid value
// };
// smtp.Credentials = credential;
// smtp.Host = "smtprelay.global.wfp.org";
// smtp.Port = 25;
// smtp.EnableSsl = true;
// smtp.SendMailAsync(message);
return(RedirectToAction("Index"));
// }
//}
}
//ViewBag.staffid = User.Identity.GetUserName() + "@wfp.org";
return(RedirectToAction("Create"));
}
