//internal int StudentRequest(StudentRequestModel objReq) //{ // using (var db = new WizzDataContext()) // { // var studentId = Convert.ToInt64(objReq.userId); // tblRequestStudent objStudent; // var requestUniqueId = Guid.NewGuid().ToString(); // if (objReq.isNow.ToLower()=="false"||String.IsNullOrEmpty(objReq.isNow)) // { // foreach (var n in objReq.listSlot) // { // objStudent = new tblRequestStudent(); // objStudent.latitude = Convert.ToDecimal(objReq.latitude); // objStudent.longitude = Convert.ToDecimal(objReq.longitude); // objStudent.forMinutes = Convert.ToInt32(objReq.totalMinutes); // objStudent.accompanyNum = Convert.ToInt16(objReq.accompanies); // objStudent.updatedDate = DateTime.UtcNow; // objStudent.createdDate = DateTime.UtcNow; // objStudent.day = Convert.ToInt16(n.dayNo); // objStudent.subjects = objReq.assignments; // objStudent.fkClassId = Convert.ToInt32(objReq.fkSubjectId); // objStudent.isActive = true; // objStudent.fromTime = n.fromTime; // objStudent.toTime = n.toTime; // objStudent.fkUserId = studentId; // objStudent.isDelete = false; // objStudent.isNow = false; // objStudent.TimeStamp = Convert.ToInt64(objReq.timeStamp); // objStudent.uniqueRequestId = requestUniqueId; // objStudent.calculatedAmount=Convert.ToInt32(objReq.calculatedAmount); // objStudent.location = objReq.location; // db.tblRequestStudents.InsertOnSubmit(objStudent); // db.SubmitChanges(); // } // } // else if (objReq.isNow.ToLower() == "true") // { // objStudent = new tblRequestStudent(); // objStudent.isNow = true; // objStudent.latitude = Convert.ToDecimal(objReq.latitude); // objStudent.longitude = Convert.ToDecimal(objReq.longitude); // objStudent.forMinutes = Convert.ToInt32(objReq.totalMinutes); // objStudent.accompanyNum = Convert.ToInt16(objReq.accompanies); // objStudent.fromTime = objReq.currentTime; // DateTime currentTime = Convert.ToDateTime(objReq.currentTime); // double minuts = Convert.ToDouble(objReq.totalMinutes); // currentTime = currentTime.AddMinutes(minuts); // objStudent.toTime = Convert.ToString(currentTime); // objStudent.updatedDate = DateTime.UtcNow; // objStudent.createdDate = DateTime.UtcNow; // objStudent.subjects = objReq.assignments; // objStudent.fkClassId = Convert.ToInt32(objReq.fkSubjectId); // objStudent.isActive = true; // objStudent.isDelete = false; // objStudent.fkUserId = studentId; // objStudent.TimeStamp =Convert.ToInt64(objReq.timeStamp); // objStudent.uniqueRequestId = requestUniqueId; // objStudent.calculatedAmount = Convert.ToInt32(objReq.calculatedAmount); // objStudent.location = objReq.location; // db.tblRequestStudents.InsertOnSubmit(objStudent); // db.SubmitChanges(); // } // else // { // return 0; // } // //get matched tutors // var turors = db.usp_GetTutors(objReq.fkSubjectId, Convert.ToDecimal(objReq.latitude), Convert.ToDecimal(objReq.longitude),Convert.ToInt64(objReq.userId)).ToList(); // //save request to db and send push to tutor // SendRequest(objReq, turors, requestUniqueId); // return 1; // } //} internal int SaveTutorProfile(TutorProfile objReq) { tblTutorProfile profileData = new tblTutorProfile(); using(var db=new WizzDataContext()){ profileData = db.tblTutorProfiles.Where(x => x.fkUserId == Convert.ToInt64(objReq.userId) && x.isDelete!=true).FirstOrDefault(); if (profileData == null) { //objReq.fileName profileData = new tblTutorProfile(); profileData.isApproved = false; profileData.isActive = true; profileData.isDelete = false; profileData.fkUserId = Convert.ToInt64(objReq.userId); //profileData.latitude = Convert.ToDecimal(objReq.latitude); //profileData.longitude = Convert.ToDecimal(objReq.longitude); //profileData.subjects = objReq.majors; profileData.TimeStamp = Convert.ToInt64(objReq.timeStamp); profileData.updatedDate = DateTime.UtcNow; profileData.createdDate = DateTime.UtcNow; profileData.passingYear = objReq.passingYear; // profileData.referralcode = objReq.referalCode==null?"": objReq.referalCode; // profileData.fkClassId = String.Join(",", objReq.classes); // profileData.docName = objReq.fileName; //profileData. = Convert.ToInt32(objReq.collegeId); db.tblTutorProfiles.InsertOnSubmit(profileData); } else { profileData.isApproved = false; profileData.isActive = true; //profileData.fkUserId = Convert.ToInt64(objReq.userId); //profileData.latitude = Convert.ToDecimal(objReq.latitude); //profileData.longitude = Convert.ToDecimal(objReq.longitude); //profileData.subjects = objReq.majors; //profileData.passingYear = objReq.passingYear; //profileData.docName = objReq.fileName; profileData.TimeStamp = Convert.ToInt64(objReq.timeStamp); profileData.updatedDate = DateTime.UtcNow; profileData.createdDate = DateTime.UtcNow; // profileData.fkClassId = String.Join(",", objReq.classes); //profileData.fkCollegeId = Convert.ToInt32(objReq.collegeId); } db.SubmitChanges(); return 1; } }
public Response<string> SaveTutorProfile() { TutorProfile objReq = new TutorProfile(); Response<string> response = new Response<string>(); List<string> objResp = new List<string>(); int resp = 0; try { RequestMethods objDBMethod = new RequestMethods(); if (CheckRequestIsvalidornot(this.Request)) { HttpContextWrapper objwrapper = GetHttpContext(this.Request); HttpFileCollectionBase collection = objwrapper.Request.Files; string jsonvalue = objwrapper.Request.Form["json"]; if (!string.IsNullOrEmpty(jsonvalue)) { objReq = JsonConvert.DeserializeObject<TutorProfile>(jsonvalue); objReq.fileName = SaveFile(collection, objReq.fileName); if (objReq.fileName == "") response.Create(false, Messages.InvalidFormat, Messages.AppVersion, objResp); else resp = objDBMethod.SaveTutorProfile(objReq); if (resp == 1) { response.Create(true, "Profile saved successfully", Messages.AppVersion, objResp); } else { response.Create(false, Messages.FormatMessage(Messages.ErrorOccure), 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; }