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 bool SaveSubjectsForTutor(SubjectsListModel objReq)
{
using (var db = new WizzDataContext())
{
int tutorId = Convert.ToInt32(objReq.userId);
// List<tblTutorSubject> objSubject = new List<tblTutorSubject>();
var objSubjectDbList = db.usp_GetSubjectsForTutor(tutorId).ToList();
tblTutorSubject listObj = new tblTutorSubject();
if (objReq.subjectsIdList!=null&&objReq.subjectsIdList.Count != 0)
{
foreach (var n in objSubjectDbList)
{
var data = objReq.subjectsIdList.Where(x => x == Convert.ToString(n.subjectId)).FirstOrDefault();
//data is null and n.isadded false h means not in all list wont be added wont be deleted
//data is null and n.isadded true h deleted from subject table
// if not null then check is added if yes den leave
//if not null and is added false insert
//if not null and is added true then do nothing
if (data == null && n.isApplied == "True")
{
var tutorSub = db.tblTutorSubjects.Where(x => x.fkSubjectId == n.subjectId&&x.fkTutorId==Convert.ToInt64(objReq.userId)).FirstOrDefault();
db.tblTutorSubjects.DeleteOnSubmit(tutorSub);
db.SubmitChanges();
}
else if (data != null)
{
if (n.isApplied == "False")
{
var tutorSub = new tblTutorSubject();
tutorSub.fkTutorId = Convert.ToInt64(objReq.userId);
tutorSub.fkSubjectId = Convert.ToInt64(data);
tutorSub.isApproved = false;
db.tblTutorSubjects.InsertOnSubmit(tutorSub);
db.SubmitChanges();
//insert with is approved false in tutorsubject
}
}
}
}
return true;
}
}
internal bool SetTutorSubjects(TutorSubjectModel objReq)
{
using (var db = new WizzDataContext())
{
List<tblTutorSubject> objTutorSubList = new List<tblTutorSubject>();
Int64 userId = Convert.ToInt64(objReq.userId);
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 (var n in objReq.subjectIdList)
{
tblTutorSubject objTutorSubject = new tblTutorSubject();
objTutorSubject.isApproved =Convert.ToBoolean(n.isApproved);
objTutorSubject.fkSubjectId = Convert.ToInt32(n.id);
objTutorSubject.fkTutorId = userId;
objTutorSubject.subjectType = 3;
objTutorSubList.Add(objTutorSubject);
}
if (objReq.classIdList.Count > 0)
foreach (var n in objReq.classIdList)
{
tblTutorSubject objTutorSubject = new tblTutorSubject();
objTutorSubject.isApproved = Convert.ToBoolean(n.isApproved);
objTutorSubject.fkSubjectId = Convert.ToInt32(n.id);
objTutorSubject.fkTutorId = userId;
objTutorSubject.subjectType = 2;
objTutorSubList.Add(objTutorSubject);
}
if (objReq.courseIdList.Count > 0)
{
foreach (var n in objReq.courseIdList)
{
tblTutorSubject objTutorSubject = new tblTutorSubject();
objTutorSubject.isApproved = Convert.ToBoolean(n.isApproved);
objTutorSubject.fkSubjectId = Convert.ToInt32(n.id);
objTutorSubject.fkTutorId = userId;
objTutorSubject.subjectType = 1;
objTutorSubList.Add(objTutorSubject);
}
}
db.tblTutorSubjects.InsertAllOnSubmit(objTutorSubList);
db.SubmitChanges();
}
return true;
}
