public void Update(User obj)
{
using (ProjectEntities db = new ProjectEntities())
{
db.Users.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public JsonResult <List <Models.ProjectDetails> > GetAllProjectDetailsSorted(string sortBy, bool ascending)
{
List <DataAccessLayer.ProjectDetail> prodList = ProjectEntities.GetAllProjects().AsQueryable().OrderByPropertyName(sortBy, ascending).ToList();
var result = new List <DataAccessLayer.ProjectDetail>();
var projectObject = Mapper.Map <List <DataAccessLayer.ProjectDetail>, List <Models.ProjectDetails> >(prodList);
return(Json(projectObject));
}
public void Delete(User_Book obj)
{
using (ProjectEntities db = new ProjectEntities())
{
db.User_Book.Attach(obj);
db.User_Book.Remove(obj);
db.SaveChanges();
}
}
//הפונקציה בודקת האם למיקום הזה יש למשתמש חנות קרובה עבור אחת מהקטגוריות
public static WebResult <List <SearchInShop> > CheckDistance(UserIdWithLocation userIdWithLocation)
{
using (ProjectEntities db = new ProjectEntities())
{
List <SearchInShop> searchesFound = new List <SearchInShop>();
double lat = userIdWithLocation.Lat;
double lng = userIdWithLocation.Lng;
var codeUser = db.Users.First(f => f.passwordUser == userIdWithLocation.Uuid).codeUser;
foreach (var search in db.Searches)
{
//only if the search is from this user and its status is 0, to find
if (search.codeUser == codeUser && search.status == 0)
{
foreach (var shop in db.Shops)
{
//if distance is less than 1000 meter
if (getDistance(lat, lng, shop.latitude, shop.longitude) < search.distance)
{
//if there is the category that the user search in that shop
if (Casting.ShopCast.GetShopDTO(shop).Categories.FirstOrDefault(f => f.codeCategory == search.codeCategory) != null)
{
TimeSpan fromHour = TimeSpan.MinValue, toHour = TimeSpan.MaxValue;
TimeSpan now = DateTime.Now.TimeOfDay;
//if shop is opened
if (shop.fromHour != null && shop.toHour != null)
{
fromHour = TimeSpan.Parse(shop.fromHour);
toHour = TimeSpan.Parse(shop.toHour);
}
if (fromHour < now && toHour > now)
{
searchesFound.Add(new SearchInShop()
{
CodeSearch = search.codeSearch,
NameProduct = search.nameProduct,
AddressString = shop.addressString,
NameShop = shop.nameShop,
PhoneShop = shop.phoneShop,
MailShop = shop.mailShop,
FromHour = shop.fromHour,
ToHour = shop.toHour
});
}
}
}
}
}
}
return(new WebResult <List <SearchInShop> >()
{
Status = true,
Message = "return searches found",
Value = searchesFound
});
}
}
public ActionResult LecturerReg()
{
using (var db = new ProjectEntities())
{
ViewBag.courseID = new SelectList(db.Courses.ToList(), "courseID", "course_title");
ViewBag.lecturerID = new SelectList(db.Lecturers.ToList(), "lecturerID", "lecturer_name");
return(View());
}
}
public User_Book Insert(User_Book obj)
{
using (ProjectEntities db = new ProjectEntities())
{
db.User_Book.Add(obj);
db.SaveChanges();
return(obj);
}
}
public ActionResult CourseReg()
{
using (var db = new ProjectEntities())
{
ViewBag.courseID = new SelectList(db.Courses.ToList(), "courseID", "course_title");
ViewBag.studentID = new SelectList(db.Students.ToList(), "studentID", "student_name");
return(View());
}
}
/// <summary>
/// 执行原始SQL命令
/// </summary>
/// <param name="commandText">SQL命令</param>
/// <param name="parameters">参数</param>
/// <returns>影响的记录数</returns>
public Object[] ExecuteSqlNonQuery <T>(string commandText, params Object[] parameters)
{
using (ProjectEntities context = new ProjectEntities())
{
var results = context.Database.SqlQuery <T>(commandText, parameters);
results.Single();
return(parameters);
}
}
public static List <Subject> GetSubjects()
{
using (ProjectEntities db = new ProjectEntities())
{
List <Subject> sbList = db.Subject.ToList();
return(sbList);
}
}
public void DeleteProject(ProjectModel model)
{
using (var db = new ProjectEntities())
{
var deleteProject = db.UserProjects.Where(x => x.ID == model.ProjectID).First();
db.UserProjects.Remove(deleteProject);
db.SaveChanges();
}
}
// GET: Logs
public ActionResult Index(int?id)
{
using (var db = new ProjectEntities())
{
Attendance attendance = new Attendance();
var getDate = DateTime.Now.ToLongDateString();
var getCurrent = db.Attendances.Include(a => a.Course).Include(a => a.Student).Where(a => a.date == getDate && a.courseID == id);
return(View(getCurrent.ToList()));
}
}
public static long ChangeStateByProjectId(long projectId, int stateId)
{
using (ProjectEntities db = new ProjectEntities())
{
Proj_Project pr = db.Proj_Project.SingleOrDefault(p => p.ProjectID == projectId);
pr.StateID = stateId;//项目状态变更
db.SaveChanges();
return(1);
}
}
/// <summary>
/// 记录成员在项目中的成绩
/// </summary>
/// <param name="mId"></param>
/// <param name="score"></param>
/// <returns></returns>
public static long UpdateMemberScore(long mId, float score)
{
using (ProjectEntities db = new ProjectEntities())
{
Proj_Member pm = db.Proj_Member.SingleOrDefault(p => p.MemberID == mId);
pm.Score = score;
db.SaveChanges();
return(1);
}
}
/// <summary>
/// 获取参加过项目的所有成员，从视图Proj_VUserScore
/// </summary>
/// <returns></returns>
public static long[] GetProjUser()
{
using (ProjectEntities db = new ProjectEntities())
{
List <Proj_VUserScore> psList = db.Proj_VUserScore.ToList();
long[] ArrUserId = psList.Select(ps => ps.UserID).Distinct().ToArray();
return(ArrUserId);
}
}
public JsonResult <List <Models.ProjectDetails> > GetAllProjectDetails()
{
List <DataAccessLayer.ProjectDetail> projectList = ProjectEntities.GetAllProjects();
List <Models.ProjectDetails> projects = new List <Models.ProjectDetails>();
List <Models.ProjectDetails> projectObj = Mapper.Map <List <DataAccessLayer.ProjectDetail>, List <Models.ProjectDetails> >(projectList);
return(Json(projectObj));
}
//Returns history of the searches, even thouse the user found
public static WebResult <List <SearchDetailsForUser> > GetHistory(string passwordUser)
{
using (ProjectEntities db = new ProjectEntities())
{
string pass = passwordUser;
User CurrentUser = db.Users.FirstOrDefault(f => f.passwordUser == pass);
if (CurrentUser == null)
{
return(new WebResult <List <SearchDetailsForUser> >
{
Message = "the user cant find!",
Value = null,
Status = false
});
}
List <SearchDetailsForUser> searchesForUser = new List <SearchDetailsForUser>();
var searches = SearchCast.GetSearchesDTO(db.Searches.ToList());
foreach (var search in searches)
{
if (search.codeUser == CurrentUser.codeUser && search.status != EStatus.Deleted)
{
searchesForUser.Add(new SearchDetailsForUser()
{
CodeSearch = search.codeSearch,
NameProduct = search.nameProduct,
nameCategory = db.Categories.First(f => f.codeCategory == search.codeCategory).nameCategory,
Status = search.status,
dateStart = search.dateStart,
dateEnd = search.dateEnd,
codeShop = search.codeShop,
nameShop = search.codeShop == null ? "" : db.Shops.First(f => f.codeShop == search.codeShop).nameShop,
IsFavoriteShop = search.codeShop == null ? null : db.Shops.First(f => f.codeShop == search.codeShop).isFavorite
});
}
}
string queryString = @"
UPDATE Shops
SET
Shops.isFavorite = 1
FROM Shops
INNER JOIN Searches
ON Shops.codeShop = Searches.codeShop
";
int effected = db.Database.ExecuteSqlCommand(queryString);
searchesForUser.Reverse();
return(new WebResult <List <SearchDetailsForUser> >
{
Message = "חיפושי המשתמש נשלחו בהצלחה",
Value = searchesForUser,
Status = true
});
}
}
/// <summary>
/// 成员退出
/// </summary>
/// <param name="mId"></param>
/// <param name="outReason"></param>
/// <returns></returns>
public static long SetMemberOut(long mId, string outReason)
{
using (ProjectEntities db = new ProjectEntities())
{
Proj_Member pm = db.Proj_Member.SingleOrDefault(p => p.MemberID == mId);
pm.OutReason = outReason;
pm.ApplyOutTime = DateTime.Now;
db.SaveChanges();
return(1);
}
}
//Update shop with categories
public static WebResult <ShopDTO> Update(ShopDTO shopDTO)
{
using (ProjectEntities db = new ProjectEntities())
{
Shop shop = db.Shops.FirstOrDefault(f => f.mailShop == shopDTO.mailShop);
//למייל אסור להשתנות
if (shop == null)
{
return new WebResult <ShopDTO>
{
Message = "החנות לא נמצאה",
Status = false,
Value = null
}
}
;
shop.nameShop = shopDTO.nameShop;
shop.phoneShop = shopDTO.phoneShop;
shop.latitude = shopDTO.latitude;
shop.longitude = shopDTO.longitude;
shop.fromHour = shopDTO.fromHour;
shop.toHour = shopDTO.toHour;
shop.addressString = shopDTO.addressString;
List <CategoryDTO> sourceCats = shopDTO.Categories;
//למחוק קודם את כל הקטגוריות של החנות
List <Category_to_shop> category_To_Shops = db.Category_to_shop.ToList();
category_To_Shops.ForEach(item =>
{
if (item.codeShop == shop.codeShop)
{
db.Category_to_shop.Remove(item);
}
});
db.SaveChanges();
// להוסיף את כל הקטגוריות החדשות לחנות
foreach (var item in sourceCats)
{
db.Category_to_shop.Add(new Category_to_shop()
{
codeCategory = item.codeCategory, codeShop = shop.codeShop
});
}
db.SaveChanges();
return(new WebResult <ShopDTO>
{
Message = "הנתונים התעדכנו בהצלחה",
Value = shopDTO,
Status = true
});
}
}
public static long UpdateProjectsMatch(long MatchID, int IsAccetpted)
{
using (ProjectEntities db = new ProjectEntities())
{
Proj_Match pr = db.Proj_Match.SingleOrDefault(p => p.MatchID == MatchID);
pr.IsAccepted = IsAccetpted;
pr.AcceptedTime = DateTime.Now;
db.SaveChanges();
}
return(1);
}
public static int ApproveNewRole(UserRole dr)//为用户审批新角色
{
using (var db = new ProjectEntities())
{
UserRole ur = db.UserRole.FirstOrDefault(r => r.UserRoleID == dr.UserRoleID);
ur.StateID = dr.StateID;//-1拒绝,1同意
ur.Approved = dr.Approved;
ur.ApprovedBy = dr.ApprovedBy;
db.SaveChanges();
return(1);
}
}
/// <summary>
/// 删除项目
/// </summary>
/// <param name="dr"></param>
/// <param name="delBy"></param>
/// <param name="closedTime"></param>
/// <returns></returns>
public static long DelProjectById(Proj_Project dr, long delBy, DateTime closedTime)
{
using (ProjectEntities db = new ProjectEntities())
{
Proj_Project pr = db.Proj_Project.SingleOrDefault(p => p.ProjectID == dr.ProjectID);
pr.ModifiedBy = delBy;
pr.ModifyTime = closedTime;
pr.Flag = 0;//项目删除
db.SaveChanges();
return(1);
}
}
/// <summary>
/// Loads all tables into the context.
/// </summary>
public void LoadTablesIntoContext()
{
ProjectEntities.Load();
PersonEntities.Load();
ExpertEntities.Load();
EventTreeEntities.Load();
TreeEventEntities.Load();
ExpertClassEstimationEntities.Load();
FragilityCurveElementEntities.Load();
TreeEventFragilityCurveElementEntities.Load();
HydraulicConditionElementEntities.Load();
}
/// <summary>
/// 变更项目状态(项目状态：0.未启动；1.进行中；2.已结束；3. 已转化；4.延期；5.暂停；-1.关闭)
/// </summary>
/// <param name="projectId">项目ID</param>
/// <param name="stateId">状态参数</param>
/// <param name="changedBy">状态变更人</param>
/// <param name="changedTime">状态变更时间</param>
/// <returns></returns>
public static long ChangeStateByProjectId(long projectId, int stateId, long changedBy, DateTime changedTime)
{
using (ProjectEntities db = new ProjectEntities())
{
Proj_Project pr = db.Proj_Project.SingleOrDefault(p => p.ProjectID == projectId);
pr.ModifiedBy = changedBy;
pr.ModifyTime = changedTime;
pr.StateID = stateId;//项目状态变更
db.SaveChanges();
return(1);
}
}
//Returns the categories for choosing
public static WebResult <List <CategoryDTO> > GetAllCategories()
{
using (ProjectEntities db = new ProjectEntities())
{
return(new WebResult <List <CategoryDTO> >
{
Message = "רשימת קטגוריות כללית נשלחה בהצלחה",
Value = CategoryCast.GetCategoriesDTO(db.Categories.ToList()),
Status = true
});
}
}
//Register
public async static Task <WebResult <LoginData <ShopDTO> > > Register(ShopDTO shopDto, Uri request)
{
using (ProjectEntities db = new ProjectEntities())
{
if (db.Shops.FirstOrDefault(w => w.passwordShop == shopDto.passwordShop) != null ||
db.Shops.FirstOrDefault(w => w.mailShop == shopDto.mailShop) != null)//אם יש כבר כזה מייל או כזו סיסמה
{
return new WebResult <LoginData <ShopDTO> >
{
Message = "אחד מהפרטים שהוקשו כבר קיים במערכת",
Status = false,
Value = null
}
}
;
List <CategoryDTO> sourceCats = shopDto.Categories;
List <Category_to_shop> category_To_Shops = new List <Category_to_shop>();
foreach (var item in sourceCats)
{
db.Category_to_shop.Add(new Category_to_shop()
{
codeCategory = item.codeCategory, codeShop = shopDto.codeShop
});
}
db.Shops.Add(ShopCast.GetShop(shopDto));
if (db.SaveChanges() > 0)//בדיקה שהמידע נשמר
{
var accessToken = await GetTokenDataAsync(shopDto.mailShop, shopDto.passwordShop, request);
if (!string.IsNullOrEmpty(accessToken))
{
return(new WebResult <LoginData <ShopDTO> >
{
Status = true,
Message = "התחברת בהצלחה",
Value = new LoginData <ShopDTO>
{
TokenJson = accessToken,
objectDTO = shopDto
}
});
}
}
return(new WebResult <LoginData <ShopDTO> >
{
Status = false,
Message = "ההרשמה נכשלה",
Value = null
});
}
}
public JsonResult <Models.ProjectDetails> GetProjectDetail(int id)
{
var ProjectEntitiesInfo = ProjectEntities.GetProject(id);
var project = new Models.ProjectDetails();
Models.ProjectDetails obj = Mapper.Map <DataAccessLayer.ProjectDetail, Models.ProjectDetails>(ProjectEntitiesInfo);
var managerInfo = UserEntities.GetUsers((int)ProjectEntitiesInfo.ManagerId);
obj.Manager = Mapper.Map <DataAccessLayer.User, Models.User>(managerInfo);
return(Json <Models.ProjectDetails>(obj));
}
public bool InsertProjectDetail(Models.ProjectDetails projectDetails)
{
bool status = false;
if (ModelState.IsValid)
{
projectDetails.Id = ProjectEntities.GetMaxProjectId() + 1;
var projectDetailsObj = Mapper.Map <Models.ProjectDetails, DataAccessLayer.ProjectDetail>(projectDetails);
status = ProjectEntities.InsertProjectDetail(projectDetailsObj);
}
return(status);
}
public ActionResult StaffRegistration(Lecturer lecturer)
{
using (var _context = new ProjectEntities())
{
if (ModelState.IsValid)
{
_context.Lecturers.Add(lecturer);
_context.SaveChanges();
return(RedirectToAction("StaffList"));
}
}
return(View());
}
public ActionResult StudentRegistration(Student student)
{
using (var _context = new ProjectEntities())
{
if (ModelState.IsValid)
{
_context.Students.Add(student);
_context.SaveChanges();
return(RedirectToAction("Students"));
}
}
return(View());
}
public static CategoryDTO GetCategoryDTO(Category category)
{
using (ProjectEntities db = new ProjectEntities())
{
List <int> codesShops = db.Category_to_shop.Where(c => c.codeCategory == category.codeCategory).Select(x => x.codeShop).ToList();
return(new CategoryDTO()
{
codeCategory = category.codeCategory,
nameCategory = category.nameCategory
});
}
}
