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>");
}
}
}
