public ResultModel Newuser(user_Info us)
{
var ctx = HttpContext.Current;
ResultModel result = new ResultModel();
if (ctx != null)
{
try
{
result = createUser(us);
if (result.Result > 0)
{
return(result);
}
else
{
return(result);
}
}
catch (Exception ex)
{
result.Result = -1;
result.ResultMessage = ex.ToString();
return(result);
}
}
result.Result = -1;
result.ResultMessage = "DONT_HAVE_CONTEXT";
return(result);
}
public ResultModel checkLogin(user_Info u)
{
var ctx = HttpContext.Current;
ResultModel result = new ResultModel();
if (ctx != null)
{
try
{
result = dataAccess.CheckLogin(u);
if (result.Result > 0)
{
return(result);
}
else
{
return(result);
}
}
catch (Exception)
{
throw;
}
}
result.Result = -1;
result.ResultMessage = "DONT_HAVE_CONTEXT";
return(result);
}
//create user
// POST: api/User
public HttpResponseMessage Post([FromBody] user_Info u)
{
ResultModel result = respository.Newuser(u);
var response = Request.CreateResponse <ResultModel>(System.Net.HttpStatusCode.OK, result);
return(response);
}
public HttpResponseMessage Post(user_Info u)
{
ResultModel result = respository.checkLogin(u);
var responses = Request.CreateResponse <ResultModel>(System.Net.HttpStatusCode.OK, result);
return(responses);
}
public List <user_Info> GetUserOnline()
{
try
{
dataAccess.OpenConnect();
dataAccess.command = new SqlCommand(dataAccess.getuserOnline, dataAccess.sqlConnection);
dataAccess.reader = dataAccess.command.ExecuteReader();
if (dataAccess.reader.HasRows)
{
while (dataAccess.reader.Read())
{
indexId = dataAccess.reader.GetOrdinal("Id");
indexUserName = dataAccess.reader.GetOrdinal("UserName");
indexPass = dataAccess.reader.GetOrdinal("PassWordS");
indexEmail = dataAccess.reader.GetOrdinal("Email");
indexAdress = dataAccess.reader.GetOrdinal("Adress");
indexPhone = dataAccess.reader.GetOrdinal("Phone");
indexelo = dataAccess.reader.GetOrdinal("Ranks");
indexRank = dataAccess.reader.GetOrdinal("Phone");
indexOnls = dataAccess.reader.GetOrdinal("ONLSTATUS");
id = dataAccess.reader.GetInt32(indexId);
username = dataAccess.reader.GetString(indexUserName);
pass = dataAccess.reader.GetString(indexPass);
email = dataAccess.reader.GetString(indexEmail);
adress = dataAccess.reader.GetString(indexAdress);
phone = dataAccess.reader.GetInt32(indexPhone);
elo = dataAccess.reader.GetInt32(indexelo);
ranks = dataAccess.reader.GetInt32(indexRank);
onls = dataAccess.reader.GetInt32(indexOnls);
user = new user_Info(id, username, pass, email, adress, phone, elo, ranks, onls);
ListDataUser.Add(user);
}
}
}
catch (Exception e)
{
user_Info error = new user_Info();
error.UserName = e.Message;
ListDataUser.Add(error);
return(ListDataUser);
}
return(ListDataUser);
}
private ResultModel createUser(user_Info u)
{
ResultModel result = new ResultModel();
try
{
dataAccess.OpenConnect();
SqlCommand command = new SqlCommand("CreateNewUser", dataAccess.sqlConnection);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add("@pUserName", SqlDbType.VarChar, 50);
command.Parameters["@pUserName"].Value = u.UserName;
command.Parameters.Add("@pPassWord", SqlDbType.VarChar, 50);
command.Parameters["@pPassWord"].Value = u.PassWordS;
command.Parameters.Add("@pEmail", SqlDbType.VarChar, 255);
command.Parameters["@pEmail"].Value = u.Email;
command.Parameters.Add("@pAdress", SqlDbType.NVarChar, 8000);
command.Parameters["@pAdress"].Value = u.Adress;
command.Parameters.Add("@Phone", SqlDbType.VarChar, 50);
command.Parameters["@Phone"].Value = u.Phone;
command.Parameters.Add("@Result", SqlDbType.Int);
command.Parameters.Add("@ResultID", SqlDbType.Int);
command.Parameters.Add("@ResutMesseage", SqlDbType.VarChar, 50);
command.Parameters["@Result"].Direction = ParameterDirection.Output;
command.Parameters["@ResultID"].Direction = ParameterDirection.Output;
command.Parameters["@ResutMesseage"].Direction = ParameterDirection.Output;
command.ExecuteNonQuery();
result.Result = (int)command.Parameters["@Result"].Value;
if (result.Result > 0)
{
result.ResultId = (int)command.Parameters["@ResultID"].Value;
}
result.ResultMessage = command.Parameters["@ResutMesseage"].Value.ToString();
command.Dispose();
}
catch (Exception e)
{
result.ResultId = -1;
result.ResultMessage = e.Message;
return(result);
}
finally
{
dataAccess.CloseConnect();
}
return(result);
}
public user_Info getUserById(int ids)
{
try
{
var listId = context.user_Info.Find(ids);
return(listId);
}
catch (Exception e)
{
user_Info error = new user_Info();
error.UserName = e.Message;
return(error);
}
finally
{
}
}
public ResultModel CheckLogin(user_Info u)
{
ResultModel result = new ResultModel();
try
{
OpenConnect();
SqlCommand cmd = new SqlCommand("UserLogin", sqlConnection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@pUserName", SqlDbType.VarChar, 50);
cmd.Parameters["@pUserName"].Value = u.UserName;
cmd.Parameters.Add("@pPassword", SqlDbType.VarChar, 50);
cmd.Parameters["@pPassword"].Value = u.PassWordS;
cmd.Parameters.Add("@Result", SqlDbType.Int);
cmd.Parameters.Add("@ResultID", SqlDbType.Int);
cmd.Parameters.Add("@ResutMesseage", SqlDbType.VarChar, 50);
cmd.Parameters["@Result"].Direction = ParameterDirection.Output;
cmd.Parameters["@ResultID"].Direction = ParameterDirection.Output;
cmd.Parameters["@ResutMesseage"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
result.Result = (int)cmd.Parameters["@Result"].Value;
result.ResultId = (int)cmd.Parameters["@ResultID"].Value;
result.ResultMessage = cmd.Parameters["@ResutMesseage"].Value.ToString();
cmd.Dispose();
}
catch (Exception e)
{
result.Result = -1;
result.ResultMessage = e.Message;
return(result);
}
finally
{
CloseConnect();
}
return(result);
}
public ActionResult CreateUser()
{
var userInfo = new user_Info();
if (ModelState.IsValid) // this is check validity
{
using (var appoinment_Entities_db = new Appoinment_Entities())
{
userInfo.CreateRole = appoinment_Entities_db.userRoles.ToList().Select(x => new SelectListItem
{
Value = x.role_Id.ToString(),
Text = x.role_Name
});
}
return(View(userInfo));
}
else
{
return(View(userInfo));
}
}
public List <user_Info> getAllUser()
{
try
{
var list = context.Database.SqlQuery <user_Info>("sp_getAllUser").ToList();
ListDataUser = list;
return(ListDataUser);
}
catch (Exception e)
{
user_Info error = new user_Info();
error.UserName = e.Message;
ListDataUser.Add(error);
return(ListDataUser);
}
finally
{
dataAccess.CloseConnect();
}
}
public ActionResult CreateUser(user_Info userInfo)
{
if (ModelState.IsValid) // this is check validity
{
using (Appoinment_Entities appoinment_Entities_db = new Appoinment_Entities())
{
userLogin userLogin = new userLogin();
doctorDetail doctorDetails = new doctorDetail();
userRole userRole = new userRole();
appoinment_Entities_db.user_Info.Add(userInfo);
appoinment_Entities_db.SaveChanges();
userLogin.FullName = userInfo.first_Name + userInfo.last_Name;
userLogin.RoleID = userInfo.role_Id;
var userName = appoinment_Entities_db.userRoles.Where(
i => i.role_Id == userLogin.RoleID).SingleOrDefault().role_Name;
userLogin.UserID = userInfo.user_Id;
userLogin.UserName = userInfo.email_Address;
userLogin.Password = userInfo.first_Name + "@123";
appoinment_Entities_db.userLogins.Add(userLogin);
appoinment_Entities_db.SaveChanges();
if (userInfo.role_Id == 2)
{
doctorDetails.doctor_Id = userInfo.user_Id;
doctorDetails.startTime = userInfo.doctorDetail.startTime;
doctorDetails.endTime = userInfo.doctorDetail.endTime;
appoinment_Entities_db.doctorDetails.Add(doctorDetails);
appoinment_Entities_db.SaveChanges();
}
}
ViewBag.Message = "User Created Succesfully";
return(View("DisplayMessage"));
}
else
{
return(RedirectToAction("CreateUser", "Home"));
}
}
