public ActionResult Edit(SurveyTable surveytable, FormCollection formcollection)
{
if (ModelState.IsValid)
{
//db.SaveChanges();
if (surveytable.IsApproved)
{
return(RedirectToAction("Edit", new { id = surveytable.SurveyTableID }));
}
if (DateTime.Now > surveytable.TimeStamp.AddDays(1))
{
return(RedirectToAction("Edit", new { id = surveytable.SurveyTableID, customerr = "Üzgünüz, bu anketin geçerlilik süresi dolmuştur." }));
}
try
{
string hashconfirm = formcollection["HashkeyConfirm"];
var mysvtable_ = db.SurveyTables.AsNoTracking().Where(i => i.SurveyTableID == surveytable.SurveyTableID).SingleOrDefault();
if (mysvtable_.HashKey.Equals(hashconfirm))
{
var mysvtemplate_ = db.SurveyTemplates.Where(i => i.SurveyTemplateID == surveytable.SurveyTemplateID).Include(p => p.SurveyRecords).SingleOrDefault();
foreach (SurveyRecord mysurvrecord in mysvtemplate_.SurveyRecords.ToList())
{
if (mysurvrecord.SurveyRecordTypeID == 1)
{
mysurvrecord.Score = int.Parse(formcollection[mysurvrecord.SurveyRecordID.ToString() + "_Score"]);
}
else if (mysurvrecord.SurveyRecordTypeID == 2)
{
mysurvrecord.ApprovalStatus = bool.Parse(formcollection[mysurvrecord.SurveyRecordID.ToString() + "_ApprovalStatus"].Split(',')[0]);
}
mysurvrecord.Note = formcollection[mysurvrecord.SurveyRecordID.ToString() + "_Note"];
}
db.SaveChanges();
db.Entry(surveytable).State = EntityState.Modified;
surveytable.HashKey = hashconfirm;
surveytable.IsApproved = true;
surveytable.mTimeStamp = DateTime.Now;
db.SaveChanges();
}
else
{
return(RedirectToAction("Edit", new { id = surveytable.SurveyTableID, customerr = "Şifre Uyumsuz. Her anket için farklı şifre üretilmektedir, lütfen elinizdeki şifrenin doğruluğunu kontrol edin." }));
}
}
catch (Exception exx)
{
return(RedirectToAction("Edit", new { id = surveytable.SurveyTableID, customerr = "Üzgünüz bir hata oldu.(Detaylar :" + exx.Message + ")" }));
}
return(RedirectToAction("Edit", new { id = surveytable.SurveyTableID }));
}
ViewBag.SurveyTemplateID = new SelectList(db.SurveyTemplates, "SurveyTemplateID", "Description", surveytable.SurveyTemplateID);
ViewBag.RequestIssueID = new SelectList(db.RequestIssues, "RequestIssueID", "DetailedDescription", surveytable.RequestIssueID);
return(View(surveytable));
}
public ActionResult Edit(InventoryOwnership ınventoryownership)
{
if (ModelState.IsValid)
{
db.Entry(ınventoryownership).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ınventoryownership));
}
public ActionResult Edit(SurveyNode surveynode)
{
if (ModelState.IsValid)
{
db.Entry(surveynode).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(surveynode));
}
public ActionResult Edit(ValidationState validationstate)
{
if (ModelState.IsValid)
{
db.Entry(validationstate).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(validationstate));
}
public ActionResult Edit(ParameterSetting parametersetting)
{
if (ModelState.IsValid)
{
db.Entry(parametersetting).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(parametersetting));
}
public ActionResult Edit(CorporateType corporatetype)
{
if (ModelState.IsValid)
{
db.Entry(corporatetype).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(corporatetype));
}
public ActionResult Edit(User user)
{
if (ModelState.IsValid)
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Edit(WorkshopPermission workshoppermission)
{
if (ModelState.IsValid)
{
db.Entry(workshoppermission).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.WorkshopID = new SelectList(db.Workshops, "WorkshopID", "Description", workshoppermission.WorkshopID);
return(View(workshoppermission));
}
public ActionResult Edit(Location location)
{
if (ModelState.IsValid)
{
db.Entry(location).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ValidationStateID = new SelectList(db.ValidationStates, "ValidationStateID", "Description", location.ValidationStateID);
return(View(location));
}
public ActionResult Edit(MaterialCategory materialcategory)
{
if (ModelState.IsValid)
{
db.Entry(materialcategory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ParentMaterialCategoryID = new SelectList(db.MaterialCategories, "MaterialCategoryID", "Description", materialcategory.ParentMaterialCategoryID);
ViewBag.ValidationStateID = new SelectList(db.ValidationStates, "ValidationStateID", "Description", materialcategory.ValidationStateID);
return(View(materialcategory));
}
public ActionResult Edit(Payment payment)
{
if (ModelState.IsValid)
{
db.Entry(payment).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CorporateAccountID = new SelectList(db.CorporateAccounts, "CorporateAccountID", "Title", payment.CorporateAccountID);
ViewBag.RequestIssueID = new SelectList(db.RequestIssues, "RequestIssueID", "DetailedDescription", payment.RequestIssueID);
return(View(payment));
}
public ActionResult Edit(CorporateAccount corporateaccount)
{
if (ModelState.IsValid)
{
db.Entry(corporateaccount).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CorporateTypeID = new SelectList(db.CorporateTypes, "CorporateTypeID", "Description", corporateaccount.CorporateTypeID);
ViewBag.UserID = new SelectList(db.Users, "UserId", "UserName", corporateaccount.UserID);
ViewBag.ValidationStateID = new SelectList(db.ValidationStates, "ValidationStateID", "Description", corporateaccount.ValidationStateID);
return(View(corporateaccount));
}
public ActionResult Edit(Personnel personnel)
{
if (ModelState.IsValid)
{
db.Entry(personnel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LocationID = new SelectList(db.Locations, "LocationID", "Description", personnel.LocationID);
ViewBag.UserID = new SelectList(db.Users, "UserID", "FullName", personnel.UserID);
ViewBag.ValidationStateID = new SelectList(db.ValidationStates, "ValidationStateID", "Description", personnel.ValidationStateID);
return(View(personnel));
}
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 Edit(Inventory ınventory)
{
if (ModelState.IsValid)
{
db.Entry(ınventory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LocationID = new SelectList(db.Locations, "LocationID", "Description", ınventory.LocationID);
ViewBag.CorporateAccountID = new SelectList(db.CorporateAccounts.Where(e => e.CorporateTypeID == 1), "CorporateAccountID", "Title", ınventory.CorporateAccountID);
ViewBag.ValidationStateID = new SelectList(db.ValidationStates, "ValidationStateID", "Description", ınventory.ValidationStateID);
ViewBag.InventoryOwnershipID = new SelectList(db.InventoryOwnerships, "InventoryOwnershipID", "Description", ınventory.InventoryOwnershipID);
ViewBag.CorporateAccountServiceID = new SelectList(db.CorporateAccounts.Where(e => e.CorporateTypeID == 2), "CorporateAccountID", "Title", ınventory.CorporateAccountServiceID);
return(View(ınventory));
}
public ActionResult Edit(int id, FormCollection formCollection, string selectedParent)
{
var rtToUpdate = db.RequestTypes.Where(i => i.RequestTypeID == id).Single();
if (ModelState.IsValid)
{
rtToUpdate.Description = formCollection["Description"];
try
{
rtToUpdate.ParentRequestTypeId = int.Parse(formCollection["selectedParent"]);
}
catch
{
rtToUpdate.ParentRequestTypeId = null;
}
db.Entry(rtToUpdate).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(rtToUpdate));
}
public ActionResult Edit(User user, FormCollection formcollection)
{
if (ModelState.IsValid)
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
//roles bosalt
User user_ = db.Users.Include(p => p.Roles).Include(p => p.Workshops).Include(p => p.Modules).Include(p => p.UserGroups).Include(p => p.CustomPermissions).Where(i => i.UserId == user.UserId).SingleOrDefault();
user_.Roles.Clear();
user_.UserGroups.Clear();
user_.Workshops.Clear();
user_.Modules.Clear();
user_.CustomPermissions.Clear();
db.SaveChanges();
if (formcollection["RoleID"] != null)
{
foreach (var role_int in formcollection["RoleID"].Split(',').ToList())
{
try
{
int role_index = int.Parse(role_int.ToString());
var role_ = db.Roles.Find(role_index);
role_.Users.Add(user_);
}
catch
{ }
db.SaveChanges();
}
}
if (formcollection["WorkshopMultiSelectID"] != null)
{
foreach (var workshop_int in formcollection["WorkshopMultiSelectID"].Split(',').ToList())
{
try
{
int workshop_index = int.Parse(workshop_int.ToString());
var workshop_ = db.Workshops.Find(workshop_index);
workshop_.Users.Add(user_);
}
catch
{ }
db.SaveChanges();
}
}
if (formcollection["ModuleID"] != null)
{
foreach (var module_int in formcollection["ModuleID"].Split(',').ToList())
{
try
{
int module_index = int.Parse(module_int.ToString());
var module_ = db.Modules.Find(module_index);
module_.Users.Add(user_);
}
catch
{ }
db.SaveChanges();
}
}
if (formcollection["UserGroupID"] != null)
{
foreach (var usergroup_int in formcollection["UserGroupID"].Split(',').ToList())
{
try
{
int usergroup_index = int.Parse(usergroup_int.ToString());
var usergroup_ = db.UserGroups.Find(usergroup_index);
usergroup_.Users.Add(user_);
}
catch
{ }
db.SaveChanges();
}
}
if (formcollection["CustomPermissionID"] != null)
{
foreach (var custom_int in formcollection["CustomPermissionID"].Split(',').ToList())
{
try
{
int custom_index = int.Parse(custom_int.ToString());
var customperm_ = db.CustomPermissions.Find(custom_index);
customperm_.Users.Add(user_);
}
catch
{ }
db.SaveChanges();
}
}
}
return(RedirectToAction("Edit", new { username_ = user.UserName }));
}
public ActionResult Edit(Project project, FormCollection formcollection)
{
if (ModelState.IsValid)
{
db.Entry(project).State = EntityState.Modified;
db.SaveChanges();
//locations bosalt
Project project_ = db.Projects.Include(p => p.Locations).Include(p => p.Personnels).Include(p => p.CorporateAccounts).Where(i => i.ProjectID == project.ProjectID).SingleOrDefault();
project_.Locations.Clear();
project_.Personnels.Clear();
project_.CorporateAccounts.Clear();
db.SaveChanges();
if (formcollection["LocationID"] != null)
{
foreach (var location_ in formcollection["LocationID"].Split(',').ToList())
{
try
{
int location_index = int.Parse(location_.ToString());
var x_location = db.Locations.Find(location_index);
x_location.Projects.Add(project);
}
catch
{ }
db.SaveChanges();
}
}
if (formcollection["CorporateAccountID"] != null)
{
foreach (var corp_ in formcollection["CorporateAccountID"].Split(',').ToList())
{
try
{
int corporation_index = int.Parse(corp_.ToString());
var x_corp = db.CorporateAccounts.Find(corporation_index);
x_corp.Projects.Add(project);
}
catch
{ }
db.SaveChanges();
}
}
if (formcollection["PersonnelID"] != null)
{
foreach (var pers_ in formcollection["PersonnelID"].Split(',').ToList())
{
try
{
int pers_index = int.Parse(pers_.ToString());
var x_pers = db.Personnels.Find(pers_index);
x_pers.Projects.Add(project);
}
catch
{ }
db.SaveChanges();
}
}
if (formcollection["AddNewRq"] != null)
{
return(RedirectToAction("Create", "RequestIssue", new { projectid = project.ProjectID }));
}
return(RedirectToAction("Index"));
}
ViewBag.RequestStateID = new SelectList(db.RequestStates, "RequestStateID", "Description", project.RequestStateID);
ViewBag.UserID = new SelectList(db.Users, "UserId", "FullName", project.UserID);
ViewBag.cUserID = new SelectList(db.Users, "UserId", "FullName", project.cUserID);
Project project__ = db.Projects.Include(p => p.Locations).Include(p => p.Personnels).Include(p => p.CorporateAccounts).Where(i => i.ProjectID == project.ProjectID).SingleOrDefault();
/*project.Locations = project__.Locations;
* project.CorporateAccounts = project__.CorporateAccounts;
* project.Personnels = project__.Personnels;
*/
ViewBag.LocationID = new MultiSelectList(db.Locations, "LocationID", "CapitalizedDescription", project__.Locations.Select(p => p.LocationID).ToList());
ViewBag.CorporateAccountID = new MultiSelectList(db.CorporateAccounts, "CorporateAccountID", "Title", project__.CorporateAccounts.Select(p => p.CorporateAccountID).ToList());
ViewBag.PersonnelID = new MultiSelectList(db.Personnels, "PersonnelID", "FullName", project__.Personnels.Select(p => p.PersonnelID).ToList());
return(View(project));
}
public ActionResult Edit(SurveyTemplate surveytemplate, FormCollection formcollection)
{
if (ModelState.IsValid)
{
if (db.SurveyTemplates.AsNoTracking().Where(i => i.RequestTypeID == surveytemplate.RequestTypeID && i.PreDefined == true && i.SurveyTemplateID != surveytemplate.SurveyTemplateID).ToList().Count > 0)
{
ViewBag.CustomErr = "İlgili İş tipine ait bir taslak zaten var. Lütfen Başka Bir Tip seçiniz";
return(RedirectToAction("Edit", new { id = surveytemplate.SurveyTemplateID }));
}
db.Entry(surveytemplate).State = EntityState.Modified;
db.SaveChanges();
SurveyTemplate mysurvtemplate_ = db.SurveyTemplates.Include(p => p.SurveyRecords).Where(i => i.SurveyTemplateID == surveytemplate.SurveyTemplateID).SingleOrDefault();
int xindex = 0;
foreach (SurveyNode snode_ in db.SurveyNodes.ToList())
{
try
{
if (bool.Parse(formcollection[snode_.SurveyNodeID.ToString() + "_Remove"].Split(',')[0]))
{
}
else
{
SurveyRecord mysurvrec = db.SurveyTemplates.AsNoTracking().Where(i => i.SurveyTemplateID == surveytemplate.SurveyTemplateID).SingleOrDefault().SurveyRecords.Where(u => u.SurveyNodeID == snode_.SurveyNodeID).SingleOrDefault();
var mysrec = db.SurveyRecords.Find(mysurvrec.SurveyRecordID);
surveytemplate.SurveyRecords.Remove(mysrec);
db.Entry(surveytemplate).State = EntityState.Modified;
//db.SurveyRecords.Remove(mysurvrec);
db.SaveChanges();
KlmsnContext db_ = new KlmsnContext();
var mysrec_forremove = db_.SurveyRecords.Find(mysurvrec.SurveyRecordID);
db_.SurveyRecords.Remove(mysrec_forremove);
db_.SaveChanges();
db_.Dispose();
try
{
if (bool.Parse(formcollection[snode_.SurveyNodeID.ToString() + "_Check"].Split(',')[0]))
{
SurveyRecord newsurvrec = new SurveyRecord {
SurveyNodeID = snode_.SurveyNodeID, OrderNum = xindex, SurveyRecordTypeID = int.Parse(formcollection[snode_.SurveyNodeID.ToString() + "_survrectype"])
};
mysurvtemplate_.SurveyRecords.Add(newsurvrec);
db.SaveChanges();
xindex++;
}
}
catch (Exception ex)
{
ViewBag.CustomErr = ex.Message;
}
}
}
catch
{
try
{
if (bool.Parse(formcollection[snode_.SurveyNodeID.ToString() + "_Check"].Split(',')[0]))
{
SurveyRecord newsurvrec = new SurveyRecord {
SurveyNodeID = snode_.SurveyNodeID, OrderNum = xindex, SurveyRecordTypeID = int.Parse(formcollection[snode_.SurveyNodeID.ToString() + "_survrectype"])
};
mysurvtemplate_.SurveyRecords.Add(newsurvrec);
db.SaveChanges();
xindex++;
}
}
catch (Exception ex)
{
ViewBag.CustomErr = ex.Message;
}
}
xindex++;
}
return(RedirectToAction("Index"));
}
ViewBag.AllSurveyNodes = db.SurveyNodes.ToList();
ViewBag.TheseSurveyRecords = db.SurveyTemplates.Find(surveytemplate.SurveyTemplateID).SurveyRecords.ToList();
ViewBag.RequestTypeID = new SelectList(db.RequestTypes, "RequestTypeID", "Description", surveytemplate.RequestTypeID);
return(View(surveytemplate));
}
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"));
}
}