protected void Page_Load(object sender, EventArgs e)
{
if (Session["login"] == null)
{
lbtnUser.Visible = false;
lbtncart.Visible = true;
lbtnlogin.Visible = true;
lbtnlog.Visible = false;
lbtnbanner.Visible = false;
lbtnCate.Visible = false;
lbtnProd.Visible = false;
lbtnuserCart.Visible = false;
}
else
{
idus = Convert.ToInt32(Session["Login"]);
un = cl.getUserbyID(idus);
lblUser.Text = un.user_fullname;
imguser.ImageUrl = "images/Userimg/" + un.user_pro_image;
lbtnUser.Visible = true;
lbtncart.Visible = false;
lbtnlogin.Visible = false;
lbtnlog.Visible = true;
lbtnbanner.Visible = true;
lbtnCate.Visible = true;
lbtnProd.Visible = true;
lbtnuserCart.Visible = true;
}
}
public void UpdateUserPass(user_detail un)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.user_details.Where(d => d.user_id == un.user_id).SingleOrDefault();
q.user_password = un.user_password;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
// build claims array from user data
public static Claim[] GetUserClaims(user_detail repoUserDetail)
{
return(new Claim[]
{
new Claim(JwtRegisteredClaimNames.UniqueName, repoUserDetail.id_userNavigation.username ?? ""),
// new Claim(JwtClaimTypes.Name, repoUserDetail.name ?? ""),
new Claim("nameShorthand", repoUserDetail.name_shorthand),
// new Claim(JwtClaimTypes.Email, repoUserDetail.email ?? ""),
// new Claim(JwtClaimTypes.PhoneNumber, "0815171628347" ?? ""),
// new Claim("ext", repoUserDetail.ext ?? ""),
// new Claim("warehouse", "WAREHOUSE"),
// new Claim("branch", "BRANCH"),
// new Claim("unit", "UNIT")
});
}
//Save New User Implementation
private void SaveNewUser()
{
user newUser = new user();
newUser.salutation = comboBoxSalutaion.Text.Trim();
newUser.firstname = txtFirstName.Text.Trim();
newUser.lastname = txtSurname.Text.Trim();
newUser.other_name = txtOtherName.Text.Trim();
newUser.affix = comboBoxAffix.Text.Trim();
newUser.sex = comboBoxSex.Text.Trim();
newUser.email = txtEmail.Text.Trim();
newUser.doctor = txtDoctor.Text.Trim();
newUser.username = txtUsername.Text.Trim();
newUser.acronym = txtAcronym.Text.Trim();
newUser.password = txtPassword.Text.Trim();
newUser.confirm_password = txtConfirmPassword.Text.Trim();
newUser.image = (userPictureBox.ImageLocation != null) ? ConvertPicture(userPictureBox.ImageLocation) : newUser.image;
newUser.isActive = (checkBoxActive.Checked) ? active + 1 : active;
foreach (var item in checkedListBox1.CheckedItems)
{
CheckListBoxItem citem = (CheckListBoxItem)item;
user_detail user_Detail = new user_detail();
user_Detail.department_id = citem.Tag;
newUser.user_detail.Add(user_Detail);
}
bool validationResult = ValidateFields();
bool chkPassword = PaswordChecker(newUser.password, newUser.confirm_password);
if (!validationResult)
{
MessageBox.Show("Enter Required Fields!", "Error");
}
else if (!chkPassword)
{
MessageBox.Show("Password is not valid or does not match", "Error");
}
else
{
using (emedEntities db = new emedEntities())
{
db.users.Add(newUser);
db.SaveChanges();
MessageBox.Show("New User Added Successfully!", "Message");
Close();
}
}
}
public void load_us()
{
if (ck.checkQuantity(Request.QueryString["id"]))
{
idus = Convert.ToInt32(Request.QueryString["id"]);
un = cl.getUserbyID(idus);
txtName.Text = un.user_fullname;
txtAge.Text = un.user_age + "";
txtEmail.Text = un.user_email;
lblUsname.Text = un.user_name;
imgava.ImageUrl = "images/Userimg/" + un.user_pro_image;
}
else
{
Response.Redirect("404.html");
}
}
public void UpdateUser(user_detail un)
{
try
{
LQDataContext ctxx = new LQDataContext();
var q = ctxx.user_details.Where(d => d.user_id == un.user_id).SingleOrDefault();
q.user_name = un.user_name;
q.user_fullname = un.user_fullname;
q.user_pro_image = un.user_pro_image;
q.user_age = un.user_age;
q.user_email = un.user_email;
ctxx.SubmitChanges();
}
catch (Exception ex)
{
}
}
public user_detail[] user_list(string user_name, string password)
{
// 03/12/2007 Paul. If using NTLM, then user_name will be updated with value from Identity object.
Guid gUSER_ID = LoginUser(ref user_name, password);
if ( !IsAdmin(gUSER_ID) )
{
L10N L10n = new L10N("en-US");
throw(new Exception(L10n.Term("ACL.LBL_INSUFFICIENT_ACCESS")));
}
user_detail[] results = new user_detail[0];
DbProviderFactory dbf = DbProviderFactories.GetFactory();
using ( IDbConnection con = dbf.CreateConnection() )
{
con.Open();
string sSQL;
sSQL = "select * " + ControlChars.CrLf
+ " from vwSOAP_User_List" + ControlChars.CrLf
+ " where 1 = 1 " + ControlChars.CrLf;
using ( IDbCommand cmd = con.CreateCommand() )
{
cmd.CommandText = sSQL;
try
{
using ( DbDataAdapter da = dbf.CreateDataAdapter() )
{
((IDbDataAdapter)da).SelectCommand = cmd;
using ( DataTable dt = new DataTable() )
{
da.Fill(dt);
if ( dt.Rows.Count > 0 )
{
// 02/20/2006 Paul. First initialize the array.
results = new user_detail[dt.Rows.Count];
for ( int i=0; i < dt.Rows.Count ; i++ )
{
// 02/20/2006 Paul. Then initialize each element in the array.
results[i] = new user_detail();
results[i].email_address = Sql.ToString(dt.Rows[i]["EMAIL_ADDRESS"]);
results[i].user_name = Sql.ToString(dt.Rows[i]["USER_NAME" ]);
results[i].first_name = Sql.ToString(dt.Rows[i]["FIRST_NAME" ]);
results[i].last_name = Sql.ToString(dt.Rows[i]["LAST_NAME" ]);
results[i].department = Sql.ToString(dt.Rows[i]["DEPARTMENT" ]);
results[i].id = Sql.ToString(dt.Rows[i]["ID" ]);
results[i].title = Sql.ToString(dt.Rows[i]["TITLE" ]);
}
}
}
}
}
catch(Exception ex)
{
SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex);
throw(new Exception("SOAP: Failed user_list", ex));
}
}
}
return results;
}
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);
}
}
}
