public string UserSignUp(object user)
{
JObject jdata = JObject.Parse(user.ToString());
string uemail = jdata.SelectToken("UserEmail").ToString(); //邮箱
string upwd = jdata.SelectToken("UserPwd").ToString(); //密码
string uname = jdata.SelectToken("UserName").ToString(); //昵称
//获取默认账号和用户名
int account = QueryDAL.GetModelTowhereSql <ShiUsers>
("select top 1 * from ShiUsers order by Key_No desc").KeyNo;
string uaccname = "shi00" + (account + 1);
ShiUsers users = new ShiUsers();
users.UserEmail = uemail;
users.UserPwd = upwd;
users.UserName = uname;
users.Account = uaccname;
users.UserSex = 2;//默认为私密
//创建token：根据用户名+时间通过MD5加密后保证唯一性
DateTime gettime = DateTime.Now;
users.UserToken = MD5Encryption.Md5_32(uname.ToString() + gettime.ToString());
users.TokenEndtiem = gettime;
if (InsertDAL.InsertModel <ShiUsers>(users))
{
return(users.UserToken);
}
return("-1");
}
public ActionResult CheckUserIn(int intUserID)
{
GetDAL get = new GetDAL();
get.OpenConnection();
Users u = get.GetUserByID(intUserID);
get.CloseConnection();
get.OpenConnection();
List <AttendancePlanned> apList = get.GetAttendancePlannedByRehearsalPart(ChosenRehearsalPart); // join query here
get.CloseConnection();
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
foreach (AttendancePlanned ap in apList)
{
if (u.Equals(ap.User))
{
insert.InsertAttendanceActual(new AttendanceActual(DateTime.Now, true, ap));
UsersNotCurrentlyAtRehearsal.Remove(u);
}
}
get.CloseConnection();
insert.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult ConfirmSingleRehearsal(string strLocation, string strNotes, DateTime dtmStart, DateTime dtmEnd)
{
Rehearsal newRehearsal = new Rehearsal
{
DtmStartDateTime = dtmStart,
DtmEndDateTime = dtmEnd,
StrLocation = strLocation,
StrNotes = strNotes
};
newRehearsal.LstRehearsalParts = tmpRehearsalPartsSchedule.LstScheduledRehearsalParts.Where(x => x.DtmStartDateTime.GetValueOrDefault().Date.Equals(newRehearsal.DtmStartDateTime.Date)).ToList();
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
if (insert.InsertRehearsal(newRehearsal))
{
return(Json(new { success = true, responseTest = "confirmed!" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, responseTest = "error" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddEventSchedule(AdminHomeVM vm)
{
InsertDAL insert = new InsertDAL();
//vm.NewEventSchedule.PerWeekdayDuration = NodaTime.Period.FromMinutes(vm.NewEventSchedule.PerWeekdayDuration.Minutes);
//vm.NewEventSchedule.PerWeekendDuration = NodaTime.Period.FromMinutes(vm.NewEventSchedule.PerWeekendDuration.Minutes);
EventSchedule newEventSchedule = new EventSchedule(
vm.NewEventSchedule.Event,
(int)vm.NewEventSchedule.IntWeekdayDuration,
(int)vm.NewEventSchedule.IntWeekendDuration,
vm.NewEventSchedule.StrMondayStart,
vm.NewEventSchedule.StrTuesdayStart,
vm.NewEventSchedule.StrWednesdayStart,
vm.NewEventSchedule.StrThursdayStart,
vm.NewEventSchedule.StrFridayStart,
vm.NewEventSchedule.StrSaturdayStart,
vm.NewEventSchedule.StrSundayStart);
insert.OpenConnection();
insert.InsertEventSchedule(newEventSchedule);
insert.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult AddRehearsalPart(AdminHomeVM vm)
{
PeriodBuilder builder = new PeriodBuilder();
builder.Minutes = vm.NewRehearsalPart.IntLengthMinutes;
vm.NewRehearsalPart.DurLength = builder.Build();
GetDAL get = new GetDAL();
get.OpenConnection();
foreach (var id in vm.NewRehearsalPart.ArrMemberNeededIDs)
{
Users tmpUser = get.GetUserByID(id);
vm.NewRehearsalPart.LstMembers.Add(tmpUser);
}
get.CloseConnection();
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
int newRehearsalPartID = insert.InsertRehearsalPart(vm.NewRehearsalPart);
vm.NewRehearsalPart.IntRehearsalPartID = newRehearsalPartID;
foreach (var m in vm.NewRehearsalPart.LstMembers)
{
AttendancePlanned ap = new AttendancePlanned(vm.NewRehearsalPart, m);
insert.InsertAttendancePlanned(ap);
}
insert.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult AddEvent(AdminHomeVM vm)
{
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
insert.InsertEvent(vm.NewEvent);
insert.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult AddTypes(AdminHomeVM vm)
{
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
insert.InsertType(vm.NewType);
insert.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult MarkTaskFinished(int intTaskID)
{
InsertDAL insertDAL = new InsertDAL();
insertDAL.OpenConnection();
insertDAL.MarkTaskAsComplete(intTaskID);
insertDAL.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult AddConflict(ConflictsHomeVM vm)
{
vm.ConflictToAdd.User = Globals.LOGGED_IN_USER;
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
insert.InsertConflict(vm.ConflictToAdd);
insert.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult AddTask(TasksHomeVM vm)
{
InsertDAL insertDAL = new InsertDAL();
vm.NewTask.UserAssignedBy = Globals.LOGGED_IN_USER;
insertDAL.OpenConnection();
insertDAL.InsertTask(vm.NewTask);
insertDAL.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult EditUser(ProfileHomeVM vm)
{
Users currentUser = Globals.LOGGED_IN_USER;
currentUser.StrEmail = vm.EditedUserProfile.StrEmail;
currentUser.StrPhone = vm.EditedUserProfile.StrPhone;
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
insert.ChangeEmailAndPhone(currentUser);
insert.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult ConfirmSchedule()
{
// update rehearsal part times
//vm.LstConfirmScheduledRehearsalParts = tmpRehearsalPartsSchedule.LstScheduledRehearsalParts;
// insert start and end dates for each rehearsal part into db
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
foreach (var rp in tmpRehearsalPartsSchedule.LstScheduledRehearsalParts)
{
insert.UpdateRPTimes(rp.IntRehearsalPartID, rp.DtmStartDateTime.GetValueOrDefault(), rp.DtmEndDateTime.GetValueOrDefault());
}
insert.CloseConnection();
return(Json(new { success = true, response = "confirmed!" }, JsonRequestBehavior.AllowGet));
//return RedirectToAction("Index", "Schedule");
}
public ActionResult AddAnnouncement(CallboardHomeVM vm)
{
Callboard newCallboard = vm.NewAnnouncement;
newCallboard.PostedByUser = Globals.LOGGED_IN_USER;
// insert announcement into database
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
insert.InsertCallboard(newCallboard);
insert.CloseConnection();
// also send email
return(SendEmail(newCallboard));
}
public ActionResult AddUserToEvent(ProfileHomeVM vm)
{
Users currentUser = Globals.LOGGED_IN_USER;
// add user to group
InsertDAL insertDAL = new InsertDAL();
insertDAL.OpenConnection();
insertDAL.InsertToUserEvents(vm.NewEvent, currentUser);
insertDAL.CloseConnection();
GetDAL get = new GetDAL();
get.OpenConnection();
Globals.LOGGED_IN_USER.LstEvents = get.GetEventsByUser(currentUser.IntUserID);
get.CloseConnection();
return(RedirectToAction("Index"));
}
