public Models.ViewModel.CustomRegModel GetByUserID(int UserID)
{
User_cls_Service servic = new User_cls_Service();
DataTable dt = servic.Get(UserID, "");
return(User_cls.Convert(dt));
}
public static User_cls Convert(Esam.Models.ViewModel.CustomRegModel source)
{
User_cls user = new User_cls();
user.Email = source.email;
user.Username = source.email;
user.Lname = source.lname;
user.Fname = source.fname;
user.Password = source.password;
return(user);
}
public static SqlParameter SetParameterValue(SqlParameter param, User_cls value)
{
if (value == null)
{
param.Value = DBNull.Value;
}
else
{
SetParameterValue(param, value.UserID);
}
return(param);
}
public DBmessage RegisterUser(User_cls user)
{
User_cls_Service servic = new User_cls_Service();
DBmessage result = servic.Register(user);
if (result.Type == DBMessageType.Sucsess)
{
result.Parameter["UserID"] = user.UserID;
}
return(result);
}
public DBmessage Register(User_cls user)
{
SqlConnection newcon = new SqlConnection(DBMan.EsamConnection);
SqlCommand newcmd = new SqlCommand("UserRegister", newcon);
newcmd.CommandType = CommandType.StoredProcedure;
SqlParameter _userid = new SqlParameter("@UsrID", SqlDbType.Int);
_userid.Direction = ParameterDirection.Output;
SqlParameter _username = new SqlParameter("@UserName", SqlDbType.NVarChar, 100);
DBMan.SetParameterValue(_username, user.Username);
SqlParameter _password = new SqlParameter("@Password", SqlDbType.NVarChar, 100);
DBMan.SetParameterValue(_password, user.Password);
SqlParameter _name = new SqlParameter("@Fname", SqlDbType.NVarChar, 50);
DBMan.SetParameterValue(_name, user.Fname);
SqlParameter _family = new SqlParameter("@Lname", SqlDbType.NVarChar, 50);
DBMan.SetParameterValue(_family, user.Lname);
SqlParameter _email = new SqlParameter("@Email", SqlDbType.VarChar, 50);
DBMan.SetParameterValue(_email, user.Email);
//SqlParameter _CreateBy = new SqlParameter("@CreateBy", SqlDbType.Int);
//DBMan.SetParameterValue(_CreateBy, user.CreateBy);
newcmd.Parameters.Add(_userid);
newcmd.Parameters.Add(_username);
newcmd.Parameters.Add(_password);
newcmd.Parameters.Add(_name);
newcmd.Parameters.Add(_family);
newcmd.Parameters.Add(_email);
//newcmd.Parameters.Add(_CreateBy);
newcmd.Parameters.Add(DBMan.RetunParam);
newcon.Open();
newcmd.ExecuteNonQuery();
newcon.Close();
user.UserID = Convert.ToInt32(newcmd.Parameters[_userid.ParameterName].Value);
DBmessage ResultMessage = new DBmessage(Convert.ToInt32(newcmd.Parameters[DBMan.ReturnValue].Value));
return(ResultMessage);
}
public DBmessage RegisterRole(int userID, Role role, int createBy)
{
User_cls_Service servic = new User_cls_Service();
User_cls user = new User_cls()
{
UserID = userID, Roles = role, CreateBy = new User_cls()
{
UserID = createBy
}
};
return(servic.RegisterRole(user));
}
public static User_cls ConvertToUser(DataTable dt)
{
User_cls user = new User_cls();
foreach (DataRow item in dt.Rows)
{
if (item["UsrID"] != DBNull.Value)
{
user.UserID = Int32.Parse(item["UsrID"].ToString());
}
if (item["VerifyAccount"] != DBNull.Value)
{
user.VerifyAccount = new VerifyAccountType(Int32.Parse(item["VerifyAccount"].ToString()));
}
if (item["Fname"] != DBNull.Value)
{
user.Fname = item["Fname"].ToString();
}
if (item["Lname"] != DBNull.Value)
{
user.Lname = item["Lname"].ToString();
}
user.FullName = user.Fname + " " + user.Lname;
if (item["Email"] != DBNull.Value)
{
user.Email = item["Email"].ToString();
}
if (item["Active"] != DBNull.Value)
{
if (item["Active"].ToString() == "True")
{
user.Active = true;
}
else if (item["Active"].ToString() == "False")
{
user.Active = false;
}
}
}
return(user);
}
public DBmessage RegisterRole(User_cls user)
{
SqlCommand cmd = new SqlCommand("RoleRegister", new SqlConnection(DBMan.EsamConnection));
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter _admin = new SqlParameter("@Admin", SqlDbType.Bit);
SqlParameter _customer = new SqlParameter("@Customer", SqlDbType.Bit);
if (user.Roles != null)
{
_admin.Value = user.Roles[RoleType.Admin];
_customer.Value = user.Roles[RoleType.Customer];
}
else
{
_admin.Value = DBNull.Value;
_customer.Value = DBNull.Value;
}
SqlParameter _userID = new SqlParameter("@UserID", SqlDbType.Int);
DBMan.SetParameterValue(_userID, user);
SqlParameter _CreateBy = new SqlParameter("@CreateBy", SqlDbType.Int);
_CreateBy.Value = user.CreateBy.UserID;
cmd.Parameters.Add(_userID);
cmd.Parameters.Add(_admin);
cmd.Parameters.Add(_customer);
cmd.Parameters.Add(_CreateBy);
cmd.Parameters.Add(DBMan.RetunParam);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(new DBmessage(System.Convert.ToInt32(cmd.Parameters[DBMan.ReturnValue].Value)));
}
