public object creatReqUser(userinfo rn, List<VahedUser> rgr)
{
Results<string> result = new Results<string>();
try
{
HelperData h = new HelperData();
db.Connection.Open();
using (db.Transaction = db.Connection.BeginTransaction())
rn.pass = new CustomMembershipProvider().EncryptPassword(rn.pass);
rn.deleted = false;
Int16 t = h.AddUserInfo(rn);
if (t!=0)
{
bool s = h.AddVahedUser(rgr, t);
if (s)
{
// db.Transaction.Commit();
result.IsSuccessfull = true;
}
}
}
catch (Exception error)
{
db.Transaction.Rollback();
result.IsSuccessfull = false;
result.Message = error.Message;
}
return result;
}
//Edit UserInfo Table
public int EditUserInfo(userinfo ui)
{
try
{
var v = from i in db.userinfos
where i.userCode == ui.userCode
select i;
userinfo newuser = v.FirstOrDefault();
if(newuser!= null)
{
newuser.userCode = ui.userCode;
newuser.fName = ui.fName;
newuser.lName = ui.lName;
newuser.userName = ui.userName;
newuser.pass = ui.pass;
newuser.email = ui.email;
newuser.mobile = ui.mobile;
newuser.zoneCode = ui.zoneCode;
newuser.deleted = false;
db.SubmitChanges();
return 1;
}
return 0;//not found
}
catch (Exception error)
{
return -1;
}
}
//Add To UserInfo Table
public Int16 AddUserInfo(userinfo ui)
{
try{
db.userinfos.InsertOnSubmit(ui);
db.SubmitChanges();
return ui.userCode;
}
catch (Exception error)
{
return 0;
}
}
partial void Deleteuserinfo(userinfo instance);
partial void Updateuserinfo(userinfo instance);
partial void Insertuserinfo(userinfo instance);
private void detach_userinfos(userinfo entity)
{
this.SendPropertyChanging();
entity.zoneInfo = null;
}
private void attach_userinfos(userinfo entity)
{
this.SendPropertyChanging();
entity.zoneInfo = this;
}
public static string UpdateReqUser(userinfo rn)
{
UserReqBLL fb = new UserReqBLL();
return JsonConvert.SerializeObject(fb.UpdateReqUser(rn));
}
public static string creatReqUser(userinfo rn, List<VahedUser> rgr)
{
UserReqBLL fb = new UserReqBLL();
return JsonConvert.SerializeObject(fb.creatReqUser(rn,rgr));
}
public object UpdateReqUser(userinfo rn)
{
Results<string> result = new Results<string>();
try
{
HelperData h = new HelperData();
rn.pass = new CustomMembershipProvider().EncryptPassword(rn.pass);
int t = h.EditUserInfo(rn);
if (t == 1)
{
result.IsSuccessfull = true;
}
}
catch (Exception error)
{
result.IsSuccessfull = false;
result.Message = error.Message;
}
return result;
}
