public BoUser Dao_getUserById(int pIdUser)
{
SqlConnection lConex = new SqlConnection();
using (lConex = Dao_SqlConnection(lConex))
{
var lUser = new BoUser();
try
{
var lCommand = new SqlCommand
{
CommandText = "spr_GetUserByIdUser",
CommandTimeout = 30,
CommandType = CommandType.StoredProcedure,
Connection = lConex
};
lCommand.Parameters.Add(new SqlParameter("IdUser", pIdUser));
var lReader = lCommand.ExecuteReader();
if (lReader.HasRows)
{
while (lReader.Read())
{
lUser.LIdUser = Convert.ToInt32(lReader["IdUser"].ToString());
lUser.LUser = lReader["Usuario"].ToString();
lUser.LfNameUser = lReader["FName"].ToString();
lUser.LsNameUser = lReader["SName"].ToString();
lUser.LPassword = lReader["PasswordHash"].ToString();
lUser.LStatus = new BoStatus {
LIdStatus = lReader["IdStatus"].ToString()
};
lUser.LfLastName = lReader["FLastName"].ToString();
lUser.LEmail = lReader["Email"].ToString();
lUser.LObject = new BoObject {
LIdObject = Convert.ToInt32(lReader["IdObject"].ToString())
};
}
}
Dao_CloseSqlconnection(lConex);
return(lUser);
}
catch (Exception e)
{
lUser = new BoUser
{
LException = e.Message,
LMessageDao = BoErrors.MsgErrorGetSql
};
if (e.InnerException != null)
{
lUser.LInnerException = e.InnerException.ToString();
}
Dao_CloseSqlconnection(lConex);
return(lUser);
}
}
}
public string Dao_InsertUser(BoUser pUser)
{
this.LListParam = new List <SqlParameter>();
dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdTypeIdentification", pUser.LTypeIdentification.LIdTypeIdentification.ToString());
dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@NoIdentification", pUser.LNoIdentification);
dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@FName", pUser.LfNameUser);
dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@SName", pUser.LsNameUser);
dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@FLastName", pUser.LfLastName);
dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@SLastName", pUser.LsLastName);
dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdObject", pUser.LObject.LIdObject.ToString());
dao_Addparameters(this.LListParam, SqlDbType.DateTime, "@BirthDate", pUser.LBirthDate.ToString(CultureInfo.CurrentCulture));
dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@User", pUser.LUser);
dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@Password", pUser.LPassword);
dao_Addparameters(this.LListParam, SqlDbType.VarChar, "@IdStatus", pUser.LStatus.LIdStatus);
dao_Addparameters(this.LListParam, SqlDbType.Int, "@IdRole", pUser.LRole.LIdRole.ToString());
return(Dao_executeSqlTransactionWithProcedement(this.LListParam, "LTranInsertUser", "spr_CreateUser"));
}
public string bll_InsertUser(BoUser pUser)
{
return(this.LiDaoUser.Dao_InsertUser(pUser));
}