internal int SaveTutorProfile(TutorProfileModel objReq, List<string> fileNamesList) { using (var db = new WizzDataContext()) { try { long userId = Convert.ToInt64(objReq.userId); #region Multiple List work List<tblTutorDoc> objTutorDocList = new List<tblTutorDoc>(); objTutorDocList = db.tblTutorDocs.Where(x => x.fkTutorId == userId).ToList(); if (objTutorDocList.Count > 0) { db.tblTutorDocs.DeleteAllOnSubmit(objTutorDocList); db.SubmitChanges(); objTutorDocList = new List<tblTutorDoc>(); } foreach (string n in fileNamesList) { tblTutorDoc objDoc = new tblTutorDoc(); objDoc.createdDate = DateTime.UtcNow; objDoc.fileName = n; objDoc.fkTutorId = userId; objDoc.isDelete = false; objTutorDocList.Add(objDoc); } db.tblTutorDocs.InsertAllOnSubmit(objTutorDocList); List<tblTutorSubject> objTutorSubList = new List<tblTutorSubject>(); objTutorSubList = db.tblTutorSubjects.Where(x => x.fkTutorId == userId).ToList(); if (objTutorSubList.Count > 0) { db.tblTutorSubjects.DeleteAllOnSubmit(objTutorSubList); db.SubmitChanges(); objTutorSubList = new List<tblTutorSubject>(); } if (objReq.subjectIdList.Count > 0) foreach (string n in objReq.subjectIdList) { tblTutorSubject objTutorSubject = new tblTutorSubject(); objTutorSubject.isApproved = false; objTutorSubject.fkSubjectId = Convert.ToInt32(n); objTutorSubject.fkTutorId = userId; objTutorSubject.subjectType = 3; objTutorSubList.Add(objTutorSubject); } else if (objReq.classIdList.Count > 0) foreach (string n in objReq.classIdList) { tblTutorSubject objTutorSubject = new tblTutorSubject(); objTutorSubject.isApproved = false; objTutorSubject.fkSubjectId = Convert.ToInt32(n); objTutorSubject.fkTutorId = userId; objTutorSubject.subjectType = 2; objTutorSubList.Add(objTutorSubject); } else { foreach (string n in objReq.courseIdList) { tblTutorSubject objTutorSubject = new tblTutorSubject(); objTutorSubject.isApproved = false; objTutorSubject.fkSubjectId = Convert.ToInt32(n); objTutorSubject.fkTutorId = userId; objTutorSubject.subjectType = 1; objTutorSubList.Add(objTutorSubject); } } db.tblTutorSubjects.InsertAllOnSubmit(objTutorSubList); #endregion #region tableTutorprofileEntry tblTutorProfile objTutorProfile = new tblTutorProfile(); var previousProfileObj = db.tblTutorProfiles.Where(x => x.fkUserId == userId).FirstOrDefault(); if (previousProfileObj != null) db.tblTutorProfiles.DeleteOnSubmit(previousProfileObj); objTutorProfile.feesPerHour = objReq.feesPerHour; objTutorProfile.fkCollegeId = objReq.collegeId == null ? 0 : Convert.ToInt32(objReq.collegeId); objTutorProfile.referralCode = objReq.referralCode == null ? "" : objReq.referralCode; objTutorProfile.isApproved = false; //fake data entry for maintaining previous tblschema (not use ful) objTutorProfile.createdDate = DateTime.UtcNow; objTutorProfile.description = ""; objTutorProfile.passingYear = ""; //creating a unique search code for tutor objTutorProfile.tutorSearchCode = "W" + objReq.userName.Substring(0, 3) + System.Guid.NewGuid().ToString().Substring(0, 4); //getting radius for tutor objTutorProfile.distance = objReq.distanceRadius; objTutorProfile.fkUserId = userId; objTutorProfile.isActive = true; objTutorProfile.updatedDate = DateTime.UtcNow; objTutorProfile.TimeStamp = DateTime.UtcNow.Ticks; objTutorProfile.lat = Convert.ToDouble(objReq.latitude); objTutorProfile.longi = Convert.ToDouble(objReq.longitude); objTutorProfile.location = objReq.location; db.tblTutorProfiles.InsertOnSubmit(objTutorProfile); #endregion db.SubmitChanges(); return 1; } catch (Exception e) { return 0; } } }
//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; } }
internal string UpdateUser(UserModel objRequest) { tblUser objUser; tblTutorProfile objProfile; using (var db = new WizzDataContext()) { objUser = new tblUser(); long userId = Convert.ToInt64(objRequest.userId); objUser = db.tblUsers.FirstOrDefault(x => x.pkUserId == userId); if (objUser == null) { return "0"; } else if (objUser.isDelete ==true) { return "2"; } else { objProfile = new tblTutorProfile(); objProfile = db.tblTutorProfiles.Where(x => x.fkUserId == userId).FirstOrDefault(); if (objProfile == null) { objProfile = new tblTutorProfile(); objProfile.collegeName = objRequest.collageName; objUser.userName = objRequest.userName; //if (objUser.userEmail.ToLower().Trim() == objRequest.userEmail.ToLower().Trim()) //{ //} //else { // objUser.userEmail = objRequest.userEmail; // SendVerifyEmail(objRequest.userEmail, "1", objUser.pkUserId); //} objProfile.description = objRequest.description; objUser.updatedDate = DateTime.UtcNow; objProfile.passingYear = objRequest.passingYear; objUser.profilePic = objRequest.profilePic; objProfile.updatedDate = DateTime.UtcNow; objProfile.createdDate = DateTime.UtcNow; objProfile.fkUserId = userId; db.tblTutorProfiles.InsertOnSubmit(objProfile); } else { objProfile.updatedDate = DateTime.UtcNow; objProfile.createdDate = DateTime.UtcNow; objProfile.collegeName = objRequest.collageName; objUser.userName = objRequest.userName; //if (objUser.userEmail.ToLower().Trim() == objRequest.userEmail.ToLower().Trim()) //{ //} //else { // objUser.userEmail = objRequest.userEmail; // SendVerifyEmail(objRequest.userEmail, "1", objUser.pkUserId); //} objProfile.description = objRequest.description; objUser.updatedDate = DateTime.UtcNow; objProfile.passingYear = objRequest.passingYear; objUser.profilePic = objRequest.profilePic; } db.SubmitChanges(); return "1"; } } }