public ActionResult TimeSheetAdd(Model_TimeSheetAdd model)
{
Tbl_TurnTimeSheet _timesheet = new Tbl_TurnTimeSheet()
{
TTS_Name = model.name,
TTS_MaxSize = model.MaxSize,
TTS_Guid = Guid.NewGuid(),
TTS_TurnID = model.ID,
};
db.Tbl_TurnTimeSheet.Add(_timesheet);
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "عملیات با موفقیت انجام شده";
return(RedirectToAction("Index", new { id = model.ID }));
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "خطا";
return(RedirectToAction("Index", new { id = model.ID }));
}
}
public ActionResult QuestionCreate(Model_QuestionAdd model)
{
Tbl_Question _Question = new Tbl_Question()
{
Question_Title = model.Title,
Question_Guid = Guid.NewGuid(),
Question_FormID = model.ID,
Question_Lie = model.Lie,
Question_FSID = db.Tbl_FormStep.Where(a => a.FS_Guid.ToString() == model.Step).SingleOrDefault().FS_ID,
};
_Question.Tbl_Code = db.Tbl_Code.Where(x => x.Code_Guid.ToString() == model.Type).SingleOrDefault();
db.Tbl_Question.Add(_Question);
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "عملیات با موفقیت انجام شده";
return(RedirectToAction("Index", new { id = model.ID }));
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "خطا";
return(RedirectToAction("Index", new { id = model.ID }));
}
}
public ActionResult CreateForm(Model_FormCreate model)
{
Tbl_Form _Form = new Tbl_Form();
_Form.Form_Name = model.Form_Name;
_Form.Form_Display = model.Form_Display;
_Form.Form_IsActive = true;
_Form.Form_Guid = Guid.NewGuid();
_Form.Form_IsDelete = false;
_Form.Form_ModifyDate = DateTime.Now;
_Form.Form_CreateDate = DateTime.Now;
_Form.Tbl_Course = db.Tbl_Course.Where(a => a.Course_Guid.ToString() == model.Course.ToString()).SingleOrDefault();
db.Tbl_Form.Add(_Form);
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "عملیات با موفقیت انجام شده";
return(RedirectToAction("Index", "Form"));
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "خطا";
return(RedirectToAction("Index"));
}
}
public ActionResult ResponseAdd(Model_ResponseAdd model)
{
Tbl_Response _Response = new Tbl_Response()
{
Response_Guid = Guid.NewGuid(),
Response_QuestionID = model.ID,
Response_Title = model.Title,
Response_Order = model.Order,
Response_IsTrue = model.IsTrue,
Response_Hint = model.Hint,
};
db.Tbl_Response.Add(_Response);
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "عملیات با موفقیت انجام شده";
return(RedirectToAction("Index", new { id = model.ID }));
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "خطا";
return(RedirectToAction("Index", new { id = model.ID }));
}
}
public ActionResult TurnAdd(Model_TurnAdd model)
{
Tbl_Turn _Turn = new Tbl_Turn()
{
Turn_Guid = Guid.NewGuid(),
Turn_Name = model.Titel,
Turn_Description = model.Descripton,
Turn_IsActive = model.Activeness,
};
db.Tbl_Turn.Add(_Turn);
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "عملیات با موفقیت انجام شده";
return(RedirectToAction("Index"));
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "خطا";
return(RedirectToAction("Index"));
}
}
public ActionResult SetActiveness(Model_SetActiveness model)
{
if (ModelState.IsValid)
{
var _TakeTurn = db.Tbl_TakeTurn.Where(x => x.Tbl_Student.Student_ID == model.ID).FirstOrDefault();
if (_TakeTurn != null)
{
_TakeTurn.TT_IsPresent = model.Activeness;
db.Entry(_TakeTurn).State = EntityState.Modified;
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "عملیات با موفقیت انجام شده";
return(RedirectToAction("Index", new { id = _TakeTurn.Tbl_TurnTimeSheet.TTS_ID }));
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "عملیات با موفقیت انجام نشده";
return(HttpNotFound());
}
}
}
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
public ActionResult User_Add(Model_UserAdd model)
{
if (ModelState.IsValid)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Tbl_Login _Login = new Tbl_Login
{
Login_Guid = Guid.NewGuid(),
Login_Email = model.Email,
Login_Name = model.Name,
Login_Family = model.Family,
Login_Mobile = model.Mobile,
Login_RoleID = model.Role,
Login_CreateDate = DateTime.Now,
Login_Modify = DateTime.Now
};
var Salt = Guid.NewGuid().ToString("N");
var SaltPassword = model.Password + Salt;
var SaltPasswordBytes = Encoding.UTF8.GetBytes(SaltPassword);
var SaltPasswordHush = Convert.ToBase64String(SHA512.Create().ComputeHash(SaltPasswordBytes));
_Login.Login_PasswordHash = SaltPasswordHush;
_Login.Login_PasswordSalt = Salt;
db.Tbl_Login.Add(_Login);
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "کاربر جدید با موفقیت اضافه شد.";
return(RedirectToAction("User_List"));
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "کاربر جدید با موفقیت اضافه نشد.";
return(View());
}
}
public ActionResult Index(Model_TakeTurn model)
{
int ID = Convert.ToInt32(model.Sheft);
Tbl_TurnTimeSheet _TurnTimeSheet = db.Tbl_TurnTimeSheet.Where(a => a.TTS_ID == ID).SingleOrDefault();
Tbl_Student _Student = db.Tbl_Student.Where(a => a.Student_Code == User.Identity.Name).SingleOrDefault();
if (_Student.Student_TakeTurn)
{
return(RedirectToAction("index", "Portal"));
}
if (_TurnTimeSheet.TTS_MaxSize > _TurnTimeSheet.Tbl_TakeTurn.Count())
{
Tbl_TakeTurn _TakeTurn = new Tbl_TakeTurn()
{
TT_Guid = Guid.NewGuid(),
TT_StudentID = _Student.Student_ID,
TT_TTSID = _TurnTimeSheet.TTS_ID,
};
db.Tbl_TakeTurn.Add(_TakeTurn);
_Student.Student_TakeTurn = true;
db.Entry(_Student).State = EntityState.Modified;
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "عملیات با موفقیت انجام شده";
return(RedirectToAction("index", "Portal"));
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "خطا";
return(RedirectToAction("Index"));
}
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "ظرفیت این تایم تکمیل شده است";
return(RedirectToAction("Index"));
}
}
public ActionResult Index(Model_StudentInfo model)
{
Tbl_Student _Student = db.Tbl_Student.Where(a => a.Student_Code == User.Identity.Name).SingleOrDefault();
if (_Student.Student_SIID != null || _Student.Student_Info)
{
return(RedirectToAction("ShowForm", "PortalForms", new { ID = "c78afdf3-a647-4e54-95e8-94869576b7e5" }));
}
Tbl_StudentInfo _info = new Tbl_StudentInfo()
{
SI_Name = model.Name,
SI_Family = model.Family,
SI_Phone = model.Phone,
SI_Mobile = model.Mobile,
SI_Email = model.Email,
SI_BirthdayLocation = model.BirthLocation,
SI_BeforeUniversity = model.BeforeUniversity,
SI_Guid = Guid.NewGuid(),
SI_InsuranceCodeID = Convert.ToInt32(model.Insurance),
SI_BloodCodeID = Convert.ToInt32(model.Blood),
SI_GenderCodeID = Convert.ToInt32(model.Gender),
SI_NationalCodeID = Convert.ToInt32(model.National),
SI_HomeTypeCodeID = Convert.ToInt32(model.HomeType),
SI_MarriageCodeID = Convert.ToInt32(model.Marriage),
SI_BranchID = Convert.ToInt32(model.Branch),
SI_BirthYearCodeID = Convert.ToInt32(model.BirthYear),
};
db.Tbl_StudentInfo.Add(_info);
_Student.Tbl_StudentInfo = _info;
_Student.Student_Info = true;
db.Entry(_Student).State = EntityState.Modified;
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "عملیات با موفقیت انجام شده";
return(RedirectToAction("ShowForm", "PortalForms", new { ID = "c78afdf3-a647-4e54-95e8-94869576b7e5" }));
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "خطا";
return(RedirectToAction("Index"));
}
}
public ActionResult Register(Model_Register model)
{
if (!ModelState.IsValid)
{
return(View("Register", model));
}
Tbl_Login _Login = new Tbl_Login();
_Login.Login_Guid = Guid.NewGuid();
_Login.Login_Email = model.Email;
_Login.Login_Name = model.Name;
_Login.Login_Family = model.Family;
_Login.Login_Mobile = model.Mobile;
_Login.Login_RoleID = 1;
_Login.Login_CreateDate = DateTime.Now;
_Login.Login_Modify = DateTime.Now;
var Salt = Guid.NewGuid().ToString("N");
var SaltPassword = model.Password + Salt;
var SaltPasswordBytes = Encoding.UTF8.GetBytes(SaltPassword);
var SaltPasswordHush = Convert.ToBase64String(SHA512.Create().ComputeHash(SaltPasswordBytes));
_Login.Login_PasswordHash = SaltPasswordHush;
_Login.Login_PasswordSalt = Salt;
db.Tbl_Login.Add(_Login);
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "ثبت نام با موفقیت انجام شده";
return(RedirectToAction("Login"));
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "خطا";
return(View());
}
}
public ActionResult Create(Model_StudentCreate model)
{
if (ModelState.IsValid)
{
if (db.Tbl_Student.Where(x => x.Student_Code == model.Student_Code).Any())
{
TempData["TosterState"] = "info";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "اطلاعات دانشجوی مورد نظر قبلا در سامانه ثبت شده است.";
return(RedirectToAction("Index"));
}
Tbl_Student Student = new Tbl_Student()
{
Student_Guid = Guid.NewGuid(),
Student_Code = model.Student_Code,
Student_NationalCode = model.Student_NationalCode
};
db.Tbl_Student.Add(Student);
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "ثبت شد";
return(RedirectToAction("Index"));
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "ثبت نشد";
return(RedirectToAction("Index"));
}
}
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
public ActionResult ShowForm(FormCollection model)
{
var _student = db.Tbl_Student.Where(a => a.Student_Code == User.Identity.Name).SingleOrDefault();
int?student_id = _student.Student_ID;
if (student_id.HasValue)
{
Tbl_Form _form = new Tbl_Form();
int i = 1;
foreach (string key in model.AllKeys)
{
if (key == "ID")
{
string q = model[key];
_form = db.Tbl_Form.Where(a => a.Form_IsDelete == false && a.Form_Guid.ToString() == q).SingleOrDefault();
if (_form.Form_Guid.ToString() == "c78afdf3-a647-4e54-95e8-94869576b7e5")
{
if (_student.Student_Form1)
{
return(RedirectToAction("ShowForm", new { ID = "de54c8ba-6032-4dc5-9241-2e6614a9840d" }));
}
}
else if (_form.Form_Guid.ToString() == "de54c8ba-6032-4dc5-9241-2e6614a9840d")
{
if (_student.Student_Form2)
{
return(RedirectToAction("index", "PortalTakeTurn"));
}
}
}
else
{
if (_form != null)
{
Guid guid;
if (Guid.TryParse(key, out guid))
{
string q = model[key];
Tbl_FormAnswer _answer = new Tbl_FormAnswer();
_answer.FA_Guid = Guid.NewGuid();
_answer.FA_FormID = _form.Form_ID;
_answer.FA_StudentID = student_id.Value;
db.Tbl_FormAnswer.Add(_answer);
string[] ANS = q.Split(',');
foreach (string item in ANS)
{
Tbl_FormAnswerResponse _response = new Tbl_FormAnswerResponse();
_response.FAR_Guid = Guid.NewGuid();
_response.FAR_ResponseID = db.Tbl_Response.Where(a => a.Response_Guid.ToString() == item).SingleOrDefault().Response_ID;
_response.Tbl_FormAnswer = _answer;
db.Tbl_FormAnswerResponse.Add(_response);
}
i++;
}
}
}
}
i = 0;
if (_form.Form_Guid.ToString() == "c78afdf3-a647-4e54-95e8-94869576b7e5")
{
var q = db.Tbl_Student.Where(a => a.Student_Code == User.Identity.Name).SingleOrDefault();
q.Student_Form1 = true;
db.Entry(q).State = EntityState.Modified;
}
else if (_form.Form_Guid.ToString() == "de54c8ba-6032-4dc5-9241-2e6614a9840d")
{
var q = db.Tbl_Student.Where(a => a.Student_Code == User.Identity.Name).SingleOrDefault();
q.Student_Form2 = true;
db.Entry(q).State = EntityState.Modified;
}
if (Convert.ToBoolean(db.SaveChanges() > 0))
{
TempData["TosterState"] = "success";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "عملیات با موفقیت انجام شده";
if (_form.Form_Guid.ToString() == "c78afdf3-a647-4e54-95e8-94869576b7e5")
{
return(RedirectToAction("ShowForm", new { ID = "de54c8ba-6032-4dc5-9241-2e6614a9840d" }));
}
else if (_form.Form_Guid.ToString() == "de54c8ba-6032-4dc5-9241-2e6614a9840d")
{
return(RedirectToAction("index", "PortalTakeTurn"));
}
else
{
return(RedirectToAction("index", "Portal"));
}
}
else
{
TempData["TosterState"] = "error";
TempData["TosterType"] = TosterType.Maseage;
TempData["TosterMassage"] = "خطا";
return(RedirectToAction("ShowForm", new { ID = _form.Form_Guid }));
}
}
return(View());
}