public ResultHelper AddUserContact(UserContactDto userContactDto) { try { if (IsThere(userContactDto)) { return(new ResultHelper(false, 0, ResultHelper.UnSuccessMessage)); } usercontact item = new usercontact(); item.UserID = userContactDto.UserID; item.UserContactID = userContactDto.UserContactID; item.UserContactTypeID = userContactDto.UserContactTypeID; item.Contact = userContactDto.Contact; using (UnitOfWork unitofWork = new UnitOfWork()) { unitofWork.GetRepository <usercontact>().Insert(item); unitofWork.saveChanges(); return(new ResultHelper(true, item.UserContactID, ResultHelper.SuccessMessage)); } } catch (Exception ex) { return(new ResultHelper(false, 0, ResultHelper.UnSuccessMessage + "\n" + ResultHelper.IsThereItem)); } }
public UserContactDto GetUserContact(int UserContactID) { try { using (UnitOfWork unitofWork = new UnitOfWork()) { usercontact item = new usercontact(); item = unitofWork.GetRepository <usercontact>().GetById(x => x.UserContactID == UserContactID); UserContactDto userContactDto = new UserContactDto(); userContactDto.UserContactID = item.UserContactID; userContactDto.UserID = item.UserID.Value; userContactDto.UserContactTypeID = item.UserContactTypeID.Value; userContactDto.Contact = item.Contact; return(userContactDto); } } catch (Exception) { return(new UserContactDto()); } }
public ResultHelper SetUserContact(UserContactDto userContactDto) { try { usercontact item = new usercontact(); item.UserContactID = userContactDto.UserContactID; item.UserID = userContactDto.UserID; item.UserContactTypeID = userContactDto.UserContactTypeID; item.Contact = userContactDto.Contact; using (UnitOfWork unitofWork = new UnitOfWork()) { unitofWork.GetRepository <usercontact>().Update(item); unitofWork.saveChanges(); return(new ResultHelper(true, item.UserContactID, ResultHelper.SuccessMessage)); } } catch (Exception) { return(new ResultHelper(false, userContactDto.UserContactID, ResultHelper.UnSuccessMessage)); } }
public static int adminMail() { int result = 0; string emailTitle = "一条新的众创空间申请等待处理"; using (var db = new Entities()) { var adminList = (from it in db.usercontact where it.usclass == 1 select it).ToList(); if (adminList.Count == 0) { return(0); } for (int i = 0; i < adminList.Count; i++) { usercontact my = adminList[i]; string emailContent = "尊敬的" + my.usname + ",有一条新的众创空间申请等待处理,请您点击以下页面进入<a href =\"#\">点我</a>"; Mail.SendEmail(myEmail, myPassword, my.usemail, emailTitle, emailContent, myHost); result++; } } return(result); }
protected void RptCon_ItemCommand(object source, RepeaterCommandEventArgs e) { int Cid = 0; try { Cid = Convert.ToInt32(e.CommandArgument); } catch { return; } if (e.CommandName == "del") { using (var db = new Entities()) { usercontact uc = db.usercontact.FirstOrDefault(a => a.id == Cid); db.usercontact.Remove(uc); db.SaveChanges(); Response.Write("<script>alert('删除成功');window.location.href='ContactList.aspx'</script>"); } } }
public static int teacherMail(applications things) { int result = 0; string emailTitle = "一条新的众创空间申请已经被同意"; DateTime dt = new DateTime(); TimeTrans.UnixTimestampToDateTime(dt, things.apptime); string appDate = dt.ToString("yyyy年MM月dd日"); string DateState = ""; switch (things.state) { case 0: DateState = "上午"; break; case 1: DateState = "下午"; break; case 2: DateState = "晚上"; break; } using (var db = new Entities()) { var teacherList = (from it in db.usercontact where it.usclass == 0 select it).ToList(); if (teacherList.Count == 0) { return(0); } for (int i = 0; i < teacherList.Count; i++) { usercontact my = teacherList[i]; string emailContent = "尊敬的" + my.usname + ",由申请人:" + things.stuname + ",提出的于" + appDate + " " + DateState + "的申请已被同意。申请理由为:" + things.body + "\n如有安排请通知爱特工作室"; Mail.SendEmail(myEmail, myPassword, my.usemail, emailTitle, emailContent, myHost); result++; } } return(result); }
protected void BtnSub_Click(object sender, EventArgs e) { int IfC = 0; string tname = TxtName.Text.Trim(); string temail = TxtEmail.Text.Trim(); int level = -1; if (Rad0.Checked) { level = 0; } if (Rad1.Checked) { level = 1; } if (level < 0) { Response.Write("<script>alert('请选择一个权限')</script>"); return; } else if (tname == "") { Response.Write("<script>alert('请填写姓名')</script>"); return; } else if (temail == "") { Response.Write("<script>alert('请填写')</script>"); return; } try { IfC = Convert.ToInt32(Request.QueryString["id"]); using (var db = new Entities()) { usercontact us = db.usercontact.FirstOrDefault(a => a.id == IfC); var usCheck = (from it in db.usercontact where it.usname == tname && it.usemail == temail && it.usclass == level select it).ToList(); if (usCheck.Count != 0) { Response.Write("<script>alert('修改后不能跟已存在信息相同')</script>"); return; } us.usname = tname; us.usemail = temail; us.usclass = level; db.SaveChanges(); Response.Write("<script>alert('修改成功');window.location.href='ContactList.aspx'</script>"); } } catch { using (var db = new Entities()) { usercontact us = new usercontact(); var usCheck = (from it in db.usercontact where it.usname == tname && it.usemail == temail && it.usclass == level select it).ToList(); if (usCheck.Count != 0) { Response.Write("<script>alert('添加联系人不能跟已存在信息相同')</script>"); return; } us.usname = tname; us.usemail = temail; us.usclass = level; db.usercontact.Add(us); db.SaveChanges(); Response.Write("<script>alert('添加成功');window.location.href='ContactList.aspx'</script>"); } } }