public static async Task <HttpResponseMessage> Run( [HttpTrigger(AuthorizationLevel.Function, "put", Route = "users/{id}")] HttpRequestMessage req, string id, [Table(TableNames.User, Connection = "AzureWebJobsStorage")] CloudTable outTable, TraceWriter log) { var json = await req.Content.ReadAsStringAsync(); var model = JsonConvert.DeserializeObject <UserModel>(json); var user = new UserEnity() { PartitionKey = id, RowKey = id, Name = model.Name, AccessToken = model.AccessToken, RefreshToken = model.RefreshToken, TokenExpiry = model.TokenExpiry }; var updateOperation = TableOperation.InsertOrReplace(user); var result = outTable.Execute(updateOperation); return(new HttpResponseMessage((HttpStatusCode)result.HttpStatusCode)); }
public Status Login1(UserEnity user) { DbParameter[] parameter = { DataParameter.GetSqlParam(dbUserEnity.UserName.ToString(), SqlDbType.VarChar, 50, user.UserName, ParameterDirection.Input), DataParameter.GetSqlParam(dbUserEnity.Password.ToString(), SqlDbType.VarChar, 50, user.Password, ParameterDirection.Input), DataParameter.GetSqlParam("RETURN_VALUE", SqlDbType.Int, 0, ParameterDirection.Output), }; try { int RES = CommonDBFunctions.ExecuteNonQuery(spUser.spUserLogin.ToString(), parameter, true); string success = string.Empty; switch (RES) { case 1: success = AppConstant.SuccessMsg; break; case 2: success = "User Removed"; break; case 8: success = "User Locked"; break; case 9: success = "Not activation"; break; } return(new Status() { StatusId = AppConstant.Success, MsgDesc = success }); } catch (SqlException ex) { throw ex; } }
public Login Login(UserEnity user) { DbParameter[] parameter = { DataParameter.GetSqlParam(dbUserEnity.UserName.ToString(), SqlDbType.VarChar, 50, user.UserName, ParameterDirection.Input), DataParameter.GetSqlParam(dbUserEnity.Password.ToString(), SqlDbType.VarChar, 50, user.Password, ParameterDirection.Input), }; DataHelper helper = null; SqlDataReader sqlReader = null; Login objLogin = new Login(); try { helper = new DataHelper(CommonFunctions.GetConnectionString()); var drUserDetails = helper.ExecuteDataSet(spUser.spUserLogin.ToString(), parameter); if (drUserDetails.Tables.Count > 0) { foreach (DataRow dr in drUserDetails.Tables[0].Rows) { string success = string.Empty; switch (Convert.ToInt32(dr["LOGINSTATUS"])) { case 1: success = AppConstant.SuccessMsg; break; case 2: success = "User Removed"; break; case 8: success = "User Locked"; break; case 9: success = "Not activation"; break; } objLogin.status = new Status() { StatusId = AppConstant.Success, MsgDesc = success }; } if (drUserDetails.Tables.Count == 2) { foreach (DataRow dr in drUserDetails.Tables[1].Rows) { objLogin.user = new UserEnity(); objLogin.user.UserType = (Convert.ToInt32(dr[dbUserEnity.Type.ToString()]) == 1)?"user":"******"; objLogin.user.CreatedUser = UtilCipher.Encrypt(dr[dbUserEnity.CustomerID.ToString()].ToString()); objLogin.user.Email = dr[dbUserEnity.Email.ToString()].ToString(); objLogin.user.FirstName = dr[dbUserEnity.FirstName.ToString()].ToString(); objLogin.user.LastName = dr[dbUserEnity.LastName.ToString()].ToString(); objLogin.user.LastLogin = Convert.ToDateTime(dr[dbUserEnity.LastLogin.ToString()].ToString()); } } } } catch (Exception e) { } finally { if (sqlReader != null) { sqlReader.Close(); sqlReader.Dispose(); } } return(objLogin); }