public ActionResult DeleteConfirmed(int id)
{
RequestIssue requestıssue = db.RequestIssues.Find(id);
db.RequestIssues.Remove(requestıssue);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /RequestIssue/Edit/5
public ActionResult Edit(int id)
{
RequestIssue requestıssue = db.RequestIssues.Find(id);
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));
}
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));
}
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 Validate(int id)
{
RequestIssue requestissue = db.RequestIssues.Find(id);
if ((requestissue.UserReq.UserName == User.Identity.Name) && (requestissue.ValidationStateID != 1))
{
requestissue.ValidationStateID = 1;
db.Entry(requestissue).State = EntityState.Modified;
db.SaveChanges();
if (requestissue.SendEmail == true)
{
MembershipUser currentuser_ = new UserRepository().GetUser(User.Identity.Name);
SendEmail(new MailAddress("*****@*****.**"), new MailAddress(currentuser_.Email), "[Klimasan HelpDesk] İş isteğiniz hakkında.", "İsteğiniz doğrulanarak kayıt altına alınmıştır.Tarih: " + DateTime.Now.ToString() + " - İş No: #" + (requestissue.RequestIssueID).ToString() + ". İyi çalışmalar dileriz.");
}
return(RedirectToAction("Index"));
}
else
{
ViewBag.UserError = "Bu İş için doğrulama için yetkisi yok ya da zaten doğrulanmış.";
}
return(RedirectToAction("Index"));
}
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 CopyProject(FormCollection formcollection)
{
DateTime extendDate = DateTime.Parse(formcollection["ExtendDate"]);
int projectid_ = int.Parse(formcollection["projectId"]);
Project myproject = db.Projects.AsNoTracking().Include(p => p.RequestIssues).Include(p => p.Locations).Include(p => p.CorporateAccounts).Include(p => p.Personnels).Where(i => i.ProjectID == projectid_).SingleOrDefault();
double extendAsDays = extendDate.Subtract(myproject.StartDate).Days;
Project newproject = new Project
{
Description = myproject.Description,
cUserID = myproject.cUserID,
EndDate = myproject.EndDate.Value.AddDays(extendAsDays),
RequestStateID = 1,
StartDate = myproject.StartDate.AddDays(extendAsDays),
TimeStamp = DateTime.Now,
UserID = myproject.UserID,
Locations = new List <Location>(),
CorporateAccounts = new List <CorporateAccount>(),
Personnels = new List <Personnel>(),
RequestIssues = new List <RequestIssue>()
};
db.Projects.Add(newproject);
db.SaveChanges();
foreach (Location loc_ in myproject.Locations.ToList())
{
newproject.Locations.Add(db.Locations.Find(loc_.LocationID));
}
foreach (CorporateAccount corp_ in myproject.CorporateAccounts.ToList())
{
newproject.CorporateAccounts.Add(db.CorporateAccounts.Find(corp_.CorporateAccountID));
}
foreach (Personnel pers_ in myproject.Personnels.ToList())
{
newproject.Personnels.Add(db.Personnels.Find(pers_.PersonnelID));
}
db.SaveChanges();
foreach (RequestIssue rq_ in myproject.RequestIssues.ToList())
{
//var copyoldnotrackrq_ = db.RequestIssues.Include(p=>p.Locations).Include(p=>p.CorporateAccounts).Include(p=>p.Personnels).Include(p=>p.Projects).Where(i=>i.RequestIssueID==rq_.RequestIssueID).SingleOrDefault();
RequestIssue newrq_ = db.RequestIssues.Include(p => p.Locations).Include(p => p.CorporateAccounts).Include(p => p.Personnels).Include(p => p.Projects).Where(i => i.RequestIssueID == rq_.RequestIssueID).SingleOrDefault();
var _mylocations = newrq_.Locations.ToList();
var _mycorps = newrq_.CorporateAccounts.ToList();
var _mypersonnels = newrq_.Personnels.ToList();
var _myprojects = newrq_.Projects.ToList();
db.Entry(newrq_).State = EntityState.Detached;
db.Entry(newrq_).State = EntityState.Added;
db.SaveChanges();
RequestIssue myrqformanys_ = db.RequestIssues.Find(newrq_.RequestIssueID);
myrqformanys_.StartDate = myrqformanys_.StartDate.AddDays(extendAsDays);
myrqformanys_.EndDate = myrqformanys_.EndDate.Value.AddDays(extendAsDays);
foreach (var _loc in _mylocations)
{
myrqformanys_.Locations.Add(_loc);
}
foreach (var _pers in _mypersonnels)
{
myrqformanys_.Personnels.Add(_pers);
}
foreach (var _corp in _mycorps)
{
myrqformanys_.CorporateAccounts.Add(_corp);
}
myrqformanys_.Projects.Add(newproject);
/*
* newrq_.StartDate.AddDays(extendAsDays);
* newrq_.EndDate.Value.AddDays(extendAsDays);
* newrq_.Locations = copyoldnotrackrq_.Locations;
* newrq_.Personnels = copyoldnotrackrq_.Personnels;
* newrq_.Projects = copyoldnotrackrq_.Projects;
* newrq_.CorporateAccounts = copyoldnotrackrq_.CorporateAccounts;
*/
//db.Entry(newrq_).State = EntityState.Modified;
db.SaveChanges();
//newproject.RequestIssues.Add(db.RequestIssues.Find(newrq_.RequestIssueID));
// newproject.RequestIssues.Add(rq_);
}
return(RedirectToAction("Index"));
}
public ResponseResult<decimal> Issue(RequestIssue request)
{
var problem = PrimeNumberTable.PickN(3).Select(pn => (decimal)pn).Aggregate((lhs, rhs) => lhs * rhs);
return new ResponseResult<decimal>(problem);
}
//
// GET: /RequestIssue/Details/5
public ViewResult Details(int id)
{
RequestIssue requestıssue = db.RequestIssues.Find(id);
return(View(requestıssue));
}
//
// GET: /RequestIssue/Delete/5
public ActionResult Delete(int id)
{
RequestIssue requestıssue = db.RequestIssues.Find(id);
return(View(requestıssue));
}
public ActionResult Update(string xisid, string xtip, string xgun, string xdk, string xtumGun, string ms)
{
//tarih manipualsyonu
RequestIssue rq = db.RequestIssues.Find(int.Parse(xisid));
//değişiklikler:
//öteleme sadece enddate icin geçerli bi durum olacak
try
{
//baslangic mi bitis mi? <-- bu kontrol iptal. resize hiç bir zaman kullanmayacagiz.
// cunkü her taşımamız resize olacak zaten..
//rq.StartDate = rq.StartDate.AddDays(double.Parse(xgun));
//rq.StartDate = rq.StartDate.AddMinutes(double.Parse(xdk));
if (rq.Pre1EndDate == null)
{
rq.Pre1EndDate = rq.EndDate;
rq.EndDate = rq.EndDate.Value.AddDays(double.Parse(xgun));
rq.EndDate = rq.EndDate.Value.AddMinutes(double.Parse(xdk));
}
else if (rq.Pre2EndDate == null)
{
rq.Pre2EndDate = rq.EndDate;
rq.EndDate = rq.EndDate.Value.AddDays(double.Parse(xgun));
rq.EndDate = rq.EndDate.Value.AddMinutes(double.Parse(xdk));
}
else
{
return(Content("Termin Oteleme Limiti Dolmustur"));
}
if (xtumGun == "E")
{
rq.IsAllDay = true;
}
else
{
rq.IsAllDay = false;
}
db.Entry(rq).State = EntityState.Modified;
db.SaveChanges();
if (rq.SendEmail == true)
{
string softwaretitle = db.ParameterSettings.AsNoTracking().Where(i => i.ParameterSettingID == 14).SingleOrDefault().ParameterValue;
string mailsonucstr = SendEmail(new MailAddress(rq.User.Email), new MailAddress(rq.UserReq.Email), "[" + softwaretitle + "] #" + rq.RequestIssueID.ToString() + " no'lu İş isteğiniz hakkında.", "İş İsteğinizin ön görülen başlangıç ve bitiş tarihleri değiştirilmiş/güncellenmiştir. İsteğinizin son durumu görmek isterseniz; " + Url.Action("Editp", "RequestIssue", new { id = rq.RequestIssueID, show = "A", page = 1 }, "http") + " adresini ziyaret ediniz. Tarih: " + DateTime.Now.ToString() + ". İyi çalışmalar dileriz.", rq.Personnel.Email, false);
if (mailsonucstr != "OK")
{
ViewBag.Bilgilendirme = "Mail Gönderiminde Hata: " + mailsonucstr;
}
else
{
ViewBag.Bilgilendirme = "Mail Başarıyla Gönderildi";
}
}
return(Content("Güncelleme başarılı"));
}
catch
{
return(Content("Hata Oluştu"));
}
}
public ResponseResult <decimal> Issue(RequestIssue request)
{
var problem = PrimeNumberTable.PickN(3).Select(pn => (decimal)pn).Aggregate((lhs, rhs) => lhs * rhs);
return(new ResponseResult <decimal>(problem));
}
