public void TestEf()
{
using (userEntities data = new userEntities())
{
//using (var dbContextTransaction = data.Database.BeginTransaction())
using (TransactionScope trnaScope = new TransactionScope())
{
try
{
user_base user = new user_base();
user.phone = "13022003660";
user.is_actor = 1;
user.reg_time = 11111;
user.status = 1;
user.user_email = "1231";
user.user_nick = "nick1111";
user.user_pwd = "123";
data.user_base.Add(user);
int irent = data.SaveChanges();
if (irent == 1)
{
var da = data.user_base.Remove(user);
int nn = data.SaveChanges();
}
trnaScope.Complete();
// dbContextTransaction.Commit();
}
catch (Exception ex)
{
//dbContextTransaction.Rollback();
}
}
}
}
public bool SaveActor(UserInfo userInfo)
{
using (userEntities data = new userEntities())
{
using (var dbContextTransaction = data.Database.BeginTransaction())
{
try
{
var exsit = data.user_base.Where(p => p.phone == userInfo.Phone).ToList();
if (exsit.Count > 0)
{
exsit[0].is_actor = 1;
exsit[0].status = 1;
exsit[0].user_nick = userInfo.Alias;
}
else
{
user_base userBase = new user_base();
userBase.is_actor = 1;
userBase.phone = userInfo.Phone;
userBase.reg_time = HelpFunction.ConvertToTimestamp(DateTime.Now);
userBase.status = 1;
userBase.user_pwd = CryptUtil.MD5("123456");
userBase.user_nick = userInfo.Alias;
data.user_base.Add(userBase);
}
int num = data.SaveChanges();
if (num > 0)
{
var us = data.user_base.Where(p => p.phone == userInfo.Phone).ToList();
if (us.Count > 0)
{
user_detail userDetail = new user_detail();
userDetail.user_uid = us[0].user_uid;
userDetail.user_city_id = userInfo.CityId;
userDetail.user_birth = userInfo.BirthDay;
userDetail.user_career = userInfo.Career;
userDetail.user_fronticon = userInfo.FrontIcon;
userDetail.user_gender = userInfo.Gender;
userDetail.user_icon = userInfo.HeadImg;
userDetail.user_intro = userInfo.Intro;
userDetail.user_video = userInfo.ShowVideo;
data.user_detail.Add(userDetail);
foreach (var tag in userInfo.Tags)
{
user_label label = new user_label();
label.user_uid = us[0].user_uid;
label.label_text = tag;
data.user_label.Add(label);
}
data.SaveChanges();
}
}
dbContextTransaction.Commit();
return(true);
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
Trace.WriteLine(ex);
}
return(false);
}
}
}
