public RequestEntityPersistenceImp(RequestEntity entity) { PersistentId = entity.PersistentId; Value = entity.Value; Description = entity.Description; Date = entity.Date; Category = new CategoryEntityStub(entity.Category); }
internal UserResponse GetUserRequest(RequestEntity objReq) { UserResponse objResponse = new UserResponse(); using (var db = new WizzDataContext()) { if (objReq.isTutor.ToLower() == "true") { } else { var tutorData = db.tblTutorSchedules.Where(x => x.fkUserId == Convert.ToInt64(objReq.userId)).ToList(); TutorScheduleModel objTutor = new TutorScheduleModel(); objTutor.userId = objReq.userId; DayTimeModel dtmObj = new DayTimeModel(); foreach (var n in tutorData) { dtmObj = new DayTimeModel(); dtmObj.dayType = Convert.ToString(n.dayType); dtmObj.fromTime = ReverseTimeConversionMethod(n.fromTime); dtmObj.toTime = ReverseTimeConversionMethod(n.toTime); objTutor.scheduleList.Add(dtmObj); } objResponse.tutorObj = objTutor; } return objResponse; //throw new NotImplementedException(); } }
private RequestViewModel CreateRequestViewModelFromEntity(RequestEntity requestEntity) { var requestViewModel = new RequestViewModel(Application, requestEntity.PersistentId); requestViewModel.Refresh(); return requestViewModel; }
public Response<SessionResponseTutorModel> GetSessionsForTutor(RequestEntity objReq) { Response<SessionResponseTutorModel> response = new Response<SessionResponseTutorModel>(); List<SessionResponseTutorModel> objResp = new List<SessionResponseTutorModel>(); try { Session obj = new Session(); if (CheckRequestIsvalidornot(this.Request)) { objDbMethodV2 = new Dal.DbMethodsV2(); objResp = objDbMethodV2.GetSessionsForTutor(objReq); if (objResp.Count > 0) response.Create(true, Messages.FormatMessage(Messages.Success, "Session List"), Messages.AppVersion, objResp); else response.Create(true, Messages.FormatMessage(Messages.NoRecord), Messages.AppVersion, objResp); } else { response.Create(false, Messages.FormatMessage(Messages.NotAllowedUser), Messages.AppVersion, objResp); } } catch (Exception ex) { object session = new JavaScriptSerializer().Serialize(objReq); LogManager.Error("Error occured while Processing Webservice request :{0}", ex, session, ex.Message); response.Create(false, Messages.FormatMessage(Messages.ErrorOccure), Messages.AppVersion, objResp); } return response; }
internal List<SessionResponseStudentModel> GetSessionsForStudent(RequestEntity objReq) { using (var db = new WizzDataContext()) { List<SessionResponseStudentModel> tutorList = new List<SessionResponseStudentModel>(); int userId = Convert.ToInt32(objReq.userId); tblInviteFriend friendsData = new tblInviteFriend(); friendsData = db.tblInviteFriends.Where(x => x.fkFriendId == userId).FirstOrDefault(); if (friendsData != null) { objReq.userId = Convert.ToString(friendsData.fkUserId); } var sessionList = db.usp_GetSessions(Convert.ToInt32(objReq.userId)).ToList(); foreach (var c in sessionList) { SessionResponseStudentModel model = new SessionResponseStudentModel(); model.homeWork = c.homeWork; model.homeWorkDueDate = c.homeWorkDueDate; model.latitude = Convert.ToString(c.lat); model.location = c.location; model.longitude = Convert.ToString(c.longi); model.profilePic = c.profilePic; model.sessionEndTime = c.toTime; model.sessionStartTime = c.fromTime; model.fromTime = ReverseTimeConversionMethod(c.fromTime); model.toTime = ReverseTimeConversionMethod(c.toTime); model.dayType = Convert.ToString(c.dayType); model.subjectName = c.subjectName.ToString(); model.tutorId = c.tutorId.ToString(); model.tutorName = c.tutorName; model.sessionId = c.sessionId.ToString(); model.uniqueRequestId = c.uniqueRequestId; var friendData = db.usp_GetFriendsOfUser(c.sessionId.ToString()).ToList(); if (friendData.Count > 0) { foreach (var d in friendData) { FriendsListModel mod = new FriendsListModel(); if (d.fkFriendId == Convert.ToInt32(objReq.userId) || d.isDelete == true) { continue; } mod.friendId = Convert.ToString(d.fkFriendId); mod.friendName = d.frienName == "" ? d.userName : d.frienName; mod.amount = ""; mod.isConfirm = Convert.ToString(d.isConfirm); mod.profilePic = string.IsNullOrWhiteSpace(d.profilePic) ? "" : d.profilePic.IndexOf("http") >= 0 ? d.profilePic : Constants.imagepath + d.profilePic; if (mod.friendId == null) { } else { model.friendsList.Add(mod); } } } tutorList.Add(model); } return tutorList; } }
internal List<SessionResponseTutorModel> GetSessionsForTutor(RequestEntity objReq) { using (var db = new WizzDataContext()) { List<SessionResponseTutorModel> studentList = new List<SessionResponseTutorModel>(); var ListData = db.usp_GetSessionsForTutor(Convert.ToInt32(objReq.userId)).ToList(); Int32 tutorId = Convert.ToInt32(objReq.userId); foreach (var c in ListData) { SessionResponseTutorModel obj = new SessionResponseTutorModel(); obj.homeWork = c.homeWork; obj.homeWorkDueDate = c.homeWorkDueDate; obj.latitude = Convert.ToString(c.lat); obj.location = c.location; obj.longitude = Convert.ToString(c.longi); obj.profilePic = c.profilePic; obj.sessionEndTime = c.toTime; obj.sessionStartTime = c.fromTime; obj.fromTime = ReverseTimeConversionMethod(c.fromTime); obj.toTime = ReverseTimeConversionMethod(c.toTime); obj.dayType = Convert.ToString(c.dayType); obj.subjectName = c.subjectName.ToString(); obj.studentId = c.studentId.ToString(); obj.studentName = c.studentName; obj.uniqueRequestId = c.uniqueRequestId; obj.sessionId = c.sessionId.ToString(); //var frien // obj.friendsList = (from d in db.usp_GetFriendsOfUser(c.uniqueRequestId) // select new FriendsListModel // { // friendId = Convert.ToString(d.fkFriendId), // friendName = d.frienName == "" ? d.userName : d.frienName, // amount = "", // isConfirm = Convert.ToString(d.isConfirm), // profilePic = string.IsNullOrWhiteSpace(d.profilePic) ? "" : d.profilePic.IndexOf("http") >= 0 ? d.profilePic : Constants.imagepath + d.profilePic // }).ToList(); var friendData = db.usp_GetFriendsOfUser(c.sessionId.ToString()).ToList(); foreach (var d in friendData) { if (d.fkFriendId == Convert.ToInt32(objReq.userId) || d.isDelete == true) { continue; } FriendsListModel mod = new FriendsListModel(); mod.friendId = Convert.ToString(d.fkFriendId); mod.friendName = d.frienName == "" ? d.userName : d.frienName; mod.amount = ""; mod.isConfirm = Convert.ToString(d.isConfirm); mod.profilePic = string.IsNullOrWhiteSpace(d.profilePic) ? "" : d.profilePic.IndexOf("http") >= 0 ? d.profilePic : Constants.imagepath + d.profilePic; if (mod.friendId == null) { } else { obj.friendsList.Add(mod); } } obj.sessionCost = CalculateSessionCost(fromTime: obj.fromTime, friendsCount: obj.friendsList.Count, db: db, toTime: obj.toTime, tutorId: tutorId); studentList.Add(obj); } return studentList; } }
public async Task <ResponseData <yy_News_Type> > Get(RequestEntity value) { //查询的表名称 Type Table = typeof(yy_News_Type); var FormData = await Request.Content.ReadAsAsync <Dictionary <String, String> >(); #region where condition //筛选条件 var Where = String.Empty; var WhereBuild = new List <string>(); #region 新闻标题 if (!String.IsNullOrEmpty(value.Title)) { WhereBuild.Add("Title like '%" + value.Title + "%'"); } #endregion #region 新闻分类 if (value.TypeID > 0) { WhereBuild.Add("TypeIDs like '%," + value.TypeID + ",%'"); } #endregion #region 根据时间过滤 #region 大于等于 开始时间 && 小于等于 结束时间 if (!String.IsNullOrEmpty(value.StartTime) && !String.IsNullOrEmpty(value.EndTime)) { DateTime st, et; if (DateTime.TryParse(value.StartTime, out st) && DateTime.TryParse(value.EndTime, out et)) { WhereBuild.Add(" CreateDate >= '" + st.ToString("yyyy-MM-dd") + " 00:00:00' AND CreateDate <= '" + et.ToString("yyyy-MM-dd") + " 23:59:59'"); } } #endregion #region 大于等于开始时间 else if (!String.IsNullOrEmpty(value.StartTime)) { DateTime st; if (DateTime.TryParse(value.StartTime, out st)) { WhereBuild.Add(" CreateDate >= '" + st.ToString("yyyy-MM-dd") + " 00:00:00'"); } } #endregion #region 小于等于结束时间 else if (!String.IsNullOrEmpty(value.EndTime)) { DateTime et; if (DateTime.TryParse(value.EndTime, out et)) { WhereBuild.Add(" CreateDate <= '" + et.ToString("yyyy-MM-dd") + " 23:59:59'"); } } #endregion #endregion if (WhereBuild.Count > 0) { Where = " WHERE " + String.Join(" AND ", WhereBuild); } #endregion #region OrderBy //排序规则 String OrderBy = " ID DESC "; if (!String.IsNullOrEmpty(value.OrderBy)) { OrderBy = " " + value.OrderBy + " " + (value.IsDesc ? "DESC" : "ASC"); } #endregion #region 拼接sql语句 String colsStr = " * "; #region 查询数据 String QuertCMD = String.Format(@"SELECT TOP {0} * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY {4}) AS RowNumber," + colsStr + @" FROM {2} WITH(NOLOCK) {3} ) A WHERE RowNumber > {0} * ({1}-1)", value.PageSize, value.PageIndex + 1, "[" + Table.Name + "]", Where, OrderBy); #endregion #region 查询总数 String DataCountCMD = @"SELECT COUNT(1) FROM [" + Table.Name + "] WITH(NOLOCK) " + Where; #endregion #endregion #region 执行查询并返回数据 var DataCount = DB.Database.SqlQuery <int>(DataCountCMD).FirstOrDefault(); return(new ResponseData <yy_News_Type>(value.PageSize, value.PageIndex, DataCount, (DataCount % value.PageSize == 0 ? DataCount / value.PageSize : DataCount / value.PageSize + 1), DB.Database.SqlQuery <yy_News_Type>(QuertCMD).ToList())); #endregion }
void OpenRequestEditForm(RequestEntity request) { _mainController.OpenRequestEditForm(request, false); _requestIdentCash.Add(request.CloneKey); }
public async Task <IResponseEntity> GetList(RequestEntity <ApiFilterRequest> req) { return(await _sysApiService.GetListAsync(req)); }
public async Task <ResponseData <FansNewsItem> > News(RequestEntity value) { //查询的表名称 Type Table = typeof(yy_News); var FormData = await Request.Content.ReadAsAsync <Dictionary <String, String> >(); #region where condition //筛选条件 var Where = String.Empty; var WhereBuild = new List <string>(); #region 新闻标题 if (!String.IsNullOrEmpty(value.Title)) { WhereBuild.Add("Title like '%" + value.Title + "%'"); } #endregion #region 新闻分类 if (value.TypeID > 0) { WhereBuild.Add("TypeIDs like '%," + value.TypeID + ",%'"); } #endregion if (WhereBuild.Count > 0) { Where = " WHERE " + String.Join(" AND ", WhereBuild); } #endregion #region OrderBy //排序规则 String OrderBy = " ID DESC "; if (!String.IsNullOrEmpty(value.OrderBy)) { OrderBy = " " + value.OrderBy + " " + (value.IsDesc ? "DESC" : "ASC"); } #endregion #region 拼接sql语句 String colsStr = " ID,Title,Summary,LookCount,WechatNewsUrl,DefaultImg,CreateDate "; #region 查询数据 String QuertCMD = String.Format(@"SELECT TOP {0} * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY {4}) AS RowNumber," + colsStr + @" FROM {2} WITH(NOLOCK) {3} ) A WHERE RowNumber > {0} * ({1}-1)", value.PageSize, value.PageIndex + 1, "[" + Table.Name + "]", Where, OrderBy); #endregion #region 查询总数 String DataCountCMD = @"SELECT COUNT(1) FROM [" + Table.Name + "] WITH(NOLOCK) " + Where; #endregion #endregion #region 执行查询并返回数据 var DataCount = DB.Database.SqlQuery <int>(DataCountCMD).FirstOrDefault(); return(new ResponseData <FansNewsItem>(value.PageSize, value.PageIndex, DataCount, (DataCount % value.PageSize == 0 ? DataCount / value.PageSize : DataCount / value.PageSize + 1), DB.Database.SqlQuery <FansNewsItem>(QuertCMD).ToList())); #endregion }
/// <summary> /// 各自处理 /// </summary> /// <param name="requestEntity"></param> /// <param name="responseEntity"></param> protected virtual void DoExecute(RequestEntity requestEntity, ResponseEntity responseEntity) { }
private bool Equals(RequestEntity other) { return(Id == other.Id && string.Equals(Json, other.Json)); }
/// <summary> /// Gets the current astronomy information. /// </summary> /// <param name="request">The request configuration.</param> public override async Task <TAstronomyResponseEntity> GetAstronomyAsync <TAstronomyResponseEntity>(RequestEntity request, CancellationToken cancellationToken = default) { var astronomyResponseEntity = await base.GetAstronomyAsync <TAstronomyResponseEntity>(request, cancellationToken); // Do something custom, if the entity allows it. if (astronomyResponseEntity is CustomAstronomyResponseEntity customAstronomyEntity) { customAstronomyEntity.DoSomethingCustom(); } return(astronomyResponseEntity); }
public object DefaultHeader(BaseHttpClient client, RequestEntity request, MetaModel meta) { return(null); }