public IHttpActionResult UpdateUser([FromBody] UserLogin userLogin)
{
try
{
string sSQL = "";
sSQL = "Update DBO.Usermaster set Username = '******'";
if (userLogin.Password == "")
{
}
else
{
sSQL += ", Password = '******'";
}
sSQL += " where UserID =" + userLogin.UserId;
var appBlock = new SqlDbConnectionBaseClass();
var result = appBlock.ExecuteNonQuery(sSQL);
return(Ok(result));
}
catch (Exception e)
{
Console.Write(e.StackTrace);
return(null);
}
}
public IHttpActionResult CreateNewUser([FromBody] UserLogin userLogin)
{
try
{
string sSQL = "";
sSQL = "insert into DBO.Usermaster (Username, Password, ContactName) ";
sSQL += "values('" + userLogin.Username + "', '" + userLogin.Password + "', '" + userLogin.ContactName + "')";
var appBlock = new SqlDbConnectionBaseClass();
var result1 = appBlock.ExecuteNonQuery(sSQL);
// retrieve the ID of new user and return it back
sSQL = "select UserID from Usermaster where Username='******'";
var result = appBlock.ExecuteNonQuery(sSQL);
return(Ok(result));
}
catch (Exception e)
{
Console.Write(e.StackTrace);
return(null);
}
}
public IHttpActionResult ValidateNewUser([FromBody] UserLogin userLogin)
{
string sSQL = "";
sSQL = "select count(*) as 'Column1' from Usermaster ";
sSQL += " where Username = '******'";
var appBlock = new SqlDbConnectionBaseClass();
var result = appBlock.ExecuteNonQuery(sSQL);
return(Ok(result));
}
public IHttpActionResult DeleteUserMenuMapping(int id)
{
try
{
string sSQL = "";
sSQL = "delete from APP.UserMenuMapping ";
sSQL += " where UserID =" + id;
var appBlock = new SqlDbConnectionBaseClass();
var result = appBlock.ExecuteNonQuery(sSQL);
return(Ok(result));
}
catch (Exception e)
{
Console.Write(e.StackTrace);
return(null);
}
}
public IHttpActionResult CreateUserMenuMapping([FromBody] UserMenuMapping usermenumapping)
{
try
{
string sSQL = "";
sSQL = "insert into APP.UserMenuMapping (UserID, MenuID) ";
sSQL += "values(" + usermenumapping.UserID + ", " + usermenumapping.MenuID + ")";
var appBlock = new SqlDbConnectionBaseClass();
var result = appBlock.ExecuteNonQuery(sSQL);
return(Ok(result));
}
catch (Exception e)
{
Console.Write(e.StackTrace);
return(null);
}
}
public IHttpActionResult UserLogin([FromBody] UserLogin userLogin)
{
try
{
string sSQL = "";
var oreturnValue = new AuthenticateUserReturn();
//oreturnValue.returnCount = 1;
// return Ok(oreturnValue);
var appBlock = new SqlDbConnectionBaseClass();
SqlParameter[] parameters =
{
new SqlParameter("@userName", SqlDbType.NVarChar)
{
Value = userLogin.Username
},
new SqlParameter("@password", SqlDbType.NVarChar)
{
Value = userLogin.Password
},
new SqlParameter("@usercount", SqlDbType.NVarChar)
{
Value = "-1"
}
};
//var result = appBlock.ExecuteProcedureForSelect("SpAuthenticateUser", parameters, "");
sSQL = "select * from Usermaster where username ='******' and Password = '******'";
var result = appBlock.ExecuteNonQuery(sSQL);
Console.Write("Got returned");
var json = JsonConvert.SerializeObject(result);
Console.Write(result.ToString());
return(Ok(result));
} catch (Exception e)
{
Console.Write(e.StackTrace);
return(null);
}
}
