public ActionResult Create(RequestIssue requestıssue)
{
if (ModelState.IsValid)
{
requestıssue.TimeStamp = DateTime.Now;
requestıssue.ValidationStateID = 2;
db.RequestIssues.Add(requestıssue);
db.SaveChanges();
return RedirectToAction("Details/" + requestıssue.RequestIssueID.ToString());
}
MembershipUser currentuser_ = new UserRepository().GetUser(User.Identity.Name);
int user_wherecondition = int.Parse((currentuser_.ProviderUserKey).ToString());
ViewBag.RequestTypeID = new SelectList(db.RequestTypes, "RequestTypeID", "Description", requestıssue.RequestTypeID);
ViewBag.LocationID = new SelectList(db.Locations, "LocationID", "Description", requestıssue.LocationID);
ViewBag.InventoryID = new SelectList(db.Inventories, "InventoryID", "Description", requestıssue.InventoryID);
ViewBag.WorkshopID = new SelectList(db.Workshops, "WorkshopID", "Description", requestıssue.WorkshopID);
ViewBag.RequestStateID = new SelectList(db.RequestStates, "RequestStateID", "Description", requestıssue.RequestStateID);
ViewBag.UserReqID = new SelectList(db.Users.Where(x => x.UserId == user_wherecondition), "UserId", "UserName", requestıssue.UserReqID);
ViewBag.UserID = new SelectList(db.Users, "UserId", "UserName", requestıssue.UserID);
ViewBag.ValidationStateID = new SelectList(db.ValidationStates, "ValidationStateID", "Description", requestıssue.ValidationStateID);
return View(requestıssue);
}
public ActionResult Report(RequestIssue requestıssue, FormCollection formcollection)
{
ReportDocument rptH = new ReportDocument();
rptH.FileName = Server.MapPath("~/RDLC/SurveyReport.rpt");
rptH.Refresh();
//rptH.Load();
var value = new ParameterDiscreteValue();
var requests_ = db.RequestIssues.AsNoTracking().Include(p => p.Locations).Include(p => p.Personnels).Include(p => p.CorporateAccounts);
int x_index = 0;
foreach (int req_ in requests_.Select(i => i.RequestIssueID).ToList())
{
value.Value = req_;
rptH.ParameterFields["RequestIDs"].CurrentValues.Add(value);
x_index++;
}
if (x_index == 0)
{
return RedirectToAction("Index", new { custommerr = "Belirttiğiniz Kriterlere Uygun Kayıt(lar) Bulunamadı" });
}
// rptH.SetDataSource([datatable]);
var cd = new System.Net.Mime.ContentDisposition
{
// for example foo.bak
FileName = "rapor_klimasanHelpDeskAnketler.pdf",
// always prompt the user for downloading, set to true if you want
// the browser to try to show the file inline
Inline = false,
};
Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
Response.AppendHeader("Content-Disposition", cd.ToString());
return File(stream, "application/pdf");
}
public ActionResult Edit(RequestIssue requestıssue)
{
if (ModelState.IsValid)
{
db.Entry(requestıssue).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.RequestTypeID = new SelectList(db.RequestTypes, "RequestTypeID", "Description", requestıssue.RequestTypeID);
ViewBag.LocationID = new SelectList(db.Locations, "LocationID", "Description", requestıssue.LocationID);
ViewBag.InventoryID = new SelectList(db.Inventories, "InventoryID", "Description", requestıssue.InventoryID);
ViewBag.WorkshopID = new SelectList(db.Workshops, "WorkshopID", "Description", requestıssue.WorkshopID);
ViewBag.RequestStateID = new SelectList(db.RequestStates, "RequestStateID", "Description", requestıssue.RequestStateID);
ViewBag.UserReqID = new SelectList(db.Users, "UserId", "UserName", requestıssue.UserReqID);
ViewBag.UserID = new SelectList(db.Users, "UserId", "UserName", requestıssue.UserID);
ViewBag.ValidationStateID = new SelectList(db.ValidationStates, "ValidationStateID", "Description", requestıssue.ValidationStateID);
return View(requestıssue);
}