public int UpdateServiceInformationBuIndID(ServiceInformation serviceInformation) { iwaywardDataContext db = new iwaywardDataContext(); try { var result = db.ServiceInformation.Single(c => c.ServicID == serviceInformation.ServicID && c.UserID == serviceInformation.UserID); result.title = serviceInformation.title; result.serviceTyoe = serviceInformation.serviceTyoe; result.sendTime = serviceInformation.sendTime; result.IndID = serviceInformation.IndID; result.region = serviceInformation.region; result.city = serviceInformation.city; result.province = serviceInformation.province; result.macrk = serviceInformation.macrk; result.longitude = serviceInformation.longitude; result.latitude = serviceInformation.latitude; db.SubmitChanges(); return(result.ServicID); } catch { return(0); } }
/// <summary> /// 根据resumeId修改简历信息 /// </summary> /// <param name="r"></param> /// <returns></returns> public string UpdatResumeByResumeID(resume r) { iwaywardDataContext db = new iwaywardDataContext(); try { var result = (from item in db.resume where item.resumeID == r.resumeID select item).Single(); result.resumeID = r.resumeID; result.userID = r.userID; result.jobState = r.jobState; result.resumeState = r.resumeState; result.myEdu = r.myEdu; result.jobYear = r.jobYear; result.toAddress = r.toAddress; result.industry = r.industry; result.position = r.position; result.salary = r.salary; result.research = r.research; result.jobID = r.jobID; result.projectID = r.projectID; db.SubmitChanges(); return(result.resumeID.ToString()); } catch { return(string.Empty); } }
public int UpdatePositionInfoByJobID(positionInfo post) { iwaywardDataContext db = new iwaywardDataContext(); try { var result = (from item in db.positionInfo where item.posID == post.posID select item).Single(); result.posID = post.posID; result.userID = post.userID; result.companyID = post.companyID; result.posName = post.posName; result.createTime = post.createTime; result.region = post.region; result.city = post.city; result.province = post.province; result.record = post.record; result.recruitment = post.recruitment; result.range = post.range; result.posstate = post.posstate; result.posType = post.posType; result.requirements = post.requirements; db.SubmitChanges(); return(int.Parse(result.posID.ToString())); } catch { return(0); } }
/// <summary> /// 根据UserId修改用户信息 /// </summary> /// <param name="user"></param> /// <returns></returns> public string UpdateUserInfoByUserID(UserInfo user) { iwaywardDataContext db = new iwaywardDataContext(); try { var result = (from item in db.UserInfo where item.userID == user.userID select item).Single(); result.userName = user.userName; result.age = user.age; result.sex = user.sex; result.headUrl = user.headUrl; result.nickName = user.nickName; result.region = user.region; result.city = user.city; result.province = user.province; result.mail = user.mail; result.qqNo = user.qqNo; result.sinaID = user.sinaID; result.tengID = user.tengID; result.weixinID = user.weixinID; result.weixinName = user.weixinName; result.weixinTwo = user.weixinTwo; result.professional = user.professional; result.industry = user.industry; result.position = user.position; result.erweima = user.erweima; result.zhuceTime = user.zhuceTime; result.qianming = user.qianming; db.SubmitChanges(); return(result.userID); } catch { return(string.Empty); } }
public int DeletePositionInfoByJobID(int posID) { int count = 0; iwaywardDataContext db = new iwaywardDataContext(); var user = from c in db.positionInfo where c.posID == posID select c; if (user.Count() > 0) { db.positionInfo.DeleteAllOnSubmit(user); count = db.positionInfo.Where(c => c.posID == posID).Count(); } return(count); }
public int DeleteCompanyTableByComId(int companyID) { int count = 0; iwaywardDataContext db = new iwaywardDataContext(); var user = from c in db.companyTable where c.companyID == companyID select c; if (user.Count() > 0) { db.companyTable.DeleteAllOnSubmit(user); count = db.companyTable.Where(c => c.companyID == companyID).Count(); } return(count); }
public int DeleteCodeByCodeID(string CodeID) { int count = 0; iwaywardDataContext db = new iwaywardDataContext(); var code = from c in db.CODE where c.CodeID == CodeID select c; if (code.Count() > 0) { db.CODE.DeleteAllOnSubmit(code); count = db.CODE.Where(c => c.CodeID == CodeID).Count(); } return(count); }
public int DeleteIndustryByIndID(int indID) { int count = 0; iwaywardDataContext db = new iwaywardDataContext(); var user = from c in db.industry where c.IndID == indID select c; if (user.Count() > 0) { db.industry.DeleteAllOnSubmit(user); count = db.industry.Where(c => c.IndID == indID).Count(); } return(count); }
public int DeleteJobTableByJobID(int jobID) { int count = 0; iwaywardDataContext db = new iwaywardDataContext(); var user = from c in db.jobTable where c.jobID == jobID select c; if (user.Count() > 0) { db.jobTable.DeleteAllOnSubmit(user); count = db.jobTable.Where(c => c.jobID == jobID).Count(); } return(count); }
//根据resumeId删除简历信息 public int DeleteResumeByResumeID(int resumeId) { int count = 0; iwaywardDataContext db = new iwaywardDataContext(); var user = from c in db.resume where c.resumeID == resumeId select c; if (user.Count() > 0) { db.resume.DeleteAllOnSubmit(user); count = db.resume.Where(c => c.resumeID == resumeId).Count(); } return(count); }
public int DeleteCommentByCommID(int CommId) { int count = 0; iwaywardDataContext db = new iwaywardDataContext(); var comment = from c in db.comments where c.commID == CommId select c; if (comment.Count() > 0) { db.comments.DeleteAllOnSubmit(comment); count = db.comments.Where(c => c.commID == CommId).Count(); } return(count); }
//根据UserID删除用户信息 public int DeleteUserInfoByUserID(string userID) { int count = 0; iwaywardDataContext db = new iwaywardDataContext(); var user = from c in db.UserInfo where c.userID == userID select c; if (user.Count() > 0) { db.UserInfo.DeleteAllOnSubmit(user); count = db.UserInfo.Where(c => c.userID == userID).Count(); } return(count); }
public int DeletePersonnelRelationshipByUserID(string userID) { int count = 0; iwaywardDataContext db = new iwaywardDataContext(); var user = from c in db.PersonnelRelationship where c.UserID == userID select c; if (user.Count() > 0) { db.PersonnelRelationship.DeleteAllOnSubmit(user); count = db.PersonnelRelationship.Where(c => c.UserID == userID).Count(); } return(count); }
public int DeleteServiceInformationByIndID(int ServiceID) { int count = 0; iwaywardDataContext db = new iwaywardDataContext(); var code = from c in db.ServiceInformation where c.ServicID == ServiceID select c; if (code.Count() > 0) { db.ServiceInformation.DeleteAllOnSubmit(code); count = db.ServiceInformation.Where(c => c.ServicID == ServiceID).Count(); } return(count); }
/// <summary> /// 获取简历信息 /// </summary> /// <returns></returns> public IList <resume> GetResume() { iwaywardDataContext db = new iwaywardDataContext(); IEnumerable <resume> r = from c in db.resume select c; if (r != null) { return(r.ToList <resume>()); } else { return(new List <resume>()); } }
public IList <positionInfo> GetListPositionInfo(int posID) { iwaywardDataContext db = new iwaywardDataContext(); IEnumerable <positionInfo> attInd = from c in db.positionInfo where c.posID == posID select c; if (attInd != null) { return(attInd.ToList <positionInfo>()); } else { return(null); } }
public ServiceInformation GetServiceInformation(int ServiceID, string UserId) { iwaywardDataContext db = new iwaywardDataContext(); if (db.ServiceInformation.Count() > 0) { var code = db.ServiceInformation.Single(c => c.ServicID == ServiceID && c.UserID == UserId); return(code); } else { return(null); } }
public IList <servicepipei> GetServicepipei() { iwaywardDataContext db = new iwaywardDataContext(); IEnumerable <servicepipei> attInd = from c in db.servicepipei select c; if (attInd != null) { return(attInd.ToList <servicepipei>()); } else { return(new List <servicepipei>()); } }
/// <summary> /// 根据UserId获取用户信息 /// </summary> /// <param name="userID"></param> /// <returns></returns> public UserInfo GetUserInfo(string userID) { iwaywardDataContext db = new iwaywardDataContext(); if (db.UserInfo.Count() > 0) { var user = db.UserInfo.Single(c => c.userID == userID); return(user); } else { return(null); } }
public comments GetComment(int commID) { iwaywardDataContext db = new iwaywardDataContext(); if (db.comments.Count() > 0) { var comm = db.comments.Single(c => c.commID == commID); return(comm); } else { return(null); } }
public AttentionIndustry GetAttentionIndustry(string UserId) { iwaywardDataContext db = new iwaywardDataContext(); if (db.AttentionIndustry.Count() > 0) { var user = db.AttentionIndustry.Single(c => c.UserID == UserId); return(user); } else { return(null); } }
public IList <AttentionIndustry> GetAttentionIndustry() { iwaywardDataContext db = new iwaywardDataContext(); IEnumerable <AttentionIndustry> attInd = from c in db.AttentionIndustry select c; if (attInd != null) { return(attInd.ToList <AttentionIndustry>()); } else { return(new List <AttentionIndustry>()); } }
public servicepipei GetServicepipei(string UserId) { iwaywardDataContext db = new iwaywardDataContext(); if (db.servicepipei.Count() > 0) { var user = db.servicepipei.Single(c => c.UserID == UserId); return(user); } else { return(null); } }
/// <summary> /// 根据resumeId获取简历信息 /// </summary> /// <param name="resumeId"></param> /// <returns></returns> public resume GetResume(int resumeId) { iwaywardDataContext db = new iwaywardDataContext(); if (db.resume.Count() > 0) { var r = db.resume.Single(c => c.resumeID == resumeId); return(r); } else { return(null); } }
public companyTable GetCompanyTable(int companyID) { iwaywardDataContext db = new iwaywardDataContext(); if (db.companyTable.Count() > 0) { var user = db.companyTable.Single(c => c.companyID == companyID); return(user); } else { return(null); } }
public IList <ServiceInformation> GetServiceInformationforUserId(string UserId) { iwaywardDataContext db = new iwaywardDataContext(); IEnumerable <ServiceInformation> codes = from c in db.ServiceInformation where c.UserID == UserId select c; if (codes != null) { return(codes.ToList <ServiceInformation>()); } else { return(null); } }
/// <summary> /// 获取用户信息 /// </summary> /// <returns></returns> public IList <UserInfo> GetUserInfo() { iwaywardDataContext db = new iwaywardDataContext(); IEnumerable <UserInfo> userInfo = from c in db.UserInfo select c; if (userInfo != null) { return(userInfo.ToList <UserInfo>()); } else { return(new List <UserInfo>()); } }
public IList <ServiceInformation> GetServiceInformation() { iwaywardDataContext db = new iwaywardDataContext(); IEnumerable <ServiceInformation> codes = from c in db.ServiceInformation select c; if (codes != null) { return(codes.ToList <ServiceInformation>()); } else { return(null); } }
public IList <comments> GetComment() { iwaywardDataContext db = new iwaywardDataContext(); IEnumerable <comments> comm = from c in db.comments select c; if (comm != null) { return(comm.ToList <comments>()); } else { return(new List <comments>()); } }
public positionInfo GetPositionInfo(int posID) { iwaywardDataContext db = new iwaywardDataContext(); if (db.positionInfo.Count() > 0) { var user = db.positionInfo.Single(c => c.posID == posID); return(user); } else { return(null); } }