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); } }