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; } } }
public Response<string> SaveTutorProfile() { TutorProfileModel objReq = new TutorProfileModel(); Response<string> response = new Response<string>(); List<string> objResp = new List<string>(); int resp = 0; try { objDbMethodV2 = new wizz.Dal.DbMethodsV2(); 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<TutorProfileModel>(jsonvalue); List<string> newFileNames = new List<string>(); newFileNames = SaveMultipleFiles(collection, ""); // objReq.fileNameList = newFileNames; if (newFileNames.Count == 0) response.Create(false, "No Transcripts is uploaded please try again !", Messages.AppVersion, objResp); else resp = objDbMethodV2.SaveTutorProfile(objReq, newFileNames); if (resp == 1) { response.Create(true, "Tutor profile info saved successfully !", Messages.AppVersion, objResp); } else { response.Create(false, Messages.FormatMessage(Messages.ErrorOccure), Messages.AppVersion, objResp); } } } return response; } 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; }